From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [8.0.3] Not dumping all sequences ... |
Date: | 2005-08-02 21:41:27 |
Message-ID: | 20050802183825.I965@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 2 Aug 2005, Tom Lane wrote:
> "Marc G. Fournier" <scrappy(at)postgresql(dot)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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-02 21:57:16 | Re: [8.0.3] Not dumping all sequences ... |
Previous Message | Tom Lane | 2005-08-02 21:30:54 | Re: [8.0.3] Not dumping all sequences ... |