On 24/02/12 13:37, Andrew Gould wrote:
On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton<dev@xxxxxxxxxxxx> wrote:
Temp tables get their own schema, and each session (connection) gets
its own temp schema. So - don't qualify them by schema.
Is that to avoid naming conflicts between simultaneous users?
Yes. I believe it also invisibly adds it to your search_path too, the
same as it does with the pg_catalog schema.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
