Re: [HACKERS] Transaction and table partitioning

2006-07-03 Thread Greg Stark
"Dragan Zubac" <[EMAIL PROTECTED]> writes: > 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

Re: [HACKERS] Transaction and table partitioning

2006-07-03 Thread Bruno Wolff III
On Mon, Jul 03, 2006 at 14:59:49 +0200, Dragan Zubac <[EMAIL PROTECTED]> wrote: > > 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),

Re: [HACKERS] Transaction and table partitioning

2006-07-03 Thread Simon Riggs
On Mon, 2006-07-03 at 14:59 +0200, Dragan Zubac wrote: > 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

[HACKERS] Transaction and table partitioning

2006-07-03 Thread Dragan Zubac
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