calling elog possibly causing problem in DirectFunctionCall1
От | Rajesh Kumar Mallah |
---|---|
Тема | calling elog possibly causing problem in DirectFunctionCall1 |
Дата | |
Msg-id | a97c77030612010840o3436b7bcje1cdfc507c009f3b@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: calling elog possibly causing problem in DirectFunctionCall1
|
Список | pgsql-sql |
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 />
В списке pgsql-sql по дате отправления: