Home > mailing lists

Re: Default Access Exclusive Lock on Update? - Mailing list pgsql-general

From	seth.m.green@gmail.com
Subject	Re: Default Access Exclusive Lock on Update?
Date	March 4, 2006 20:21:37
Msg-id	1141310221.910367.137890@i40g2000cwc.googlegroups.com Whole thread Raw
In response to	Default Access Exclusive Lock on Update? (seth.m.green@gmail.com)
List	pgsql-general

Tree view

For anyone that is interested, my problem was solved on another list.
Turns out the TRUNCATE command that I run at the beginning of the SP
creates and holds an access exclusive lock on the table for the entire
duration of the SP.  I changed it to DELETE FROM and my problem was
fixed.

Full discussion here -> http://tinyurl.com/rp9jx

pgsql-general by date:

From: "William Penberthy"
Date: 04 March 2006, 16:43:25
Subject: Re: Using same database from XP and Linux in notebook

From: Perez
Date: 04 March 2006, 20:21:38
Subject: xml and utf-8

Re: Default Access Exclusive Lock on Update? - Mailing list pgsql-general

Previous

Next