Doug,
You were right, psql let me insert the trigger.
But when I insert a new row in the table 'visita' (the one that has the
trigger), the result must be an audit new row on 'visita_log' because of
the trigger, and pgAccess reports that the connection was lost. Maybe is
something wrong with the trigger... I don't know what it is... (this is
the first time I program a trigger with PgSQL...)
Thanks in advance.
Juan
Doug McNaught wrote:
>Juan Jose Costello Levien <jcostello@datafull.com> writes:
>
>
>
>>Hello,
>>I am trying to use a trigger function I wrote in C. Basically what I
>>want to do is to audit a table when a row is inserted into another
>>table by copying the row to the new table. It compiles Ok and I
>>created a shared library trigger.so. But when I load it into pgAdmin
>>it tells me 'An error had occured'.
>>
>>
>
>Does it work if you take pgAdmin out of the loop? E.g. in psql:
>
>CREATE FUNCTION trigf ...
>CREATE TRIGGER ...
>
>-Doug
>
>
>
>