Re: [GENERAL] Sequences/defaults and pg_dump

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, 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 20:16:10
Message-ID: 20060209201610.GH7693@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Tom Lane wrote:

> The only thing we'd lose is that dropping a column
> originally declared as serial wouldn't implicitly drop the sequence.

Wasn't that the primary purpose that the main coder for dependencies did
the work for? AFAIR the fact that the sequence wasn't dropped was a big
gotcha. Everyone was annoyed any time they wanted to experiment with
creating and dropping a table.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike G. 2006-02-09 20:21:16 Update table with data from another table
Previous Message Tom Lane 2006-02-09 20:12:02 Re: [GENERAL] Sequences/defaults and pg_dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-02-09 20:16:29 Re: Upcoming re-releases
Previous Message Greg Stark 2006-02-09 20:13:22 Re: PostgreSQL 8.0.6 crash