Re: A couple of TODO notes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A couple of TODO notes
Date
Msg-id 12333.1066615949@sss.pgh.pa.us
Whole thread Raw
In response to Re: A couple of TODO notes  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: A couple of TODO notes  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> o Add SET SCHEMA
>> 
>> What is this supposed to do (and how's it different from SET SEARCH_PATH)?

> I believe someone thought it was the SQL standard way of doing it. 
> Probably needs to be checked though.

I can find no mention of it in SQL99.  Given that the spec regards
schemas and users as nearly the same thing, I'd guess that SET SESSION
AUTHORIZATION is probably what they'd expect to do this.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: A couple of TODO notes
Next
From: Christopher Browne
Date:
Subject: Re: Dreaming About Redesigning SQL