Joachim Wieland wrote:
> On Tue, Feb 07, 2006 at 09:49:02AM -0500, Bruce Momjian wrote:
> > > The correct solution to this is to forbid ALTER COLUMN SET DEFAULT on
> > > a serial column, but we haven't gotten around to enforcing that yet.
>
> > TODO has:
>
> > * %Disallow changing default expression of a SERIAL column
>
> This should go along with another command like
>
> ... ALTER COLUMN DROP SERIAL
>
> which drops the serial and removes the dependencies to get rid of it in a
> clean way, right?
Uh, you can drop a column or change its data type, but not drop the data
type of a column.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073