Re: pg_dump dependency loop with extension containing its own schema - Mailing list pgsql-bugs

From Thom Brown
Subject Re: pg_dump dependency loop with extension containing its own schema
Date
Msg-id CAA-aLv6jhN-x-3W8U=An6cTUPWKPu1j_xbvcan1FnV1rYQAChQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump dependency loop with extension containing its own schema  (Thom Brown <thom@linux.com>)
Responses Re: pg_dump dependency loop with extension containing its own schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 12 August 2012 08:17, Thom Brown <thom@linux.com> wrote:
> On 12 August 2012 01:06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Thom Brown <thom@linux.com> writes:
>>> 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;
>>
>> ISTM we ought to disallow that ... either the schema is inside the
>> extension, or vice versa, it's not sensible to say both.
>
> Precisely.

Suggested changes attached. (not really confident about it though)

--
Thom

Attachment

pgsql-bugs by date:

Previous
From: valgog@gmail.com
Date:
Subject: BUG #7494: WAL replay speed depends heavily on the shared_buffers size
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size