Thread: date_in function
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 ?
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 ?
On Tuesday 16 April 2002 10:32 pm, you wrote: > 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 ? > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
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