So I am renaming a table, and the last stumbling block that I've met is the associated sequence. I tried the commands suggested @
http://mailman.fastxs.net/pipermail/dbmail-dev/2004-August/004307.html ie: CREATE SEQUENCE $newseq SELECT setval('$newseq', max($column)) FROM $table ALTER TABLE $table ALTER COLUMN $column SET DEFAULT nextval('$newseq'::text) DROP SEQUENCE $oldseq but when trying to perform the DROP SEQUENCE (psql), i get a message like: ERROR: Cannot drop sequence $oldseq because table $table column $column requires it You may drop table $table column $column instead After that, I tried the query suggested here: http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x14316%2ehtm#REMOVINGASEQUENCE (example 7-34) And it came back empty. What am I doing wrong? when i \d $table, it shows no such dependency. Is there another way to pull this off? thanks ben ps -- please cc responses directly to me, since i'm not a subscriber. _______________________________ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
