Re: problem trying to create a temp table
| От | Andrew Gould |
|---|---|
| Тема | Re: problem trying to create a temp table |
| Дата | |
| Msg-id | CAFKhKgrP0=1wUTNQkdpTzG1i_2GaK_WzTvZJdaYm+TPz9-6QfA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: problem trying to create a temp table (Richard Huxton <dev@archonet.com>) |
| Ответы |
Re: problem trying to create a temp table
|
| Список | pgsql-general |
On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton <dev@archonet.com> wrote: > On 24/02/12 13:26, mgould@isstrucksoftware.net wrote: > >> ALL, >> Using 9.1.2 on Windows 7 X64 for development. >> I'm trying to create a temporary table used to store session variables >> CREATE TEMP TABLE iss.sessionsettings > > >> When I try and run this I get the following error message. >> ERROR: cannot create temporary relation in non-temporary schema > > Temp tables get their own schema, and each session (connection) gets > its own temp schema. So - don't qualify them by schema. > > -- > Richard Huxton > Archonet Ltd > Is that to avoid naming conflicts between simultaneous users? Andrew
В списке pgsql-general по дате отправления: