From: David Hartwig <daveh@insightdist.com>
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
Cc: Byron Nikolaidis <byronn@insightdist.com>
Cc: Gerald Gryschuk <ggryschuk@scf.sk.ca>
Cc: Postgres Interfaces Mailing List <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] iodbc interface on Unix
Date: Tue, 25 Aug 1998 09:56:38 -0400
Message-ID: <35E2C296.41BF8DF0@insightdist.com> (raw)
References: <35D99896.DFB21123@alumni.caltech.edu>
<35D9D132.4DE6ACB8@insightdist.com>
<86iujpr0qh.fsf@avd.gcom.ru>
<35DAD65D.34165A2F@insightdist.com>
<35DAE850.93FC000C@alumni.caltech.edu>
<35DB06BB.16F5D38D@alumni.caltech.edu>
<35DB1A0A.53F5BD81@insightdist.com>
<35DB2F55.CF1072DA@scf.sk.ca>
<35DB3107.894B0E3C@insightdist.com>
<35DD97AF.30F23F27@alumni.caltech.edu>
<35DDA3D3.D39F5846@insightdist.com>
<35DE2B1C.8F52CF5E@alumni.caltech.edu>
<35E178DC.137ED18@insightdist.com>
<35E2270F.40C138DD@alumni.caltech.edu>
Byron will be unavailable for a day or so.
Thomas G. Lockhart wrote:
> > > I'm not proposing to get rid of
> > > Makefile.unx, just to put "Makefile" into the Postgres distribution.
> > I assume this Makefile is not intended to be used to compile for the
> > Windows environment, yes? I just wanted to be clear on it.
>
> Yes, the makefile called "Makefile" is very Postgres-tree-specific. Not
> intended to replace Makefile.unx or other ways of building a driver
> library.
>
> > > Unfortunately, it takes root privilege for
> > > anyone to write into /etc, whereas it takes no system privilege to
> > > do anything else with Postgres. Anyway, shouldn't we have some
> > > driver-level parameters somewhere in ~/.odbc.ini?
> > Would it be possible to
> > have a local "odbcinst.ini" file in the user's home directory which
> > would get read first, and if that didn't exist, go to the
> > /etc/odbcinst.ini file? That way the user could override certain
> > parameters, such as debugging.
>
> OK, I'm not clear on the usage of odbc.ini. My odbc.ini looks like (note
> that this includes my local mods for "Debug" and "CommLog"):
>
> [ODBC Data Sources]
> PostgreSQL = PostgreSQL Driver
> Postgres = Postgres Simple Spec
> PostgresODBC = PostgresODBC
> Default = Postgres Stripped
>
> [PostgreSQL]
> Debug = 1
> CommLog = 1
> ReadOnly = 0
> Driver = /opt/postgres/current/lib/libpsqlodbc.so
> Servername = localhost
> Username = tgl
> Password = "no$way"
> Port = 5432
> Database = test
>
> <snip>
>
> So, each database entry specifies the full information for each
> database, including which driver to use, host info and account info.
> What is the distinction between all of those entries and the "Debug" and
> "CommLog" fields? What _should_ odbcinit.ini be providing which should
> never be in odbc.ini?
>
> > > 6) gcc doesn't like the "mylog" routine being disabled by defining
> > > an empty macro for it.
> > One solution would be to put #ifdef MY_LOG around each of the mylog
> > statements. Another, which I think is easier and probably more
> > beneficial, is to just forget about trying to not compile them in and
> > simply use the Debug parameter to control the printing (which you have
> > to do anyway).
> > So, all you have to do is just always #define MY_LOG and let the
> > "Debug" parameter control it. On windows, I can still use my comment
> > trick.
>
> OK.
>
> So, I just finished removing the stubs and internal calls which I had
> added in (having now found the linker options which make sure things
> resolve within the library), when I found some additional stubs which
> are in results.c. They have been there since before I touched the code.
> Are they required for Windows? If so, why aren't the other routines
> required to be stubbed as they were on my Unix box without the right
> linker options??
>
> - Tom
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: daveh@insightdist.com, lockhart@alumni.caltech.edu, byronn@insightdist.com, ggryschuk@scf.sk.ca
Subject: Re: [INTERFACES] iodbc interface on Unix
In-Reply-To: <35E2C296.41BF8DF0@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox