[ADMIN] Solution to createlang plpgsql Failing on Mandrake 9.1

createlang worked as expected and I was able to create functions. I have also added this to the createlang and CREATE LANGUAGE annotated documentation pages to help those who may be experiencing the same problem discover the solution quickly. Regards, Clifford Ilkay Dinamis Corporation 3266 Yo

[ADMIN] Debugging PL/PGSQL

Hi, What do you use for debugging PL/PGSQL code? Regards, Clifford Ilkay Dinamis Corporation 3266 Yonge Street, Suite 1419 Toronto, Ontario Canada M4N 3P6 Tel: 416-410-3326 ---(end of broadcast)--- TIP 7: don't forget to increase your

[ADMIN] Why am I getting a "cursor already in use" error?

pasted the code at <http://www.paste.msunix.org/index.php?view=3012>. Regards, Clifford Ilkay Dinamis Corporation 3266 Yonge Street, Suite 1419 Toronto, Ontario Canada M4N 3P6 Tel: 416-410-3326 ---(end of broadcast)--- TIP 3: if posting

Re: [ADMIN] Why am I getting a "cursor already in use" error?

At 22:42 18/11/2003 -0500, CLIFFORD ILKAY wrote: Hi, I am trying to create a PL/PGSQL stored proc in PostgreSQL 7.3.2 on Mandrake 9.1. I keep getting a "cursor already in use" error even though I only open the cursor once, fetch using that cursor, and then close the cursor when I a