Martijn Tonies wrote:

>Paul,
>
>
>
>>Syntax:
>>
>> CREATE TEMPORARY TABLE <table name> <table contents source>
>> [ON COMMIT {PRESERVE | DELETE} ROWS]
>>
>>
>
>CREATE GLOBAL TEMPORARY TABLE
>
>for tables that are accessible over connection boundaries.
>
>
>

What, then, are the semantics? If they're visible across connection
boundaries, when are they created and when are they destroyed?