Re: BUG: PLPGSQL function causes PgSQL process to die when

On Thu, 23 Oct 2003, Christopher Travers wrote:

> Hi all;
>
> I have two tables which have different security considerations wrapped into
> a view.  Inserting into the view is done using a simple rule which inserts
> into both tables (tables have a 1:1 relationship and reflect the
> user-defined and admin-defined portions of a user profile).  From psql,
> inserts into the table work as expected.  However from a PLPGSQL function,
> any attempt to insert into the table causes the following error:
>
> FATAL:  SPI: improper call to spi_dest_setup
>
> The query is a simple insert and the rule merely splits it into two inserts.
>
> The workaround is simply to insert into both tables in the view
> independently within the plpgsql function.  But this seems like odd behavior
> that should not be occurring.

Can you give version information and a standalone example?