Re: PostGres Doubt
От | Bruce Momjian |
---|---|
Тема | Re: PostGres Doubt |
Дата | |
Msg-id | 200206122219.g5CMJvB17628@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: PostGres Doubt ("Dann Corbit" <DCorbit@connx.com>) |
Ответы |
Re: PostGres Doubt
(Michael Meskes <meskes@postgresql.org>)
|
Список | 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@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: