| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Global temporary table - schema |
| Date: | 2010-06-24 05:52:37 |
| Message-ID: | AANLkTilsYB7xb_rOE0H4Vgd6_vLqoQkj-eVuHQQLqOpb@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2010/6/24 Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com>:
> Hi List,
>
>
>
> When I have created Global temporary table its created under/in PG_temp_1
> schema by default,
>
> When tried to specify the schema name explicitly its throwing below error
>
>
>
> ERROR: temporary tables cannot specify a schema name
>
>
>
> I wanted to create a Global temporary table in public or the schema I wish.
>
>
>
> Any ideas?
PostgreSQL doesn't support global temporary tables yet.
Regards
Pavel Stehule
>
>
>
> Thanks in advance.
>
>
>
>
>
> -- Ravi Katkar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2010-06-24 07:01:01 | Re: The case of PostgreSQL on NFS Server |
| Previous Message | Ravi Katkar | 2010-06-24 05:26:25 | Global temporary table - schema |