Noah Misch <n...@leadboat.com> writes:
> On Wed, Jun 13, 2012 at 05:50:36PM -0400, Tom Lane wrote:
> The SQL standard also distinguishes between global and local temporary
> tables, where a local temporary table is only visible within a specific SQL
> module, though its definition is still shared across sessions. Since
> PostgreSQL does not support SQL modules, this distinction is not relevant in
> PostgreSQL.
> That new documentation paragraph describes the standard behavior for DECLARE
> LOCAL TEMPORARY TABLE. CREATE LOCAL TEMPORARY TABLE produces a table
> available to all modules but having one instance of its contents per module,
> per session. With GLOBAL, by contrast, all modules see the same table
> contents during a given session.
[ reads spec more closely... ] Yeah, you're right. Will fix, thanks.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
