Skip site navigation (1) Skip section navigation (2)

Re: Function Hangs

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: josh(at)agliodbs(dot)com
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org
Subject: Re: Function Hangs
Date: 2002-02-13 18:07:52
Message-ID: OFE470AA79.D9A66C19-ON88256B5F.00638B48@fds.com (view raw or flat)
Thread:
Lists: pgsql-novice
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





Responses

pgsql-novice by date

Next:From: Mo HolkarDate: 2002-02-13 18:09:53
Subject: Re: Peer authentication problem in CGI-Perl
Previous:From: Pam WamplerDate: 2002-02-13 18:05:07
Subject: Re: Cannot log in to DBI

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group