"no snapshot has been set" error

Поиск
Список
Период
Сортировка
От Ruey-Lung Hsiao
Тема "no snapshot has been set" error
Дата
Msg-id t0and.46135$QJ3.38032@newssvr21.news.prodigy.com
обсуждение исходный текст
Ответы Re: "no snapshot has been set" error
Список pgsql-hackers
Hi all,
  I encountered a problem when I'm implementing my user-defined type. 
My  user-defined type is defined as

CREATE TYPE X
(   INTERNALLENGTH = 10   INPUT = X_in,   OUTPUT = X_out
);

In my X_in() function, I want to access other table to do some 
bookkeeping stuff. this table keeps track of the number of calls to 
X_in(). However, while SPI_connect() returns SPI_OK_CONNECT, whenever I 
execute SPI_exec( "SELECT count FROM XTABLE", 0), postgres stops 
executing and issues "Error: no snapshot has been set".

Does anyone here knows what happens?  Am I not allowed to use SPI 
functions in this situation?

Thank you for your advice and suggestions in advance.

Ruey-Lung Hsiao


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

Предыдущее
От: Arman Bostani
Дата:
Сообщение: bug/issue tracking system?
Следующее
От: Ruey-Lung Hsiao
Дата:
Сообщение: How to check the postgresql version