strk <[EMAIL PROTECTED]> writes:
> 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.
Shame on you ;-)
> Where is this sequence-to-relation association stored so that
> i can clean it up ?
Most likely the complaint is because there's still a link from table to
sequence in pg_depend. Get rid of that pg_depend row and you should be
okay.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
