Troy Rasiah <troyr@xxxxxxxxxxxxx> writes: > If i set the search path to schema1,public the function still returns > rows from the events table in the public schema. What's probably happening is that plpgsql caches the execution plan for the SELECT during the first execution of the function in any given session. The only really reliable way around that is to use EXECUTE instead of an in-line statement. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
