Re: can't drop sequence even though table is gone

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: can't drop sequence even though table is gone
Date: 2005-07-06 21:12:53
Message-ID: m2vf3nmyei.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin Murphy <murphy(at)genome(dot)chop(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-07-06 21:19:04 Re: can't drop sequence even though table is gone
Previous Message Douglas McNaught 2005-07-06 21:11:06 Re: ms-sql OUTPUT equivalent