Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id AC76C4753A1
	for <pgsql-hackers@postgresql.org>;
	Thu, 21 Nov 2002 00:03:32 -0500 (EST)
Received: from new-smtp2.ihug.com.au (new-smtp2.ihug.com.au [203.109.250.28])
	by postgresql.org (Postfix) with ESMTP id 22EAA476173
	for <pgsql-hackers@postgresql.org>;
	Thu, 21 Nov 2002 00:03:31 -0500 (EST)
Received: from p261-tnt2.mel.ihug.com.au (postgresql.org) [203.173.165.7]
	by new-smtp2.ihug.com.au with esmtp (Exim 3.22 #1 (Debian))
	id 18EjUs-0000FP-00; Thu, 21 Nov 2002 16:03:26 +1100
Message-ID: <3DDC6916.94FDCB3F@postgresql.org>
Date: Thu, 21 Nov 2002 16:03:18 +1100
From: Justin Clift <justin@postgresql.org>
X-Mailer: Mozilla 4.8 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Oliver Elphick <olly@lfix.co.uk>,
	Robert Treat <xzilla@users.sourceforge.net>, pgsql-hackers@postgresql.org
Subject: Re: [GENERAL] Bug with sequence
References: <92c0776e.0211180745.49911131@posting.google.com>
	<1037782392.29678.88.camel@linda>
	<1037828113.23925.101.camel@camel>
	<1037830378.24840.40.camel@linda>
	<3DDC47A9.4C0BC2DE@postgresql.org> <7017.1037851915@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/842
X-Sequence-Number: 32058

Tom Lane wrote:
> 
> Justin Clift <justin@postgresql.org> writes:
> > Oliver Elphick wrote:
> >> 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.
> 
> > This sounds like a serious bug in our behaviour, and not something we'd
> > like to release.
> 
> We will be releasing it whether we like it or not, because
> nextval('foo') doesn't expose any visible dependency on sequence foo.

Awww rats.

<snip>
> 7.3 breaks no existing schemas, because older schemas will be dumped
> as separate CREATE SEQUENCE and CREATE TABLE ... DEFAULT nextval()
> commands.

Ok.

Thanks Tom.  :)

Regards and best wishes,

Justin Clift

>                         regards, tom lane

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi