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