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 по дате отправления: