On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton <dev@xxxxxxxxxxxx> wrote: > On 24/02/12 13:26, mgould@xxxxxxxxxxxxxxxxxxxx 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
