0001-sql-don-t-use-IF-NOT-EXISTS-when-creating-materializ.patch

Frédéric Péters, 04 mars 2016 15:48

Voir les différences: en ligne côte à côte

Subject: [PATCH] sql: don't use 'IF NOT EXISTS' when creating materialized
 view (#9553)

(it requires postgresql 9.5)

 wcs/sql.py | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

     def create_materialized_view_if_not_exists(conn, cur):
         if get_publisher().pg_version < 94000:
             return
         cur.execute('''CREATE MATERIALIZED VIEW IF NOT EXISTS wcs_materialized_all_forms
         try:
             cur.execute('''CREATE MATERIALIZED VIEW wcs_materialized_all_forms
                            AS SELECT * from wcs_all_forms''')
             conn.commit()
         except psycopg2.ProgrammingError:
             conn.rollback()
     @guard_postgres
     def refresh_materialized_views():
+    -

Produits Entr'ouvert » w.c.s.