Re: [GENERAL] Apparent race in information_schema.tables

2009-05-11 Thread Tom Lane
Florian Weimer writes: > This query: > SELECT 1 FROM information_schema.tables WHERE table_schema = $1 AND > table_name = $2; > fails sporadically with the error "relation with OID does not > exist". > I guess the OID refers to a temporary table because I can't find it in > pg_class, and the c

[GENERAL] Apparent race in information_schema.tables

2009-05-11 Thread Florian Weimer
This query: SELECT 1 FROM information_schema.tables WHERE table_schema = $1 AND table_name = $2; fails sporadically with the error "relation with OID does not exist". The query is run by a non-superuser, and the table/schema combination exists in the database. The query may have been PREPAREd