Re: pl/pgsql, cursors and C function

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема Re: pl/pgsql, cursors and C function
Дата
Msg-id 3F707820.1000100@klaster.net
обсуждение исходный текст
Ответ на Re: pl/pgsql, cursors and C function  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pl/pgsql, cursors and C function
Список pgsql-sql
>>I don't understand ERROR message at all:
>>  ERROR:  SPI_prepare() failed on "SELECT   $1 "
> 
> 

>  > This is a bug.  Or two bugs, actually: one of yours and one of PG's.
> I have repaired the PG bug with the attached patch.  The bug in your
> code is that your C function needs to call SPI_connect and SPI_finish
> if it's going to use any SPI operations.
> 
>             regards, tom lane

Thanks a lot. The first answer helped me, the second one - the others.

Do you know anything about good source of C functions documentation and 
examples? Currently I'm walking over .h headers to find some useful 
functions and macros.


Regads,
Tomasz Myrta



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

Предыдущее
От: Jeff Kowalczyk
Дата:
Сообщение: updating a field with a SUM from another table
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Using sql statements in file