SPI_execute_plan(): how to make a Datum to insert type inet ?

Поиск
Список
Период
Сортировка
От Alex Vinogradovs
Тема SPI_execute_plan(): how to make a Datum to insert type inet ?
Дата
Msg-id 1205951883.9864.17.camel@localhost
обсуждение исходный текст
Ответы Re: SPI_execute_plan(): how to make a Datum to insert type inet ?
Список pgsql-general
Guys,


I've got SPI code that performs inserts into some tables. Code works
fine when destination columns are type text, but fails when there
is something different like inet or macaddr. For type inet, following
error message is produced : could not format inet value: Address family
 not supported by protocol family, and for type macaddr the value
inserted is corrupted.
 I am sure the problem is in how I make the Datum's for the invokation
of prepared plan, but I couldn't find a proper example anywhere. Here
is how I tried to implement it :

SPIPlanPtr plan = NULL;
Oid *types = palloc(sizeof(Oid));

types[0] = INETOID;

if((plan = SPI_prepare("insert into sometable valeues($1)", 1, types))
== NULL) {

// handle the error

}

Datum *params = palloc(sizeof(Datum));
char *nulls = palloc(1);

params[0] = DirectFunctionCall1(textin,
CStringGetDatum(pstrdup("192.168.1.1")));
nulls[0] = ' ';
if(SPI_execute_plan(plan, params, nulls, FALSE, 1) <= 0) {

// handle the error

}


Thanks!

Best regards
Alex Vinogradovs


В списке pgsql-general по дате отправления:

Предыдущее
От: dan chak
Дата:
Сообщение: table references with partitioning
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: tsearch2 in postgresql 8.3.1 - invalid byte sequence for encoding "UTF8": 0xc3