Re: 7.4 beta1 plpgsql regression - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: 7.4 beta1 plpgsql regression
Date
Msg-id 1060870992.14006.5.camel@jester
Whole thread Raw
In response to Re: 7.4 beta1 plpgsql regression  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I think I have a catalog corruption (self inflicted I'm sure).  A dump /
reload of the database corrects the issue here as well.

On Thu, 2003-08-14 at 08:33, Tom Lane wrote:
> Rod Taylor <rbt@rbt.ca> writes:
> > The below function works in 7.3 (returns nothing, but no errors).
>
> > rbttest=3D# select * from service.test(1);
> > ERROR:  cache lookup failed for type 0
> > CONTEXT:  compile of PL/pgSQL function "test" near line 2
>
> Hmm, works fine here ...
>
> regression=# create schema service;
> CREATE SCHEMA
> regression=# create table service.service (f1 int, f2 text);
> CREATE TABLE
> regression=# create or replace function service.test(integer)
> regression-# returns setof service.service
> regression-# as '
> regression'# declare
> regression'#  v_service service.service%rowtype;
> regression'# begin
> regression'# return;
> regression'#  end;
> regression'# ' language plpgsql;
> CREATE FUNCTION
> regression=# select * from service.test(1);
>  f1 | f2
> ----+----
> (0 rows)
>
> regression=#
>
>             regards, tom lane
>

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4 beta1 plpgsql regression
Next
From: Carlos Guzman Alvarez
Date:
Subject: SSL Connection / Windows + Cygwin + PostgreSQL 7.4 Beta 1 question