[HACKERS] sticky sequence

2003-12-30 Thread strk
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

Re: [HACKERS] sticky sequence

2003-12-30 Thread Tom Lane
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

Re: [HACKERS] sticky sequence

2003-12-30 Thread Christopher Kings-Lynne
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