No, I didn't know that, but I figured there might be another, better way to do this that I hadn't found. Thanks for the info; I'm going to dig into ALTER USER to see what else I may be missing. Consider this patch "rescinded", though it was a good exercise in working with PG source code. If anyone cares to, I'd still like feedback on anything I could have done better in this patch (i.e. coding style, better place to put this kind of code etc.).
thanks,
/s.
On Feb 10, 2004, at 8:37 AM, Christopher Kings-Lynne wrote:
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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
