Re: pl/pgsql problem with search_path - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: pl/pgsql problem with search_path
Date
Msg-id 200309070137.h871b5u01904@candle.pha.pa.us
Whole thread Raw
In response to pl/pgsql problem with search_path  (Eugene Chow <gene@paragonam.com>)
List pgsql-bugs
Eugene Chow wrote:
> Thanks. If I had only read the manual before posting. I solved it by
> using 'execute' instead of 'select into' since the search_path is not
> static in my system.

Yep, that's the workaround mentioned in the FAQ.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pl/pgsql problem with search_path
Next
From: Bruce Momjian
Date:
Subject: Re: pl/pgsql problem with search_path