Thread: 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

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@archonet.com>
To: "Manuel García" <mgarciah@ife.org.mx>
Cc: <pgsql-general@postgresql.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

Manuel García wrote:
> 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.

Sounds like you want to use one of the existing replication solutions -
perhaps try a search on slony.

PS - merely tracking the top-level SQL isn't enough to guarantee you can
reproduce the changes to the database.
--
   Richard Huxton
   Archonet Ltd