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 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to