Postgres Pro
Downloads
Home   >   mailing lists

Re: can't drop sequence even though table is gone - Mailing list pgsql-general

From Douglas McNaught
Subject Re: can't drop sequence even though table is gone
Date
Msg-id m2vf3nmyei.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to can't drop sequence even though table is gone  (Kevin Murphy <murphy@genome.chop.edu>)
List pgsql-general
Tree view 
Kevin Murphy <murphy@genome.chop.edu> writes:

>  Schema |             Name             |   Type   | Owner
> --------+------------------------------+----------+-------
> public | seq_SML_sources_id           | sequence | fable
> public | seq_SML_symbols_id           | sequence | fable
> public | seq_TaggedEntities_id        | sequence | fable
>
>
> => drop sequence seq_SML_sources_id;
> ERROR:  sequence "seq_sml_sources_id" does not exist

Your sequence name is mixed case, so you need to double quote it to
avoid case folding:

drop sequence "seq_SML_sources_id";

-Doug

pgsql-general by date:

Previous
From: Kevin Murphy
Date:
Subject: can't drop sequence even though table is gone
Next
From: Douglas McNaught
Date:
Subject: Re: ms-sql OUTPUT equivalent