Re: Bug #581: Sequence cannot be deleted

On Mon, 11 Feb 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> 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

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.