Passing a variable from the user interface to PostgreSQL

From: Chris Campbell <ccampbell(at)cascadeds(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Passing a variable from the user interface to PostgreSQL
Date: 2011-01-21 18:39:56
Message-ID: 453A24085F801842AEA8D0B6B269065D45E2521023@HDMC.cds.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 interface to the database such that it would be visible inside a database trigger and any corresponding function call?

When a record gets deleted, a table trigger fires that writes to a log table. What I want to do is pass a variable from the user interface to the trigger function so I can write the variable's value to the log record that I create in a function called from the trigger event. I'm not sure how this could even be accomplished unless somehow it was possible to pass a variable through the data connection itself. But even then, how would the trigger function be able to see it and pass it along? Is there some other mechanism or approach I should be taking?

I'm thinking it's not possible but thought I would ask anyway.

Thanks for any comments,

Chris Campbell
ccampbell(at)CascadeDS(dot)com<mailto:ccampbell(at)CascadeDS(dot)com>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2011-01-21 19:03:54 Re: Passing a variable from the user interface to PostgreSQL
Previous Message Mike Thomsen 2011-01-21 17:38:58 Re: "Database does not exist"... but it does exist