| From: | Fernando Nasser <fnasser(at)redhat(dot)com> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: What's the CURRENT schema ? |
| Date: | 2002-04-10 13:27:05 |
| Message-ID: | 3CB43DA9.C752899E@redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hiroshi Inoue wrote:
>
> Fernando Nasser wrote:
> >
> > As most things in the SQL standard, you have to collect information
> > from several places and add it together.
> >
> > Look at 4.20, 11.1 and specially at the rules for
> > <schema qualified name>.
> >
> > Then think a little bit about scenarios, trying to apply the rules.
> >
> > It is a pain, but there is no other way.
>
> I couldn't find the description CURRENT_SCHEMA == CURRENT_USER.
> If I recognize SQL99 correctly, the CURRENT schema is the schema
> defined in a <SQL-client module> not restricted to the CURRENT
> user.
>
Yes, but we don't have a "module" language. You have to look for
"session".
--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2002-04-10 14:08:23 | A "New Release" list of places to contact about new releases of PostgreSQL |
| Previous Message | Hiroshi Inoue | 2002-04-10 10:39:06 | Re: RFC: Restructuring pg_aggregate |