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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]