Re: Transaction and table partitioning

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 data is ? 

If you reference only the sub-table then there will be no locks on the
master or other partition tables, assuming you mean to use just DML
rather than DDL. The tables are more loosely coupled than they are in
other RDBMS implementations.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com