"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
In response to
pgsql-admin by date
|Next:||From: Sriram Dandapani||Date: 2006-06-19 18:41:05|
|Subject: Re: truncate partitioned table locking |
|Previous:||From: Sriram Dandapani||Date: 2006-06-19 17:11:49|
|Subject: truncate partitioned table locking|