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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly