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/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
