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/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
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
