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
