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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
