Re: bug# 2073 - Clarification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bug# 2073 - Clarification
Date: 2006-04-24 16:06:02
Message-ID: 2356.1145894762@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM> writes:
> Pl. look at the following code, which is taken from alter_table.sql
> (regression test)

The regression test is designed to check for the current behavior.
If we were to change the behavior, then of course we'd need to change
the regression test as well.

Personally I'm starting to like the idea of attaching the sequence's
dependency to the column default definition (ie, to the attrdef entry
not directly to the column). That would mean that ALTER COLUMN DROP
DEFAULT would be allowed and would cause the sequence to go away.
I'm not sure about whether this would have any downsides, though.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2006-04-24 16:29:11 Re: Further reduction of bufmgr lock contention
Previous Message Gevik Babakhani 2006-04-24 14:05:36 Re: TODO Item: ACL_CONNECT