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

Bug #581: Sequence cannot be deleted

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #581: Sequence cannot be deleted
Date: 2002-02-12 01:26:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-hackers
BAZIN Nicolas (nbazin(at)ingenico(dot)com(dot)au) 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:
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)

but when I try to delete it with the following command:
DROP SEQUENCE fa_ccpsholderscpt_hsc_serial_seq

I get this error:
sequence "fa_ccpsholderscpt_hsc_serial_se" does not exist

I work with version 7.1.3 on Openserver 5.0.5, gcc 2.95.3 and send the SQL commands through the JDBC driver.

Sample Code

No file was uploaded with this report


pgsql-hackers by date

Next:From: Stephan SzaboDate: 2002-02-12 02:14:31
Subject: Re: Bug #581: Sequence cannot be deleted
Previous:From: Tom LaneDate: 2002-02-12 00:49:57
Subject: Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-02-12 01:38:43
Subject: Bug #582: no mapping for java.sql.Types.DECIMAL
Previous:From: Blossom, EricDate: 2002-02-12 00:09:45
Subject: Re: Initdb Hangs

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