The following bug has been logged on the website:
Bug reference: 6712
Logged by: Miroslav Šulc
Email address: miroslav.s...@fordfrog.com
PostgreSQL version: Unsupported/Unknown
Operating system: Gentoo Linux
Description:
here is the test case:
test=# create table tes
Bruce Momjian writes:
> On Fri, Jun 29, 2012 at 11:35:15PM -0400, Tom Lane wrote:
>> I think you're misjudging the core of the issue. The same thing
>> would happen if somebody dropped and recreated the public schema.
>> Or anything else that we create at initdb time but allow to be
>> dropped.
On Sat, Jun 30, 2012 at 11:12:56AM -0400, Tom Lane wrote:
> Bruce Momjian writes:
> > On Fri, Jun 29, 2012 at 11:35:15PM -0400, Tom Lane wrote:
> >> I think you're misjudging the core of the issue. The same thing
> >> would happen if somebody dropped and recreated the public schema.
> >> Or anyth
Bruce Momjian writes:
> On Sat, Jun 30, 2012 at 11:12:56AM -0400, Tom Lane wrote:
>> Did it restore the nonstandard ownership of the schema?
> No --- drop/create of the public schema produces:
> ...
> However, surprisingly, a simple pg_dump/restore also does not preserve
> the public schema permi
