Hi, I'm getting a dependency loop issue with pg_dump when adding a schema to an extension where the schema being added is the same as the one containing the extension.
CREATE EXTENSION file_fdw; ALTER EXTENSION file_fdw ADD SCHEMA public; $ pg_dump -f /dev/null test pg_dump: [sorter] WARNING: could not resolve dependency loop among these items: pg_dump: [sorter] SCHEMA public (ID 5 OID 2200) pg_dump: [sorter] EXTENSION file_fdw (ID 170 OID 28912) or CREATE SCHEMA meow; CREATE EXTENSION file_fdw WITH SCHEMA meow; ALTER EXTENSION file_fdw ADD SCHEMA meow; $ pg_dump -f /dev/null test pg_dump: [sorter] WARNING: could not resolve dependency loop among these items: pg_dump: [sorter] SCHEMA meow (ID 7 OID 28917) pg_dump: [sorter] EXTENSION file_fdw (ID 171 OID 28918) but not CREATE SCHEMA meow; CREATE EXTENSION file_fdw WITH SCHEMA meow; ALTER EXTENSION file_fdw ADD SCHEMA public; $ pg_dump -f /dev/null test3 $ (no errors shown) I can produce this issue in 9.1.4 and head (as of commit 83af58f6b5657840f5924332fccecca1e3556abe). Since this is a bug report, I'll include the necessary supporting info: OS: Linux Mint x64 Kernel: 3.2.0-27-generic CC version: Linaro 4.6.3-1ubuntu5 RAM: 16GB DDR3 -- Thom - Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs