Re: Use of Serial Datatype and Sequence Issue

Whoops--my bad--that was an issue with 7.0.3. I don't see that in my last
dump with 7.1.3. Thanks!

On a separate issue, in 7.0.3, the \connect lines would fail because the
passwords for the root user and the database owner are different, so I would
have to dump and reload as root user, otherwise the pg_class updates would
fail. Has this been solved in 7.1.3? I notice that the dump switches between
users depending on the action required. Does this require activating pg_dump
as root user, and doesn't require the database owner password, or are each
prompted when needed?

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Date: Tue, 06 Nov 2001 13:54:09 -0500
> To: Keary Suska <hierophant(at)pcisys(dot)net>
> Cc: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>, pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Use of Serial Datatype and Sequence Issue
>
> Keary Suska <hierophant(at)pcisys(dot)net> writes:
>> The bug is that CREATE staements are issued as well as SELECT nextval()
>> which readies the sequence.
>
> What version are you running? I see no such behavior in either 7.1.3 or
> current sources: pg_dump -a produces only
>
> SELECT setval ('"foo_f2_seq"', 2, 't');
>
> No sign of a CREATE SEQUENCE.
>
> regards, tom lane
>