I send the appropriate patch for bug #2073. This fix disallows to change the default sequence.
I ran the regression test and passed. The bug details are given below.
I am awaiting to answer for any further clarifications.
> Bug reference: 2073
> Logged by: Aaron Dummer
> Email address: aaron ( at ) dummer ( dot ) info
> PostgreSQL version: 8.0.3
> Operating system: Debian Linux
> Description: Can't drop sequence when created via SERIAL column
> If I create a table named foo with a column named bar, column type SERIAL,
> it auto-generates a sequence named foo_bar_seq. Now if I manually create a
> new sequence called custom_seq, and change the default value of foo.bar to
> reference the new sequence, I still can't delete the old sequence
> In other words, from a user's point of view, the foo table is no longer
> dependent on the foo_bar_seq, yet the system still sees it as dependent.
> I brought this topic up on the #postgresql IRC channel and the behavior was
> confirmed by AndrewSN, scampbell_, and mastermind.
Right. We have this TODO item:
* %Disallow changing default expression of a SERIAL column?
which would prevent you from changing the default expression for a
SERIAL column. So the answer is, don't do that, and in the future, we
might prevent it.
pgsql-patches by date
|Next:||From: Gevik Babakhani||Date: 2006-04-26 14:23:25|
|Subject: Patch for %Allow per-database permissions to be set via GRANT|
|Previous:||From: Bruce Momjian||Date: 2006-04-26 02:18:41|
|Subject: Re: [HACKERS] For Review: Allow WAL information to recover corrupted|