Apologies for raising this thread back from the dead - Zombie thread if you
like!
Very interested in the Rollup and Cube OLAP fuinctions :) Does anyone know
where this todo is in current plans. I've searched the archives but the
last patch I could find was from 2008...
Marc
--
View this mes
If you use the SERIAL (this is the auto-incrementing function that creates
sequences in the bankground for you) datatype you can accomplish it in one
go.
So:
DROP sequence hist_id_seq; -- Get rid of your old sequence
ALTER TABLE my_table DROP COLUMN hist_id; -- Remove id column
ALTER TABLE my_t
