| Subject | RE: [firebird-support] violation of FOREIGN KEY constraint |
|---|---|
| Author | Rick Debay |
| Post date | 2012-10-11T15:51:01Z |
Nope. Just adding or updating a child which points to a parent. The FK
field of the child is never changed, nor the PK of the parent. So I
don't know how a FK constraint can be violated.
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of W O
Sent: Thursday, October 04, 2012 6:35 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] violation of FOREIGN KEY constraint
Are you using some managing program, like EMS SQL Manager?
Sometimes it fails with errors as that you had posted. The solution is
to close the program and start it again.
Greetings.
Walter.
On Thu, Oct 4, 2012 at 10:13 AM, Rick Debay <rdebay@...>
wrote:
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
field of the child is never changed, nor the PK of the parent. So I
don't know how a FK constraint can be violated.
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of W O
Sent: Thursday, October 04, 2012 6:35 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] violation of FOREIGN KEY constraint
Are you using some managing program, like EMS SQL Manager?
Sometimes it fails with errors as that you had posted. The solution is
to close the program and start it again.
Greetings.
Walter.
On Thu, Oct 4, 2012 at 10:13 AM, Rick Debay <rdebay@...>
wrote:
> **[Non-text portions of this message have been removed]
>
>
> Anyone?
>
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
> Sent: Wednesday, September 12, 2012 11:30 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] violation of FOREIGN KEY constraint
>
> ISC ERROR CODE:335544345
> ISC ERROR MESSAGE:
> lock conflict on no wait transaction
> violation of FOREIGN KEY constraint "FK_RPLPO_REPLGRP" on table
> "RPL_PO"
>
> The relationship between parent and child was always valid, so I don't
> know why this error was raised. Can this occur if a column in the
> parent row (other than the column referred to in the foreign key) was
> modified?
>
> ------------------------------------
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item on the
> main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links