Re: truncate partitioned table locking

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Sriram Dandapani" <sdandapani(at)counterpane(dot)com> 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