Subject: [Pljava-dev] Obtaining Query from Trigger
Date: Wed, 08 Jun 2005 08:23:22 +0200
Message-ID: <thhal-0XieCAwd9zjY4JTa2tMVk0FL15OVGYa@mailblocks.com> (raw)
In-Reply-To: <ce04e69f050607150868a9b80e@mail.gmail.com>
References: <ce04e69f050607150868a9b80e@mail.gmail.com>
<42A68EDA.1090206@mailblocks.com>
<thhal-0XCeCAwV9zjYkHoY0KllhRjVR7BiY28@mailblocks.com>
Joao Afonso wrote:
> Hi!
>
> I started using pljava two days ago, so I apologize if this was
>already posted before.
>
> I need to get the sql query that fired a trigger on a DB so that it
>can be re-issued to another DB.
>
> For example, if 'select * from users' fired a before select trigger,
>the string with the query should be somehow passed to the java
>function that is associated to that trigger.
>
>
I hate to dissapoint you but to my knowledge a trigger is never fired
for SELECT. Only INSERT, UPDATE, and DELETE will fire triggers.
Regards,
Thomas Hallgren
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Obtaining Query from Trigger
In-Reply-To: <thhal-0XieCAwd9zjY4JTa2tMVk0FL15OVGYa@mailblocks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox