Subject: Re: [GENERAL] Bug with sequence
From: Oliver Elphick <olly@lfix.co.uk>
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: pgsql-hackers@postgresql.org
In-Reply-To: <1037828113.23925.101.camel@camel>
References: <92c0776e.0211180745.49911131@posting.google.com>
	<1037782392.29678.88.camel@linda>  <1037828113.23925.101.camel@camel>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: 20 Nov 2002 22:12:58 +0000
Message-Id: <1037830378.24840.40.camel@linda>
Mime-Version: 1.0

On Wed, 2002-11-20 at 21:35, Robert Treat wrote:
> On Wed, 2002-11-20 at 03:53, Oliver Elphick wrote:
> > On Mon, 2002-11-18 at 15:45, Thomas Aichinger wrote:
> > > Hi,
> > > 
> > > I recently installed pg 7.2.3 on my linux box and discovered that
> > > there are some problems with datatype serial and sequence.
> > > 
> > > 1.) If you create a table with a datatype serial, the corrsponding
> > > sequence will be created, but if you drop the table the sequence is
> > > not dropped.
> > 
> > This is fixed in 7.3
> > 
> 
> out of curiosity, do you know the logic that implements this fix? I have
> a couple of tables that use the same sequence; I'm wondering if dropping
> one of the tables removes the sequence or if I have to drop all tables
> before the sequence is removed

I just tried it.

I created a sequence using SERIAL when I created a table.  I used the
same sequence for another table by setting a column default to
nextval(sequence).

I deleted the first table.  The sequence was deleted too, leaving the
default of the second table referring to a non-existent sequence.


Could this be a TODO item in 7.4, to add a dependency check when a
sequence is set as the default without being created at the same time?

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                            
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If my people, which are called by my name, shall 
      humble themselves, and pray, and seek my face, and 
      turn from their wicked ways; then will I hear from 
      heaven, and will forgive their sin, and will heal 
      their land."               II Chronicles 7:14