Re: Can I catch sentences in SQL using triggers?

Ok. Richard, that is that I need to do, I need to create a log table with
all the information that is changed on every row that was update, delete or
insert, additionally I must be record the user that do that. At this point I
don't have troubles I can do that, but I need to get the full sentence
because I want to use that to update other database but only apply the last
changes, in the case of insert of course doesn't exist problem but in the
case of dalete and update yes. That is because I need to catch the sentences
of insert update an delete but full.

Thanks in advanced.

Manuel
----- Original Message -----
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>
Sent: Wednesday, June 01, 2005 9:38 AM
Subject: Re: [GENERAL] Can I catch sentences in SQL using triggers?

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match