sticky sequence

From: strk <strk(at)keybit(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: sticky sequence
Date: 2003-12-30 10:30:30
Message-ID: 20031230113030.A28292@freek.keybit.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bret Busby 2003-12-30 10:40:01 Re: Is my MySQL Gaining ?
Previous Message Michael Gill 2003-12-30 09:53:27 Restrict users from describing table