Peter Eisentraut <pete...@gmx.net> wrote: > There are actually two orthogonal properties at work here: How the > table is visible with respect to modules (LOCAL/GLOBAL) and whether > the table disappears at the end of the session (currently yes, > proposed new behavior optionally no). Pavel's request and the standard always have the temporary table disappearing at the end of the session; the second question for these is whether the *definition* of the table disappears at the end of the session, or remains in the schema to generate an instance for another session on demand. There was a digression about a possible feature other than what Pavel requested, which is not defined in the standard, which I referred to as "permanent work tables", which would be distinguished from normal tables only by the fact that no effort would be made to log the data for recovery, and perhaps the table should be truncated on PostgreSQL startup. If we want to pursue that discussion, it should probably be on a different thread. > On the matter of LOCAL/GLOBAL, I think the correct thing to do is to > reject LOCAL and accept GLOBAL as equivalent to the default. +1 > And then invent a separate setting, say EPHEMERAL/PERSISTENT that > controls the behavior that Pavel requested. While I probably wouldn't have chosen the syntax that the standard did, the SQL spec does specify a syntax to do what Pavel requested. I don't think it's so bad that we should ignore it and invent our own alternative. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers