From: | "Christopher Travers" <einhverfr(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG: PLPGSQL function causes PgSQL process to die when inserting into a view |
Date: | 2003-10-23 14:15:53 |
Message-ID: | LAW9-F116jWTu86mTcr00003699@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
Best Wishes,
Chris Travers
_________________________________________________________________
Never get a busy signal because you are always connected with high-speed
Internet access. Click here to comparison-shop providers.
https://broadband.msn.com
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-10-23 14:32:40 | Re: BUG: PLPGSQL function causes PgSQL process to die when |
Previous Message | Keith Marr | 2003-10-23 07:51:06 | currval and nextval in 7.3.4 |