Error explaination? - Mailing list pgsql-sql

From Josh Berkus
Subject Error explaination?
Date
Msg-id web-44133@davinci.ethosmedia.com
Whole thread Raw
Responses Re: Error explaination?
List pgsql-sql
Folks,
I have a fuction that creates a record in a table called user_locks,
does a bunch of stuff, then deletes the record.  However, when I try to
run it, I get the following error:

ERROR:  triggered data change violation on relation "user_locks"
It appears that the function handler won't let me create, then delete
the same record.  What goes on?

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: Kyle
Date:
Subject: Re: RI permission problem
Next
From: Stephan Szabo
Date:
Subject: Re: RI permission problem