Re: [COMMITTERS] pgsql: Add ERROR msg for GLOBAL/LOCAL TEMP is not yet implemented - Mailing list pgsql-hackers

Noah Misch <noah@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