Re: Sequences/defaults and pg_dump

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