Skip site navigation (1) Skip section navigation (2)

RE: [INTERFACES] ecpg and getting just assigned serial number

From: Craig Orsinger <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil>
To: Andreas Theofilu <theofilu(at)eunet(dot)at>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: RE: [INTERFACES] ecpg and getting just assigned serial number
Date: 1999-09-13 18:49:03
Message-ID: XFMail.990913114903.orsingerc@epg-gw1.lewis.army.mil (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-sql
On 13-Sep-99 Andreas Theofilu wrote:
> I can write such a function, of course. But I will not break compatibility
> to Informix, because both databases, PostgreSQL _and_ Informix are
> supported in only a single source file.

        I've tried to do this myself, and in the long run I think
you'll be better off planning on having two different versions of 
embedded C, or at least, two different sets of functions that do 
certain operations. Informix ESQL/C and ecpg have significantly 
different syntax, especially regarding CURSORs and FETCHs. If you 
keep things simple, and have some way of converting database names 
between the two systems, you can undoubtedly do what you're trying 
to do. Anything else and it gets really difficult. While Informix
supports EXEC SQL IFDEF, PostgreSQL does not appear to.

        An alternative might be to have a single source file that
can be modified by a sed or awk script to conform to whatever
embedded SQL you're using at the moment. I considered this approach,
but didn't pursue it because I didn't have the time.

        We had a discussion here about this subject in June. The
subject was "esql/c documentation". If you can't find it in the
archive, I can e-mail some of the more interesting posts in that
thread.

----------------------------------
Date: 13-Sep-99  Time: 10:55:47

Craig Orsinger                  (email: <orsingerc(at)epg-gw1(dot)lewis(dot)army(dot)mil>)
Logicon RDA
Bldg. 8B28                      "Just another megalomaniac with ideas above his
6th & F Streets                 station. The Universe is full of them."
Ft. Lewis, WA   98433                   - The Doctor
----------------------------------

In response to

Responses

pgsql-interfaces by date

Next:From: Theofilu AndreasDate: 1999-09-13 19:02:34
Subject: RE[2]: [INTERFACES] ecpg and getting just assigned serial number
Previous:From: Margarita BarvinokDate: 1999-09-13 14:58:43
Subject: Transaction: Begin, Lock

pgsql-sql by date

Next:From: Theofilu AndreasDate: 1999-09-13 19:02:34
Subject: RE[2]: [INTERFACES] ecpg and getting just assigned serial number
Previous:From: Michael RichardsDate: 1999-09-13 14:49:46
Subject: Re: [BUGS] Running queries on inherited tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group