/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 10146

schemas/util.sql: try_create(), create_if_not_exists(): use eval() so the executed statement will be echoed for debugging

         LANGUAGE plpgsql STRICT
         AS $$
     BEGIN
         EXECUTE sql;
         PERFORM util.eval(sql);
     EXCEPTION
         WHEN duplicate_table  THEN NULL;
         WHEN duplicate_column THEN NULL;
-...
         LANGUAGE plpgsql STRICT
         AS $$
     BEGIN
         EXECUTE sql;
         PERFORM util.eval(sql);
     EXCEPTION
         WHEN wrong_object_type THEN NULL; -- trying to alter a view's columns
         WHEN undefined_column THEN NULL;

Also available in: Unified diff