Re: [GENERAL] Can I catch sentences in SQL using triggers?

2005-06-01 Thread Manuel García
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 sentenc

[GENERAL] Can postgresql catch all the sentences applies to one table?

2005-05-26 Thread Manuel García
Hello, Somebody knows If is possible to catch all the sentences applies to one table using triggers and function in C maybe, that’s  because, I need to create one log table with all the sentences. Once that I have that  I going to use all the sentences to replicate that table in other datab

[GENERAL] Advice

2005-05-25 Thread Manuel García
Hi, I am Manuel and I want to catch the full sentence executed on one table, at the moment I have one function in C, that function is  invoking by  trigger, but I need to catch the full sentence, by example insert into tempo values (1,2,’x’) or update tempo set a=2, b=’x’ where a=3 or delet