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