| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Joachim Wieland <joe(at)mcknight(dot)de> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, nikolay(at)samokhvalov(dot)com, PostgreSQL-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Sequences/defaults and pg_dump |
| Date: | 2006-02-08 14:03:54 |
| Message-ID: | 200602081403.k18E3sA04436@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl O. Pinc | 2006-02-08 14:48:06 | Confirming the autovacuum daemon is running |
| Previous Message | Richard Huxton | 2006-02-08 12:53:00 | Re: Problem with sequence table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Woodward | 2006-02-08 14:26:29 | Re: pg_hba.conf alternative |
| Previous Message | Bruce Momjian | 2006-02-08 14:00:46 | Re: Audio interview |