Quick Links

Transaction and table partitioning

From:	"Dragan Zubac" <zubacdragan(at)gmail(dot)com>
To:	pgsql-hackers(at)postgresql(dot)org
Subject:	Transaction and table partitioning
Date:	2006-07-03 12:59:49
Message-ID:	904911fb0607030559m1b83b9edj939f7377d5872347@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Hello

Is it possible to use transactions with 'per sub table' locks? What I
mean,if I partition a table and use transaction on that table with
constraint,will the database lock the master table (and all subtables),or
only sub table where the data is ?

Sincerely

Dragan Zubac

Responses

Re: Transaction and table partitioning at 2006-07-03 16:44:08 from Simon Riggs
Re: Transaction and table partitioning at 2006-07-03 17:03:40 from Bruno Wolff III
Re: Transaction and table partitioning at 2006-07-04 01:22:52 from Greg Stark

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	paolo romano	2006-07-03 12:59:50	Re: [COMMITTERS] pgsql: Do a pass of code review for the ALTER TABLE
Previous Message	Sven Geisler	2006-07-03 12:41:39	Re: patch postgresql for AMD64 (Opteron)