Thanks. Stupid question: Where would I find the database log?
Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office
"Josh Berkus"
<josh@agliodbs.com> To: "Patrick Hatcher" <PHatcher@macys.com>,
Sent by: pgsql-novice@postgresql.org
pgsql-novice-owner@post cc:
gresql.org Subject: Re: [NOVICE] Function Hangs
02/12/2002 09:43 PM
Patrick,
> Any help would be appreciated.
> TIA
Take a look at your postgres log and see if you're getting a deadlock
warning. The last time I had a looping function lock, it was because
I was (unintentionally) trying to update the same records multiple
times ...
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html