Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > howto set a var...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 15241 of 17598
Post > Topic >>

howto set a variable in transaction context

by t.markus@[EMAIL PROTECTED] (Thomas Markus) Apr 10, 2008 at 01:32 PM

This is a multi-part message in MIME format.
--------------000709080607070600040202
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

hi list,

how can i set a variable, which content is only visible in current 
transaction?
i know the way to create a temp table with

create temp table ... on commit drop

but i dont like that way. something like
|
set_config(setting_name, new_value, is_local)

is it possible?

regards
thomas
|

--------------000709080607070600040202
Content-Type: text/x-vcard; charset=utf-8;
 name="t_markus.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="t_markus.vcf"

begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:t.markus@[EMAIL PROTECTED]
 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard


--------------000709080607070600040202
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--------------000709080607070600040202--
 




 3 Posts in Topic:
howto set a variable in transaction context
t.markus@[EMAIL PROTECTED  2008-04-10 13:32:04 
Re: howto set a variable in transaction context
andreas.kretschmer@[EMAIL  2008-04-10 13:57:31 
Re: howto set a variable in transaction context
t.markus@[EMAIL PROTECTED  2008-04-10 14:29:53 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 8:32:36 CST 2008.