Skip site navigation (1) Skip section navigation (2)

Re: Patch for BUG #2073: Can't drop sequence when created

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch for BUG #2073: Can't drop sequence when created
Date: 2006-06-27 03:22:58
Message-ID: 200606270322.k5R3MwM08878@momjian.us (view raw or flat)
Thread:
Lists: pgsql-patches
Patch applied.  Thanks.

---------------------------------------------------------------------------


Dhanaraj M wrote:
> Hi
> 
> 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
> > Details: 
> > 
> > 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
> > (foo_bar_seq).
> > 
> > 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.
> 
> -- 
>   Bruce Momjian       
> 
> ==================================================================
> 


> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2006-06-27 03:37:30
Subject: Re: [HACKERS] PQescapeIdentifier
Previous:From: Bruce MomjianDate: 2006-06-27 02:56:52
Subject: Re: pg_backup_tar.c seems anerror by win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group