Re: [HACKERS] Concurrent execution of pg_relation_size and DROP TABLE

2009-09-03 Thread Tom Lane
Itagaki Takahiro writes: > Is it reasonable to replace relation_open() calls to try_relation_open() ? I don't think so; that's just papering over one form of the problem, and who's to say that an error is not desirable when a wrong OID is given? In general there's always a risk of concurrency pr

[HACKERS] Concurrent execution of pg_relation_size and DROP TABLE

2009-09-03 Thread Itagaki Takahiro
I received a trouble-report that a query using pg_relation_size() ends with an error, "could not open relation". It came from DROP TABLE was executed concurrently; relation_open() used in pg_relation_size() raised an error. Is it reasonable to replace relation_open() calls to try_relation_open()