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
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? |