| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | strk <strk(at)keybit(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: sticky sequence |
| Date: | 2003-12-30 16:33:36 |
| Message-ID: | 3FF1A8E0.9010207@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | 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 ?
It's stored in the pg_depend table. See here:
http://www.postgresql.org/docs/current/static/catalog-pg-depend.html
A really good reason to disable manual catalog modifications by default :)
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-12-30 16:39:55 | Objects in schemas question |
| Previous Message | Tom Lane | 2003-12-30 16:29:04 | Re: sticky sequence |