Re: pl/pgsql problem with search_path

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Eugene Chow <gene(at)paragonam(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: pl/pgsql problem with search_path
Date: 2003-09-07 01:37:05
Message-ID: 200309070137.h871b5u01904@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2003-09-07 01:40:27 Re: pl/pgsql problem with search_path
Previous Message Tom Lane 2003-09-07 01:26:24 Re: pl/pgsql problem with search_path