Re: 7.3beta and ecpg

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at>
Cc: Michael Meskes <meskes(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>, "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Subject: Re: 7.3beta and ecpg
Date: 2002-09-11 12:43:49
Message-ID: 20020911124349.GE1648@feivel.fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 11, 2002 at 11:23:45AM +0200, Zeugswetter Andreas SB SD wrote:
> I know this is not really related, but wouldn't the plan be to make
> ecpg actually use the backend side "execute ..." now that it is available ?

Maybe I misunderstood something. Do you mean I could use the backend
PREPARE/EXECUTE to prepare and execute any statement I can
PREPARE/EXECUTE with the ecpg part? Can I use PREPARE to prepare a
cursor? In that case I will gladly remove the ecpg stuff.

I just looked into the backend any further and wonder why I didn't
understand earlier. For some reason I was believing this was just an
optimization command.

It seems I can use larger parts of this thus reducing ecpg parser's
complexity as well.

> ecpg needs eighter 'execute :idvar' or 'execute id', so either idvar is a
> declared variable or id a statement id. I don't know if that is something a
> parser can check though :-(

Actually ecpg needs 'execute id using ... into ...'. I did not see any
mention of using in the backend execute command. The 'execute :idvar'
part is easier since this correctly is named 'execute immediate :idvar'
I think.

AFAIK the standard is "execute ID using value" and not "execute
ID(value)". Please correct me if I'm wrong, but right now ecpg uses the
first syntax the backend uses the second.

Michael
--
Michael Meskes
Michael(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2002-09-11 12:55:32 Re: problem with new autocommit config parameter and jdbc
Previous Message Stephan Szabo 2002-09-11 12:43:03 Re: problem with new autocommit config parameter and jdbc