Skip site navigation (1) Skip section navigation (2)

Re: ECPG Preprocessor throws Syntax Error [Devel Repository]

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Ahmed Shinwari <ahmed(dot)shibwari(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ECPG Preprocessor throws Syntax Error [Devel Repository]
Date: 2008-12-12 12:26:22
Message-ID: 20081212122622.GA8289@feivel.credativ.de (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Dec 11, 2008 at 10:09:40PM +0500, Ahmed Shinwari wrote:
> through ECPG preprocessor which I think are potential bugs;
> 
> 1- I get this error message from preprocessor,
> 
> *ERROR: cursor "m_name_cursor" already defined *
> 
> Below is the code snippet, error message is thrown on the last line of this
> snippet;
> 
> EXEC SQL DECLARE m_name_cursor CURSOR FOR SELECT name,id FROM m_table3;
> EXEC SQL OPEN m_name_cursor;
> EXEC SQL CLOSE m_name_cursor;
> 
> /* Declaring cursor with the same name */
> EXEC SQL DECLARE m_name_cursor CURSOR FOR SELECT name,id FROM m_table4;

I might be missing something here, but where do you see the bug? The cursor is
indeed already defined.

> 2- Preprocessor throws this error;
> 
> *ERROR: syntax error at or near "-"*
> ...

Fixed in CVS. Thanks for the report.

Michael
-- 
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Responses

pgsql-bugs by date

Next:From: Sven AlmgrenDate: 2008-12-12 13:53:04
Subject: BUG #4578: Not releaseing memory from PQmakeEmptyPGresult when calling PQisBusy
Previous:From: Scott CareyDate: 2008-12-11 21:52:20
Subject: Re: BUG #4575: All page cache in shared_buffers pinned (duplicated by OS, always)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group