pg 7.3, cursors, and prepared queries - Mailing list pgsql-general

From Eric Ridge
Subject pg 7.3, cursors, and prepared queries
Date
Msg-id 596DBA87-7F61-11D8-A97A-000A95BB5944@tcdi.com
Whole thread Raw
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Physical Database Configuration
Next
From: Tom Lane
Date:
Subject: Re: simple join query runs very slowly