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 ?


Tue, 16 Apr 2002 17:48:07 +0300
Dragos Manzateanu <dragon@mail.dntis.ro>
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 ?

Tue, 16 Apr 2002 22:32:15 +0300
Dragos Manzateanu <dragon@mail.dntis.ro>
Re: date_in function
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

Wed, 17 Apr 2002 08:48:56 +0300
Dragos Manzateanu <dragon@mail.dntis.ro>
Re: 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 ?

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.


Wed, 17 Apr 2002 11:42:19 +0300
Dragos Manzateanu <dragon@mail.dntis.ro>
date_in function
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

Wed, 17 Apr 2002 11:19:12 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: date_in function 