Re: Permissions problem with sequences

Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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.

> Oer.  I'd better look at that :(

I think Alvaro's patch to make ALTER TABLE OWNER recurse to serial
sequences fixes all the issues that were raised in this thread ---
does anyone see any remaining problems?

            regards, tom lane