On 12/2/05, Toni Casueps <[EMAIL PROTECTED]> wrote: > I am making rules for a table and I want to know what values or variables > can I use apart from the "new..." and old... fields, for example I would > like to read the SQL query that the user wrote that caused this rule to > execute. Can this be done? >
You can't see the original query but have a lot of information much relevant.... C triggers: http://www.postgresql.org/docs/current/static/trigger-interface.html In plpgsql: http://www.postgresql.org/docs/current/static/plpgsql-trigger.html In pltcl: http://www.postgresql.org/docs/current/static/pltcl-trigger.html In plperl: http://www.postgresql.org/docs/current/static/plperl-triggers.html In plpython: http://www.postgresql.org/docs/current/static/plpython-trigger.html -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
