On Thu, Sep 23, 2004 at 07:29:47PM -0400, Tom Lane wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> 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?
Looks good so far. I originally noticed the sequence ownership problem when restoring a backup made with pg_dump, and that appears to work now. Thanks. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
