Bruce Momjian <pgman@candle.pha.pa.us> writes: > Agreed. I have gotten confused on how to set $user in the past. I have > developed the following patch that sets the default with the double > quotes around it, and it works fine. The patch also contains updated > documentation.
This is really entirely irrelevant to Greg's complaint. To respond to that, you'd have to modify the behavior of SHOW. Actually, it seems that this exposes a bug in the search_path code: if I wrote what you wrote, I'd really expect that it refers to a schema named exactly $user --- the quoting ought to suppress the substitution, one would think. Not sure how hard or easy that might be to implement though ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly