can't drop sequence even though table is gone

[Kevin Murphy <murphy@xxxxxxxxxxxxxxx>]

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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org