Hi ,<br />In certain C trigger function following code snippet causes ERROR:<br
/>---------------------------------------------------<br/>elog (NOTICE , "before calling DirectFunctionCall1");<br />
data->time_stamp= <br /> DirectFunctionCall1(timestamptz_in, CStringGetDatum("now"));<br />elog (NOTICE , "after
callingDirectFunctionCall1");<br />----------------------------------------------------<br /><br />begin work;INSERT
INTO audittest.test_table (name,foo) values ('test','test'); rollback;<br />BEGIN<br />NOTICE: before calling
DirectFunctionCall1<br/>ERROR: timestamp(-1073748880) precision must be between 0 and 6<br />ROLLBACK<br /><br />If
theelog before DirectFunctionCall1 is removed the code works fine. <br /><br />begin work;INSERT INTO
audittest.test_table(name,foo) values ('test','test'); rollback;<br />BEGIN<br />NOTICE: after calling
DirectFunctionCall1<br/>INSERT 0 1<br />ROLLBACK<br /><br />Can anyone please explain how removing a elog makes a
difference?<br /><br />Regds<br />Mallah.<br /><br /><br /><br /><br /><br /><br />