I converted Skytools modules to extensions and found 2 problems: 1) Dumpable sequences are not supported - if sequence is tagged with pg_catalog.pg_extension_config_dump(), the pg_dump tries to run COPY on it.
2) If there is schema with functions, but nothing else, then when later converting it to extension by adding functions and schema to extension, later drop of that extension fails to remove schema. Proper CREATE EXT + DROP EXT works fine. To reproduce, checkout 'master' branch and go directly to module directory: $ git clone --recursive git://github.com/markokr/skytools.git $ cd skytools 1) $ cd sql/pgq && make install installcheck .. pg_dump regression > test.dump pg_dump: SQL command failed pg_dump: Error message from server: ERROR: cannot copy from sequence "batch_id_seq" pg_dump: The command was: COPY pgq.batch_id_seq TO stdout; 2) $ cd sql/pgq_coop && make install installcheck .. create extension pgq_coop from 'unpackaged'; drop extension pgq_coop; create extension pgq_coop; ERROR: schema "pgq_coop" already exists -- marko -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
