Re: plpgsql: cannot connect to SPI manager

["Alan Treece" <atreece@cisco.com>]

Title: Message

I was missing SPI_finish() here.

 

Sorry.

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alan Treece
Sent: Friday, April 16, 2004 3:29 PM
To: pgsql-general@postgresql.org
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