ecpg "problem" ... - Mailing list pgsql-hackers

From Marc G. Fournier
Subject ecpg "problem" ...
Date
Msg-id 20021112145704.Q20557-100000@hub.org
Whole thread Raw
Responses Re: ecpg "problem" ...  (Jakub Ouhrabka <jouh8664@ss1000.ms.mff.cuni.cz>)
ecpg "problem" ...  (Lee Kindness <lkindness@csl.co.uk>)
Re: ecpg "problem" ...  (Michael Meskes <meskes@postgresql.org>)
List pgsql-hackers
       if (ic_flag == 1) {       /*only select those non-IC/Spyder nodes that has full update set*/       EXEC SQL
DECLAREfull_dyn_node CURSOR FOR                SELECT node_name FROM NODE                WHERE dynamic_community = 'f'
ANDic_flag='n' AND machine_type!=22                AND node_id != 0 AND NODE_NAME != :nodename;       }       else{
 EXEC SQL DECLARE full_dyn_node CURSOR FOR                SELECT node_name FROM NODE                WHERE
dynamic_community= 'f'                AND node_id != 0 AND NODE_NAME != :nodename; (line#493)       }
 

the above code generates the following error:

The compiler complains:
../subapi.pgc:493: ERROR: cursor full_dyn_node already defined

since its envelop'd in an if/else clause, shouldn't it work?





pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: RC1?
Next
From: "Curtis Faith"
Date:
Subject: Prepare enabled pgbench