The following bug has been logged online:
Bug reference: 5236
Logged by: Marcelo Mas
Email address: mmas(at)atg(dot)com(dot)uy
PostgreSQL version: 8.4.1
Operating system: Suse 10
Description: Aparent bug in ecpg
At the company I work we developed a database adapter in C using ECPG for
postgresql 8.1.2 but when used with postgresql 8.4 we had the following
The program needs to prepare sentences in function A with name using:
EXEC SQL PREPARE :sentencename from :sentencecontent ;
Later it uses another function B in witch it is the following code :
EXEC SQL EXECUTE :sentencename using :values_struct:values_indicators ;
where the content of :sentencename is the same in both cases.
In run time, this sequence of execution works for 8.1.2 but not for 8.4.1
Second case does report errors like 'undefined sentence "name" ' and 'too
many parameters' .
If we modify the code to prepare and execute in same function (only for
testing ) it runs ok, but we do need to do it separately since one
preparation is for many executions.
If this report is not enougth clear you can mail me.
pgsql-bugs by date
|Next:||From: Robert Haas||Date: 2009-12-09 03:12:55|
|Subject: Re: BUG #5235: Segmentation fault under high load through JDBC|
|Previous:||From: Oleg Jurtšenko||Date: 2009-12-08 20:08:10|
|Subject: Re: BUG #5235: Segmentation fault under high load through