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:
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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to