Postgres Pro
Downloads
Home   >   mailing lists

Re: update functions locking tables - Mailing list pgsql-general

From Tom Lane
Subject Re: update functions locking tables
Date
Msg-id 15936.1125365702@sss.pgh.pa.us
Whole thread Raw
In response to update functions locking tables  (Clodoaldo Pinto <clodoaldo.pinto@gmail.com>)
Responses Re: update functions locking tables  (Clodoaldo Pinto <clodoaldo.pinto@gmail.com>)
List pgsql-general
Tree view 
Clodoaldo Pinto <clodoaldo.pinto@gmail.com> writes:
> I've been trying for 3 days to figure out what is happening to no
> avail. What am i missing about transactions and MVCC? What could make
> a plpgsql update function lock a table?

What is the function doing to the table, exactly?  DDL changes generally
take exclusive locks ...

            regards, tom lane

pgsql-general by date:

Previous
From: Clodoaldo Pinto
Date:
Subject: update functions locking tables
Next
From: Michael Fuhr
Date:
Subject: Re: update functions locking tables