Sorry folks, this is a red-herring, my hack didn't have anything to do with it. It occurs with or without the index. Question is was there a bug between 7.4 and 7.4.1 which may have caused this?
Dave On Tue, 2004-01-13 at 16:30, Dave Cramer wrote: > I have hacked analyze.c to automatically create a unique index on the > oid when a table is created and I am getting the failed to re-find > parent key in pg_attribute_relid_attnam_index every 8 attempts to do the > following > > select * from foo into temp a; > drop table a; > > Currently analyze does not create the oid index on the select into. > > I realize this is beyond the realm of supported code, but can anyone > tell me what's going on or a better way to fix it. > > BTW, the real problem is that select * from foo where oid=? doesn't use > an index scan. > > Dave -- Dave Cramer 519 939 0336 ICQ # 1467551 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
