SPI_execute_with_args call

Поиск
Список
Период
Сортировка
От Yuriy Rusinov
Тема SPI_execute_with_args call
Дата
Msg-id CAA5U4sw2=uGjNCjOry1uBC-os_aEGx7BRHQ3myXRKLFYRGXHUA@mail.gmail.com
обсуждение исходный текст
Ответы Re: SPI_execute_with_args call
Re: SPI_execute_with_args call
Список pgsql-general
Дерево обсуждения
Hello, colleagues !

I have to write random number generator state into database table
Table structure is 
table rand_state
{
    id serial not null primary key,
    state_rand bytea
};

In C-function I do
size_t nr_ins = strlen ("insert into rand_state (state_rand) values ($1);");
char * r_sql = (char *) palloc (nr_ins + 1);
strncpy (r_sql, "insert into rand_state (state_rand) values ($1);", nr_ins);

Oid * oids = (Oid *)palloc (sizeof (Oid));
Datum * val = PointerGetDatum (randBuf);
*oids = BYTEAOID;
const char * nulls = "NULL";
int rins = SPI_execute_with_args (r_sql, 1, oids, val, nulls, false, 1);

randBuf is a void * pointer that contains random number generator state,
when I try to execute SPI_execute_with_args (r_sql, 1, oids, val, nulls, false, 1); I receive error 
The connection to the server was lost. Attempting reset: Failed.
Could you give some work examples for SPI_execute_with_args because I didn't find them in documentation. 

Thanks a lot.

--
Best regards,
Sincerely yours,
Yuriy Rusinov.

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