From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
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:19:04 |
Message-ID: | 1120684744.8208.174.camel@state.g2switchworks.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 2005-07-06 at 15:54, Kevin Murphy wrote:
> I'm using PG 8.0.3 on Mac OS X 10.4.1.
>
> I've dropped some tables that had associated sequences, but I am unable
> to drop the sequences. I haven't noticed any errors or crashes. It
> will be easy to rebuild the whole database. I'm just reporting this
> because it seemed unusual.
>
> => \ds
> List of relations
> 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
Notice the error message says seq_sml_sources_id doesn't exist. And it
doesn't. The sequence is named seq_SML_sources_id. You need to quote
it to delete it, since postgresql folds case (to lower case) with
unquoted identifiers.
From | Date | Subject | |
---|---|---|---|
Next Message | imoir | 2005-07-06 21:20:11 | postmaster link to postgres executable |
Previous Message | Douglas McNaught | 2005-07-06 21:12:53 | Re: can't drop sequence even though table is gone |