pls help - Mailing list pgsql-hackers

From Jimmy Wu
Subject pls help
Date
Msg-id JOEEKKANHNKEDGHNHFKKAEAECAAA.jwu@eservgroup.com
Whole thread Raw
Responses Re: pls help  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
Hello,

My name is Jimmy Wu. I work for a startup company called eServ. Our OS is
FreeBSD, web server is Apache, and I use PHP to write some web application
accessing PostgreSQL database(Version 7.0.2).
I have some questions:
1. I explicitly locked a table and the program somehow crashed. Then that
post process just sitting there never return the lock. How can I prevent
this from happening?
2. After the crash, I don't why...there are two duplicate rows in that
table. This should never happen since there are primary keys.

Please tell me what could cause this? Thank you very much for your time.

Jimmy



pgsql-hackers by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: Security choices...
Next
From: Brook Milligan
Date:
Subject: geographic coordinate types?