sticky sequence

Поиск
Список
Период
Сортировка
От strk
Тема sticky sequence
Дата
Msg-id 20031230113030.A28292@freek.keybit.net
обсуждение исходный текст
Ответы Re: sticky sequence  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: sticky sequence  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
I cannot get rid of a sequence:
gis=# drop sequence geopol.geology_gid_seq;ERROR:  cache lookup of relation 8511697 failed

Yes, geology_gid_seq have been created as a consequence of a
geology.gid attribute of type serial.
And.. yes, I've removed the relation with a delete on pg_class.
Where is this sequence-to-relation association stored so that
i can clean it up ?

NOTE: vacuum full does not solve this.

TIA

-strk;


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Concurrence GiST
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] update i386 spinlock for hyperthreading