Re: [GENERAL] Bug with sequence

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Bug with sequence
Date: 2002-11-21 19:14:56
Message-ID: 200211211914.gALJEuZ21767@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

Oliver Elphick wrote:
> 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?

Added to TODO:

* Have sequence dependency track use of DEFAULT sequences, seqname.nextval

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-11-21 19:17:00 Re: Welcom & a problem
Previous Message Bruce Momjian 2002-11-21 19:11:08 Re: [HACKERS] [GENERAL] Bug with sequence

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-11-21 19:17:02 Re: Why an array in pg_group?
Previous Message Tom Lane 2002-11-21 19:14:44 Re: Error when comparing an integer to an empty string.

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2002-11-21 19:22:46 Re: [HACKERS] [GENERAL] Bug with sequence
Previous Message Bruce Momjian 2002-11-21 19:11:08 Re: [HACKERS] [GENERAL] Bug with sequence