From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [8.0.3] Not dumping all sequences ... |
Date: | 2005-08-02 22:32:56 |
Message-ID: | 20050802191716.M965@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:
>> On Tue, 2 Aug 2005, Tom Lane wrote:
>>> 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" ...
>
> Hmm, odd. But maybe there are traces of a SERIAL linkage? What do
> you get from
>
> select * from pg_depend where objid = 'xa_url_id_seq'::regclass;
# select * from pg_depend where objid = 'xa_url_id_seq'::regclass;
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
---------+--------+----------+------------+----------+-------------+---------
1259 | 335539 | 0 | 16672 | 2200 | 0 | n
1259 | 335539 | 0 | 1259 | 335541 | 1 | i
(2 rows)
'k, checking the docs ... deptype == i is an INTERNAL, and refobjid is
what is referencing it (in this case, xa_url, as I'd expect) ... but,
looking at \d for xa_url, I'm not seeing anything there to cause it ... no
serial values ... the only 'default nextval()' I can find in the schema
is something totally unrelated ...
next? :)
----
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 22:36:52 | Re: [8.0.3] Not dumping all sequences ... |
Previous Message | Tom Lane | 2005-08-02 21:57:16 | Re: [8.0.3] Not dumping all sequences ... |