date_in function

On Tuesday 16 April 2002 05:48 pm, you wrote:

I want to change the date from a field in a tuple in a trigger_function

create table example (
my_date datetime
...
);

int na;
char select[20];

na = SPI_fnumber(trigdata->tg_relation->rd_att, "my_date");
memset(select, 0, sizeof(select));
sprintf(select, "1/1/2002");
newval = DirectFunctionCall1(date_in, CStringGetDatum(select));
rettuple = SPI_modifytuple(trigdata->tg_relation, rettuple, 1, &na,
&newval, NULL);
if(rettuple == NULL) elog(ERROR, "my_function: %d returned by
SPI_modifytuple", SPI_result);

when i test that my server goes down. What I missed ?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Not my function is about, but date_in.
Have anybody worked with these ?

I want to change the date from a field in a tuple in a trigger_function

create table example (
my_date datetime
...
);

int na;
char select[20];

na = SPI_fnumber(trigdata->tg_relation->rd_att, "my_date");
memset(select, 0, sizeof(select));
sprintf(select, "1/1/2002");
newval = DirectFunctionCall1(date_in, CStringGetDatum(select));
rettuple = SPI_modifytuple(trigdata->tg_relation, rettuple, 1, &na, &newval,
NULL);
if(rettuple == NULL) elog(ERROR, "my_function: %d returned by
SPI_modifytuple", SPI_result);

when i test that my server goes down. What I missed ?

Not my function is about, but date_in.
Have anybody worked with this function ?
Can somebody give me a sample to use date_in. Thanks.

Dragos Manzateanu <dragon@mail.dntis.ro> writes:

na = SPI_fnumber(trigdata->tg_relation->rd_att, "my_date");
memset(select, 0, sizeof(select));
sprintf(select, "1/1/2002");
newval = DirectFunctionCall1(date_in, CStringGetDatum(select));
rettuple = SPI_modifytuple(trigdata->tg_relation, rettuple, 1, &na, &newval,
NULL);
if(rettuple == NULL) elog(ERROR, "my_function: %d returned by
SPI_modifytuple", SPI_result);

when i test that my server goes down. What I missed ?

I doubt that the problem is with date_in. Have you tried backtracing
in the core dump?

regards, tom lane