pg 7.3, cursors, and prepared queries

Поиск
Список
Период
Сортировка
От Eric Ridge
Тема pg 7.3, cursors, and prepared queries
Дата
Msg-id 596DBA87-7F61-11D8-A97A-000A95BB5944@tcdi.com
обсуждение исходный текст
Список pgsql-general
Is it really true that prepared statements cannot be used with cursors?

PREPARE foo(int8, text) AS <some really complicated query with a
bazillion joins that takes forever to plan>;
DECLARE foo_cursor CURSOR FOR EXECUTE foo(12::int8, 'some text');
ERROR:  syntax error at or near "EXECUTE" at character 31

I've tried with 7.3, and w/ 7.4 (though I can't upgrade to 7.4 yet).

Please, say it ain't so.  Tell me I'm doing something wrong!

eric


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Physical Database Configuration
Следующее
От: Tom Lane
Дата:
Сообщение: Re: simple join query runs very slowly