On Wed, Jul 18, 2007 at 03:10:30PM +0200, Nico Sabbi wrote:
> Hi,
> as the subjects reads I searched in the docs a way to instruct postgres
> to create new sequences when copying tables containing serial columns,
> but the resulting serial fields in the new tables reference the
> original sequence.
That's the right behavior. You should be using
pg_get_serial_sequence('your_table','your_column')
to get the sequence name anyhow. :)
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate