Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group