Re: howto set a variable in transaction context

[Thomas Markus <t.markus@xxxxxxxxxxxxx>]

thanks, it works

A. Kretschmer schrieb:
> am  Thu, dem 10.04.2008, um 13:32:04 +0200 mailte Thomas Markus folgendes:
>   
> > 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?
> >     
>
> Yes, you can use this:
> http://www.postgresql.org/docs/current/interactive/runtime-config-custom.html
>
>
> How to use?
> http://groups.google.de/group/pgsql.general/browse_thread/thread/f914569b73d17258/5c0cb606d0ce698d?lnk=st&q=#5c0cb606d0ce698d
>
>
> HTH, Andreas
>   

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