"Marc G. Fournier" <[EMAIL PROTECTED]> 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;
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
