By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

sequence rename?

P: n/a
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/...st/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/...OVINGASEQUENCE
(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

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Fri, Oct 01, 2004 at 01:17:38PM -0700, ben f wrote:
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/...st/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


How about

ALTER TABLE $oldseq RENAME TO $newseq;

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Y eso te lo doy firmado con mis lágrimas" (Fiebre del Loco)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.