From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Dann Corbit <DCorbit(at)connx(dot)com> |
Cc: | Michael Meskes <meskes(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PostGres Doubt |
Date: | 2002-06-12 22:19:57 |
Message-ID: | 200206122219.g5CMJvB17628@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dann Corbit
> > I assume this is because you wrote your code assuming a feature was in
> > ecpg, but it wasn't, right?
>
> I have written lots of programs that use embedded SQL. I have (for
> instance) several ODBC drivers that use embedded SQL and C++ as part of
> an ODBC driver system. I merrily coded away some stuff to do the same
> thing in PostgreSQL. After all, I had already done it for several other
> systems and they all worked just about the same and the effort was
> minimal to change from one system to another.
>
> So now, I started getting down to the details. One global structure...
> I started a major rewrite to repair it. Then (to my abject horror) I
> discovered there is no SQLCA at all. Project abandoned (actually, just
> switched to libpq and everything was OK).
I see SQLCA mentioned in the ecpg code. What am I not understanding?
> > > 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.
>
> I doubt if many people are using it then. There is a NIST SQL suite
> which should be run against it. Have you heard of it? It is a
> standardization for embedded SQL [and other facets of the SQL langauge].
> I think it would be very nice if the PostgreSQL team should try to
> incorporte the whole thing as part of their validation suite. The
> project the uses embedded sql is in the folder /pc under the nist main
> folder. Here is an example from that project that use sqlca:
Oh, that seems easy. I know Michael will know the answer.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Jeroen T. Vermeulen | 2002-06-12 22:25:41 | Re: Integrating libpqxx |
Previous Message | Dann Corbit | 2002-06-12 22:01:31 | Re: PostGres Doubt |