7.4 beta1 plpgsql regression

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: 7.4 beta1 plpgsql regression
Date: 2003-08-13 21:55:12
Message-ID: 1060811712.11688.85.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The below function works in 7.3 (returns nothing, but no errors).

rbttest=# begin;
BEGIN
rbttest=# create or replace function service.test(integer)
rbttest-# returns setof service.service
rbttest-# as '
rbttest'# declare
rbttest'# v_service service.service%rowtype;
rbttest'#
rbttest'# begin
rbttest'#
rbttest'#
rbttest'# return;
rbttest'# end;
rbttest'# ' language plpgsql;
CREATE FUNCTION
rbttest=# select * from service.test(1);
ERROR: cache lookup failed for type 0
CONTEXT: compile of PL/pgSQL function "test" near line 2

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-08-13 22:05:46 Re: [BUGS] 7.4 beta 1: SET log_statement=false
Previous Message Tom Lane 2003-08-13 20:26:03 Re: Speeding up operations