Re: Function Hangs

Thanks. Stupid question: Where would I find the database log?

Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office

"Josh Berkus"
<josh(at)agliodbs(dot)com> To: "Patrick Hatcher" <PHatcher(at)macys(dot)com>,
Sent by: pgsql-novice(at)postgresql(dot)org
pgsql-novice-owner(at)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(at)agliodbs(dot)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