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: > 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 That's not the name of the sequence in question unless you've upped the number of characters in an identifier. The sequence appears to on my machine be named "fa_ccpsholderscp_hsc_serial_seq" because the name would have ended up being too long. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
