Re: Error explaination?

Josh Berkus wrote:
> 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?

You have a foreign key constraint or other triggers on that
"user_locks" table.

This is a known misbehaviour (not to call it a bug) that we
keep since having deferrable referential integrity.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com