Skip site navigation (1) Skip section navigation (2)

Fail of a return query from plpgsql function for a specific table

From: "c k" <shreeseva(dot)learning(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Fail of a return query from plpgsql function for a specific table
Date: 2009-01-07 21:17:15
Message-ID: d8e7a1e30901071317x1eb1c731se957c95695512152@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Hi all,I have a table accgroups and many others. I have written a test
function as follows.
CREATE OR REPLACE FUNCTION uf_testfunction()
  RETURNS SETOF associates AS
$BODY$
begin
return query select * from associates;
return;
end;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
This works fine for above table but not works at all for accgroups table. As
I searched for this over web, it is identified as a bug for tables whose
columns are changed(deleted and added). Is it true?
How to solve this issue?
Thanks
CPK

Responses

pgsql-admin by date

Next:From: Bruce MomjianDate: 2009-01-08 03:19:38
Subject: Re: ssl-info, enforcing list of common-names
Previous:From: IƱigo Martinez LasalaDate: 2009-01-05 19:18:01
Subject: Re: error vacuum full

pgsql-general by date

Next:From: John RandallDate: 2009-01-08 00:10:34
Subject: pg_bulkload
Previous:From: Tom LaneDate: 2009-01-07 20:52:06
Subject: Re: stable function called for every row?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group