BUG #8174: Ownership reassigned public schema restored with postgres as owner

From: polobo(at)yahoo(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8174: Ownership reassigned public schema restored with postgres as owner
Date: 2013-05-21 22:25:03
Message-ID: E1UeuzP-00025m-1h@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8174
Logged by: David Johnston
Email address: polobo(at)yahoo(dot)com
PostgreSQL version: 9.0.13
Operating system: Ubuntu Linux 10.04
Description:

Having performed a "pg_dump --schema_only --format=c" of a database I used
"pg_restore -C" (after dumping and loading globals) to recreate the database
on a new machine and the owner of the "public" schema on the new machine was
"postgres" while the owner within the existing database is not. There are
numerous other schemas in the database for which the owner is the "not
postgres" user and all of those schemas have the proper ownership assigned -
it is just the public schema that is at issue. The database itself is
(correctly) created with ownership assigned to this other role as well.

I would expect that the public schema owner would match that in the source
database but maybe I am missing something.

David J.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message dan.libby 2013-05-22 00:56:57 BUG #8175: Check constraint fails for valid data. ( rounding related? )
Previous Message lalbin 2013-05-21 22:20:50 BUG #8173: Inserting heap tuples in bulk in COPY patch return wrong line on failure 999 out of 1000 times.