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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2009-01-08 03:19:38 Re: ssl-info, enforcing list of common-names
Previous Message Iñigo Martinez Lasala 2009-01-05 19:18:01 Re: error vacuum full

Browse pgsql-general by date

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