Doh ! Thanks for the insight.
Greg
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wed 9/29/2004 8:40 AM
To: Gregory S. Williamson
Cc: [EMAIL PROTECTED]
Subject:Re: [GENERAL] Setting search paths inside a function (plpgsql)
"Gregory S. Willi
"Gregory S. Williamson" <[EMAIL PROTECTED]> writes:
> RAISE NOTICE ''doing name search for fips %'',p_fips;
> env_str := ''SET search_path TO f'' || p_fips || '',public'';
> EXECUTE env_str;
> RAISE NOTICE ''did exec of <%>'',env_str;
> FOR retrec IN
>
On Wed, 29 Sep 2004, Gregory S. Williamson wrote:
> I've got a problem which seemed to be neatly solved by the use of
> schemas, and in fact it mostly works, but I have tried to go one step
> too far, perhaps.
>
> Rather than have the application do
>
> SET search_path TO f12057;
> SELECT * FROM
Dear peoples,
I've got a problem which seemed to be neatly solved by the use of schemas, and in fact
it mostly works, but I have tried to go one step too far, perhaps.
Rather than have the application do
SET search_path TO f12057;
SELECT * FROM parcel-owners WHERE ... ;
SET search_path TO publi
