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
return query select * from associates;
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?
pgsql-admin by date
|Next:||From: Bruce Momjian||Date: 2009-01-08 03:19:38|
|Subject: Re: ssl-info, enforcing list of common-names|
|Previous:||From: Iñigo Martinez Lasala||Date: 2009-01-05 19:18:01|
|Subject: Re: error vacuum full|
pgsql-general by date
|Next:||From: John Randall||Date: 2009-01-08 00:10:34|
|Previous:||From: Tom Lane||Date: 2009-01-07 20:52:06|
|Subject: Re: stable function called for every row? |