I should apologize for being rather harsh about embedded SQL for
PostgreSQL.

To be fair, it does function and it certainly isn't trivial to
implement.  I am sure that those who have worked on this project have
invested very many hours of blood, sweat and tears making it work.

I actually spent a great deal of effort trying to write some tools using
the PostgreSQL version of ECPG, and found fatal flaws that threw away a
couple weeks of work.  I think that is why my responses were so
overwhelmingly negative.

Here is what I would like to see (consider a gentle suggestion):

A reentrant version of ECPG that uses SQLCA and SQLDA like Oracle or Rdb
or DB/2 or any of the professional database systems.

Wed, 12 Jun 2002 11:46:47 -0700
"Dann Corbit" <DCorbit@connx.com>
Re: PostGres Doubt
Dann Corbit wrote:
> I should apologize for being rather harsh about embedded SQL for
> PostgreSQL.
> 
> To be fair, it does function and it certainly isn't trivial to
> implement.  I am sure that those who have worked on this project have
> invested very many hours of blood, sweat and tears making it work.

Oh, OK.  Forget what I said earlier about you writing your own database. :-)

> I actually spent a great deal of effort trying to write some tools using
> the PostgreSQL version of ECPG, and found fatal flaws that threw away a
> couple weeks of work.  I think that is why my responses were so
> overwhelmingly negative.

I assume this is because you wrote your code assuming a feature was in
ecpg, but it wasn't, right?

> Here is what I would like to see (consider a gentle suggestion):
> 
> A reentrant version of ECPG that uses SQLCA and SQLDA like Oracle or Rdb
> or DB/2 or any of the professional database systems.

I see on the TODO list under ECPG:

        o Implement SQLDA
        o Add SQLSTATE

Are these related to your problem?  I see SQLCA in the ecpg code
already.  Is it implemented incorrectly?  If so, I could use items to
add to the TODO list.

You are actually the first person to complain about this, as far as I
can remember.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 12 Jun 2002 17:42:24 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: PostGres Doubt
On Wed, Jun 12, 2002 at 11:46:47AM -0700, Dann Corbit wrote:
> I should apologize for being rather harsh about embedded SQL for
> PostgreSQL.

Also about being harsh about the people? Okay, apologies accepted.

> I actually spent a great deal of effort trying to write some tools using
> the PostgreSQL version of ECPG, and found fatal flaws that threw away a

Which ones? If it's just SQLDA, this is pretty well documented. Yes, the
feature is missing, but we all have only limited time for postgresql
work.

> A reentrant version of ECPG that uses SQLCA and SQLDA like Oracle or Rdb
> or DB/2 or any of the professional database systems.

The last time I used Oracle it used SQLCA in a very similar way as ECPG
does. 

Michael

-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

Thu, 13 Jun 2002 12:05:43 +0200
Michael Meskes <meskes@postgresql.org>
Re: PostGres Doubt
On Wed, Jun 12, 2002 at 05:42:24PM -0400, Bruce Momjian wrote:
> You are actually the first person to complain about this, as far as I
> can remember.

Yup. I cannot remember any other person either. And since nobody
complained, nobody worked on this. :-)

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

Thu, 13 Jun 2002 12:06:28 +0200
Michael Meskes <meskes@postgresql.org>
Re: PostGres Doubt