Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] proposal: schema variables - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: [HACKERS] proposal: schema variables
Date
Msg-id 58C95E69-F94E-46E0-98B5-8F52454B4403@gmail.com
Whole thread Raw
In response to [HACKERS] proposal: schema variables  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [HACKERS] proposal: schema variables  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
> Comments, notes?

How would variables behave on transaction rollback?

CREATE TEMP VARIABLE myvar;
SET myvar := 1;
BEGIN;
SET myvar := 2;
COMMIT;
BEGIN;
SET myvar := 3;
ROLLBACK;
SELECT myvar;

How would variables behave when modified in a procedure
that aborts rather than returning cleanly?


mark


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Nico Williams
Date:
Subject: Re: [HACKERS] [PATCH] Add two-arg for of current_setting(NAME,FALLBACK)
Next
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] MERGE SQL Statement for PG11