Re: truncate partitioned table locking

["Aaron Bono" <postgresql@xxxxxxxxxx>]

I am curious, why would a query on a parent table, A, put a lock on a child table, B?  If the query doesn't touch B or any of its children, why would PostgreSQL care what happens to the child table during its query?

-Aaron

On 6/19/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

"Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes:
> I have master table A, inherited by Table B and Table C

> Does the truncation of a child table take a lock on the master table ?

No, but it certainly locks the child table ... and queries on A are
going to try to scan all three tables.

                        regards, tom lane