Re: [GENERAL] Sequences/defaults and pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Joachim Wieland <joe(at)mcknight(dot)de>, nikolay(at)samokhvalov(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Sequences/defaults and pg_dump
Date: 2006-02-09 19:55:17
Message-ID: 4077.1139514917@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> Is it also desired to convert an int column to a serial column?

> I think the only sane solution is if a SERIAL column is changed to
> INTEGER, the default and dependencies are removed. Do you want a TODO
> for that?

If we are going to do something like that, I think we should take a hard
look at the idea I floated of putting SERIAL back to a pure
creation-time macro for type and default expression. This is getting to
have way too much hidden behavior, and what we are buying for it is very
little as of 8.1.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-02-09 19:59:45 Re: [GENERAL] Sequences/defaults and pg_dump
Previous Message Bruce Momjian 2006-02-09 19:49:19 Re: [GENERAL] Sequences/defaults and pg_dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-02-09 19:59:45 Re: [GENERAL] Sequences/defaults and pg_dump
Previous Message Stephen Frost 2006-02-09 19:53:44 Re: PostgreSQL 8.0.6 crash