Re: Permissions problem with sequences

Michael Fuhr <mike@fuhr.org> writes:
> There is, however, an ownership problem with restoring sequences
> in 8.0.0beta.  In 7.4.5, for example, pg_dump issues a SET SESSION
> AUTHORIZATION command and then creates a table, so implicitly-created
> sequences are restored with the correct ownership.  In 8.0.0beta2,
> however, pg_dump doesn't issue SET SESSION AUTHORIZATION but rather
> creates a table and then issues ALTER TABLE ... OWNER TO.

Yeah, we still need to find a solution for that.  I'd prefer not to
back out the ALTER OWNER TO changes, but I will if nothing else
presents itself.

            regards, tom lane