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/