Postgres Pro
Downloads
Home   >   mailing lists

Re: Concurrent execution of pg_relation_size and DROP TABLE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Concurrent execution of pg_relation_size and DROP TABLE
Date
Msg-id 14189.1251988532@sss.pgh.pa.us
Whole thread Raw
In response to Concurrent execution of pg_relation_size and DROP TABLE  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Tree view 
Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> 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 problems.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Triggers on columns
Next
From: Peter Eisentraut
Date:
Subject: Re: Triggers on columns