Skip site navigation (1) Skip section navigation (2)

pg_dump dependency loop with extension containing its own schema

From: Thom Brown <thom(at)linux(dot)com>
To: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_dump dependency loop with extension containing its own schema
Date: 2012-08-11 22:55:07
Message-ID: CAA-aLv5tDs1y2cCc2+qh5encuJWA=rLq-crF3B=WWptTA=RB6Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-08-12 00:06:23
Subject: Re: pg_dump dependency loop with extension containing its own schema
Previous:From: Tom LaneDate: 2012-08-11 15:02:09
Subject: Re: Bug when changing datatype of primary key column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group