Re: Passing a variable from the user interface to PostgreSQL

Jasen Betts wrote:
> On 2011-01-21, Chris Campbell <ccampbell@cascadeds.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?
>>
>
>
> you can embed the extra value in an sql comment and retrieve
> it with current_query()
>
> "-- this is extra value
> delete from sometable where thiscolumn='thatvalue';"
>
> works in 8.4
>
>
Once you have to resort to the parsing of the initial SQL within the
database trigger, you know that the application design is fubar.
It's time to think about the new application design.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com