Postgres Pro
Downloads
Home   >   mailing lists

Re: share lock error - Mailing list pgsql-general

From Tom Lane
Subject Re: share lock error
Date
Msg-id 15973.1160111096@sss.pgh.pa.us
Whole thread Raw
In response to Re: share lock error  (Terry Fielder <terry@ashtonwoodshomes.com>)
List pgsql-general
Tree view 
Terry Fielder <terry@ashtonwoodshomes.com> writes:
> 7.4.3

Yoi.  You need to think about an update.

> And the records are gone from pg_locks, how much time after the deadlock
> do I have before they are purged?

Approximately none --- pg_locks is a live view.

            regards, tom lane

pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: Storing images in PostgreSQL databases (again)
Next
From: "A. Kretschmer"
Date:
Subject: Re: how to check SQLSTATE