Re: BUG #6517: Volatile function erroneously optimized, does not consider change in schema path

On Mon, Mar 5, 2012 at 6:52 AM,  <rene.vanpaassen@gmail.com> wrote:
>
> set search_path to public;
>
> CREATE FUNCTION countusers()
> RETURNS INT
> AS $PROC$
> BEGIN
> =A0 =A0RETURN count(*) FROM users;
> END
> $PROC$ LANGUAGE 'plpgsql' VOLATILE;
>

i think you can workaround your problem using EXECUTE:

CREATE FUNCTION countusers()
RETURNS INT
AS $PROC$
DECLARE
   counter INT;
BEGIN
   EXECUTE 'SELECT count(*) FROM users' INTO counter;
=A0 =A0RETURN counter;
END
$PROC$ LANGUAGE 'plpgsql' VOLATILE;

--=20
Jaime Casanova=A0 =A0 =A0 =A0=A0 www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n