Following cursor declaration which worked in 7.3.4, produces
a seg fault with 7.4.1 and todays cvs.

exec sql
declare functestcur0 scroll cursor for
select oid, * into
:rownum
,:sfunckey
,:sfuncfill
from functest
where funckey between :xsfunckey
and :efunckey
order by funckey
;
(All referenced variables are declared correctly)

Margit



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Fri, Feb 27, 2004 at 07:16:43PM +0100, Margit Schubert-While wrote:
Hmm, not for me:

../preproc/ecpg a.pgc
a.pgc:7: WARNING: cursor `functestcur0=C2=B4 has been declared but ot opened

With a.pgc being exactly your declare statement plus some variable
definitions.

For the furture, please include a test case I can work with. Just that
one line does not enable me to find the bug at all as you can see. In
fact it is not even enough code to run a simple test. It shouldn't be
too difficult to include the variable declarations so it's at least
compilable code.

Michael
--=20
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Actually caused by undefined variable later in the code.
Sample prog sent to Michael.
Margit



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On Sun, Feb 29, 2004 at 09:22:45PM +0100, Margit Schubert-While wrote:
Sorry, forgot to tell you that I fixed this. Should be in latest CVS,
HEAD and 7.4.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes (AT) jabber (DOT) org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster