pg_dump and sequences (bug ?)

From: strk <strk(at)keybit(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump and sequences (bug ?)
Date: 2004-08-07 12:11:07
Message-ID: 20040807121107.GA15773@freek.keybit.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Using pg_dump from postgresql 7.3.4 I've obtained
a dump file containing a SEQUENCE SET with no
corresponding SEQUENCE. I've seen that this is usually
due to the presence of a table with a 'serial' field,
but since in this case there is no such table I wonder
if this is a bug in pg_dump.

The only reason I can imagine for this is pg_dump taking
any sequence whose name ends in _seq as being associated
to a table, no matter if that table exists and has a 'serial'
field. Is this possible ? Shouldn't this kind of dependency
be coded somehow ?

TIA

--strk;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dennis Bjorklund 2004-08-07 12:47:43 Re: [PATCHES] UNICODE characters above 0x10000
Previous Message Dennis Bjorklund 2004-08-07 11:11:28 Re: [PATCHES] UNICODE characters above 0x10000