Re: [GENERAL] plpgsql: cannot connect to SPI manager

[Alan Treece]

Title: Message

I was missing SPI_finish() here.

 

Sorry.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Treece
Sent: Friday, April 16, 2004 3:29 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] plpgsql: cannot connect to SPI manager

I'm getting this when i do an insert.  I have a 'c' trigger doing an SPI_connect.  If i remove this it goes away, but i don't think it's my trigger generating it.  The table has a lot of foreign key constraints.  Could be postgres is generating code to do this.  Is there a way around this or a way track this down.

 

Alan