Re: Can I catch sentences in SQL using triggers?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Manuel García <mgarciah(at)ife(dot)org(dot)mx>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can I catch sentences in SQL using triggers?
Date: 2005-06-01 15:38:10
Message-ID: 429DD662.2020801@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Manuel García wrote:
> Hello Everybody, somebody knows if its possible to catch one
> sentences in full SQL using the triggers, or maybe somebody have any
> idea about to how do it?
>
> I am using postgreSQL 7.3 on fedora core 1

If I understand, you want to access the query, e.g. "SELECT * FROM
my_table" from within a trigger function. The answer is no. If you can
describe what you're trying to do, someone may be able to help though.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-01 15:39:22 Re: prevent user change password?
Previous Message Matt Miller 2005-06-01 15:38:01 Autonomous Transactions