Use of search path in plpgsql functions, PG 8.3.12

From: Troy Rasiah <troyr(at)vicnet(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Use of search path in plpgsql functions, PG 8.3.12
Date: 2010-11-25 05:34:43
Message-ID: 4CEDF573.7000609@vicnet.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

At present i have the following

Schema 1
-------------

Table: events

Public Schema
-------------

Table: events

Function

CREATE OR REPLACE FUNCTION "public"."recurring_events_for" (
"range_start" timestamp,
"range_end" timestamp,
"time_zone" varchar,
"events_limit" integer
)
RETURNS SETOF "events" AS

....

If i set the search path to schema1,public the function still returns rows from the events table in the public schema. I would like to use the same function for both schema's. I'm sure i'm missing something obvious, can anyone help me understand this better ?

Thanks

--
Troy Rasiah

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Tolley 2010-11-25 05:42:55 Re: [GENERAL] plpyhton
Previous Message Chris 2010-11-25 02:34:50 Re: is any of the SQL parser exposed ?