I must admit I've not read up on the various locks that are set so that's a good point. Is there a good reference for me to read and understand these?
I'm guessing though that a delete from and then an insert never requires an exclusive lock, what about adding/deleting constraints? Rob 2008/11/26 Gregory Stark <[EMAIL PROTECTED]> > Rob Kirkbride <[EMAIL PROTECTED]> writes: > > > Richard, > > > > Yes, I've changed it use TRUNCATE rather than DELETE and it's working > well for > > us now. > > I'm a bit surprised actually as it sounded like you were aiming to avoid > the > table lock. A TRUNCATE does require an exclusive lock on the table. It > still > has advantages over DROP in that there is no window when the table does not > exist and any existing references to the table from views or functions will > continue to function. > > > -- > Gregory Stark > EnterpriseDB http://www.enterprisedb.com > Ask me about EnterpriseDB's RemoteDBA services! >