Re: [BUGS] BUG #2294: SPI_connect() fails in trigger when a Foreignkey constraint exists on same table as trigger.

2006-03-04 Thread Jim Fitzgerald
IL PROTECTED]> To: "Jim Fitzgerald" <[EMAIL PROTECTED]> Cc: Sent: Thursday, March 02, 2006 2:55 PM Subject: Re: [BUGS] BUG #2294: SPI_connect() fails in trigger when a Foreignkey constraint exists on same table as trigger. "Jim Fitzgerald" <[EMAIL PROTECTE

Re: [BUGS] BUG #2294: SPI_connect() fails in trigger when a Foreignkey constraint exists on same table as trigger.

2006-03-04 Thread Jim Fitzgerald
From: "Tom Lane" <[EMAIL PROTECTED]> To: "Jim Fitzgerald" <[EMAIL PROTECTED]> Cc: Sent: Thursday, March 02, 2006 7:44 AM Subject: Re: [BUGS] BUG #2294: SPI_connect() fails in trigger when a Foreignkey constraint exists on same table as trigger. "Jim

Re: [BUGS] BUG #2294: SPI_connect() fails in trigger when a Foreignkey constraint exists on same table as trigger.

2006-03-02 Thread Jim Fitzgerald
Hi Alvaro - Yes, your right that SPI_finish() should be called. It was being called in my original program where this issue was discovered.I did not include a call to SPI_finish() in my bug exercising example just to eliminate extraneous stuff. I have just modified the submitted test_trig