Postgres Pro
Downloads
Home   >   mailing lists

howto set a variable in transaction context - Mailing list pgsql-general

From Thomas Markus
Subject howto set a variable in transaction context
Date
Msg-id 47FDFAB4.5090605@proventis.net
Whole thread Raw
Responses Re: howto set a variable in transaction context  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Re: Dump/Transfer Sequence Problems
Next
From: "A. Kretschmer"
Date:
Subject: Re: howto set a variable in transaction context