Postgres Pro
Downloads
Home   >   mailing lists

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

From Itagaki Takahiro
Subject Concurrent execution of pg_relation_size and DROP TABLE
Date
Msg-id 20090903184308.336A.52131E4D@oss.ntt.co.jp
Whole thread Raw
Responses Re: Concurrent execution of pg_relation_size and DROP TABLE
List pgsql-hackers
Tree view 
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() ?
If failed, pg_relation_size() will just return NULLs.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Fwd: Copy out wording
Next
From: Sergey Konoplev
Date:
Subject: Re: Feature request: DEFAULT as input value of function argument