can't drop sequence even though table is gone

From: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: can't drop sequence even though table is gone
Date: 2005-07-06 20:54:19
Message-ID: 42CC44FB.7000304@genome.chop.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

=> select * from pg_class where relname = 'seq_SML_sources_id';
relname | relnamespace | reltype | relowner | relam |
relfilenode | reltablespace | relpages | reltuples | reltoastrelid |
reltoastidxid | relhasindex | relisshared | relkind | relnatts |
relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids |
relhaspkey | relhasrules | relhassubclass | relacl
--------------------+--------------+----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+-------------+----------------+--------
seq_SML_sources_id | 2200 | 12237018 | 100 | 0 |
12237017 | 0 | 1 | 1 | 0
| 0 | f | f | S | 9
| 0 | 0 | 0 | 0 | 0 | f |
f | f | f |

Thanks,
Kevin Murphy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-07-06 21:11:06 Re: ms-sql OUTPUT equivalent
Previous Message Ying Lu 2005-07-06 20:52:07 About unsigned smallint?