| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Rory Campbell-Lange <rory(at)campbell-lange(dot)net> |
| Cc: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: search_path problem |
| Date: | 2004-09-02 12:14:09 |
| Message-ID: | 41370E91.8080402@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Rory Campbell-Lange wrote:
> Hi
>
> I'm trying to set a search path through a connection made by PHP and
> failing.
>
> It works in pgsql:
>
> clwcms=> set search_path = myname, funcs, public
> I'm now trying to this in php4 and postgres 7.4.3:
>
> 1.
> SELECT fn_util01_searchpath( DB_SEARCHPATH ) as result;
> 2.
> select * from fn_usr30_show_section_users(1, 1);
>
> I get "ERROR: column "db_searchpath" does not exist".
> The logs show:
> 2004-09-02 12:44:47 [18952] ERROR: 42703: column "db_searchpath" does not exist
> LOCATION: transformColumnRef, parse_expr.c:1034
Three questions:
1. What is fn_util01_searchpath()?
2. What is "DB_SEARCHPATH"?
3. Where is your "set search_path..." statement?
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Murphy | 2004-09-02 12:17:47 | Re: zombie primary key lurches out of database to devour the brains of the unwary |
| Previous Message | Rory Campbell-Lange | 2004-09-02 12:10:46 | Re: search_path problem |