> -----Original Message-----
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
>
> "Hiroshi Inoue" <[EMAIL PROTECTED]> writes:
> > Sorry for my poor explanation. What I meant is that *Rollback*
> > is to
>> cancel the changes made to SQL-data or schemas
This line is a quote from SQL99 not my creation.
> > not to put back the variables which are local to the session.
>
> Uh, why? Seems to me you are asserting as a given exactly the
> point that is under debate. Let me give a counterexample:
>
> BEGIN;
> CREATE TEMP TABLE foo;
> something-erroneous;
> END;
>
> The creation of the temp table will be rolled back on error, no?
??? TEMP TABLE is a SQL-data not a variable.
I don't think rolling back SETs makes things plain.
regards,
Hiroshi Inoue
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
