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

From Peter Eisentraut
Subject Re: A couple of TODO notes
Date
Msg-id Pine.LNX.4.44.0310200728050.16235-100000@peter.localdomain
Whole thread Raw
In response to Re: A couple of TODO notes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane 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.

SQL99 has SET PATH (part 5, clause 14.4).

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Unicode upper() bug still present
Next
From: Christopher Kings-Lynne
Date:
Subject: pg_dump problems against 7.0