Re: Passing a variable from the user interface to PostgreSQL

On 2011-01-21, Chris Campbell <ccampbell(at)cascadeds(dot)com> wrote:
> --_000_453A24085F801842AEA8D0B6B269065D45E2521023HDMCcdslocal_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Using:
> Windows 7 64bit
> VB.net 2010
> The latest devart.data.PostgreSQL (.net data connection)
> PostgreSQL 9.0.2
>
> Hi all,
>
> Question: Is there a way to pass a variable from an application's user inte=
> rface to the database such that it would be visible inside a database trigg=
> er and any corresponding function call?

no, but you could store the value and their backend's process id in a table beforehand.
the trigger could then retreive it from there.

or store it in a temporary table and the trigger can use dynamic sql
to retreive it.

See also, the "System Information Functions" section of the manual

--
⚂⚃ 100% natural