Re: [BUGS] Bug #581: Sequence cannot be deleted

2002-02-11 Thread Stephan Szabo
On Mon, 11 Feb 2002 [EMAIL PROTECTED] wrote: > BAZIN Nicolas ([EMAIL PROTECTED]) reports a bug with a severity of 1 > The lower the number the more severe it is. > > Short Description > Sequence cannot be deleted > > Long Description A Sequence is created automatically with the SQL > command: >

Re: [BUGS] Bug #581: Sequence cannot be deleted

2002-02-11 Thread Tom Lane
[EMAIL PROTECTED] writes: > A Sequence is created automatically with the SQL command: > CREATE TABLE fa_ccpsholderscpt(hsc_serial SERIAL NOT NULL ,chd_serial INTEGER NOT >NULL ,hsc_respcode CHAR(2) NOT NULL ,scp_code CHAR(4) NOT NULL ,imp_flag SMALLINT) Okay, let's try it ... regression=# CRE