Thread: howto set a variable in transaction context
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 |
Attachment
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 -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
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 >