| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Scott Goodwin <scott(at)scottg(dot)net> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Patch to psql to allow SEARCH_PATH to be set from env |
| Date: | 2004-02-10 13:37:09 |
| Message-ID: | 4028DE85.1040209@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Scott Goodwin wrote:
> Using schemas is fun. Setting the search_path every time I use psql
> isn't. This patch modifies startup.c in psql to allow the SEARCH_PATH to
> be set to whatever the PG_SCHEMA_SEARCH_PATH environment variable is set
> to. If the var is not defined or is empty, no action is taken and the
> search path is what it would be without this patch. If
> PG_SCHEMA_SEARCH_PATH is set to garbage, psql simply reports the
> database error about non-existent schemas and continues running with the
> search_path it would have without this patch. The patch is against PG
> 7.4.1.
Do you know that you can go ALTER USER yourselft SET SEARCH_PATH TO
"'public','core','objects'"; So that will always be your default path?
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Goodwin | 2004-02-10 13:54:41 | Re: Patch to psql to allow SEARCH_PATH to be set from env |
| Previous Message | Bruce Momjian | 2004-02-10 13:22:02 | Re: Dev version doesn't acknowledge cross type indexes |