Re: Deadlocks? What happened to MVCC?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Deadlocks? What happened to MVCC?
Date: 2001-08-14 21:35:31
Message-ID: 20551.997824931@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

MVCC does not mean "no locks" ... particularly not when UPDATEs are
involved. You'll need to be more specific about what your function is
doing, but my first thought would be to look for the possibility of
conflicting updates of the same row.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-08-14 22:43:26 Re: psql connection being reset during function?
Previous Message Jan Wieck 2001-08-14 20:46:45 Re: Deadlocks? What happened to MVCC?