Re: [8.0.3] Not dumping all sequences ...

On Tue, 2 Aug 2005, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> Have databse that \ds shows several sequences, but one in partiicular, I
>> can't seem to 'dump' with pg_dump:
>
>>   public | xa_url_id_seq                   | sequence | pareto_su
>
> Given the name, this could be a SERIAL column's sequence --- which is
> not dumped as a separate object by pg_dump, since recreating the SERIAL
> column ought to create it.

One of their functions does an insert into the table with 
"nextval('xa_url_id_seq'::text)" as part of the INSERT itself, so they 
aren't using that field as a SERIAL type ... just checked the CREATE TABLE 
for teh table, and its defined as a "bigint NOT NULL" ... so we're not 
dealing with a SERIAL field, as far as I can tell ... in fact, grep'ng 
their whole schema, they don't use SERIAL fields at all ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664