Re: [HACKERS] Question about "Unrecognized SPI code" ...

2005-02-22 Thread Tom Lane
=?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/pgS

[HACKERS] Question about "Unrecognized SPI code" ...

2005-02-22 Thread Hans-Jürgen Schönig
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 INS