can't drop sequence even though table is gone
От | Kevin Murphy |
---|---|
Тема | can't drop sequence even though table is gone |
Дата | |
Msg-id | 42CC44FB.7000304@genome.chop.edu обсуждение исходный текст |
Ответы |
Re: can't drop sequence even though table is gone
Re: can't drop sequence even though table is gone |
Список | 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
В списке pgsql-general по дате отправления: