Re: Sequences/defaults and pg_dump

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
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 08:35:59
Message-ID: 20060208083559.GA7642@mcknight.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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?

Joachim

--
Joachim Wieland joe(at)mcknight(dot)de
C/ Usandizaga 12 1°B ICQ: 37225940
20002 Donostia / San Sebastian (Spain) GPG key available

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-02-08 09:26:23 Re: Is there a way to limit CPU usage per user
Previous Message Sergey Karin 2006-02-08 07:42:41 alter superuser...

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2006-02-08 08:41:06 Re: Audio interview
Previous Message Tom Lane 2006-02-08 05:49:51 Re: sql row constructor...works!