sequences not renamed with tables - Mailing list pgsql-general

From CSN
Subject sequences not renamed with tables
Date
Msg-id 20031211064401.99551.qmail@web40604.mail.yahoo.com
Whole thread Raw
Responses Re: sequences not renamed with tables  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general
I'm getting these errors when importing dumps:

ERROR:  relation "table1_id_seq" does not exist
ERROR:  relation "table2_id_seq" does not exist

I renamed a couple tables, and the names of their
corresponding sequences remained the same. This causes
a problem because when importing - the create table
statements create sequences with different names, then
the setval() statements use the old names. Any way to
automatically avoid this "gotcha"?

Thanks,
CSN


__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: [NOVICE] PostgreSQL Training
Next
From: Shridhar Daithankar
Date:
Subject: Re: Users and session ids