Re: Permissions problem with sequences

On Thu, Sep 23, 2004 at 07:29:47PM -0400, Tom Lane wrote:
> 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?

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/