I just found an interesting issue in recent PostgreSQL releases:
CREATE VIEW view_nonsense AS SELECT 1 AS a, 2 AS b;
CREATE RULE myrule AS ON INSERT TO view_nonsense
DO INSTEAD NOTHING;
CREATE OR REPLACE FUNCTION debug() RETURNS boolean AS '
DECLARE
BEGIN
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= [EMAIL PROTECTED] writes:
ERROR: SPI_execute_plan failed executing query INSERT INTO
view_nonsense VALUES (10, 20): Unrecognized SPI code 0
CONTEXT: PL/pgSQL function debug line 4 at SQL statement
SPI_result_code_string(int code) and PL/pgSQL don't