Re: 8.0.0beta1: Ownership of implicit sequences after dump/restore

On Wed, Aug 11, 2004 at 08:56:27PM -0600, Michael Fuhr wrote:
> PostgreSQL version: 8.0.0beta1
> Operating system  : Solaris 9
>
> Backups created by pg_dump/pg_dumpall don't set the ownership of
> implicitly-created sequences.  When backups are restored, users who
> created sequences may not be able to use them.

[snip]

> Is this a bug in pg_dump/pg_dumpall, or is it a bug in the ALTER
> TABLE ... OWNER TO statement that set the ownership of the table
> that implicitly created the sequence?  It seems reasonable that
> changing a table's ownership should also change the ownership of
> any implicitly-created sequences, or has that already been discussed
> and rejected?

Any feedback on this?  It'll cause problems as people migrate their
databases to 8.0.0.

Here's the complete text of my original message:

http://archives.postgresql.org/pgsql-bugs/2004-08/msg00086.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/