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 pg_cl

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 rem

[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 pg_