From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: 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 02:53:03 +0000
Message-ID: <35E2270F.40C138DD@alumni.caltech.edu> (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>
> > 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: lockhart@alumni.caltech.edu, byronn@insightdist.com, ggryschuk@scf.sk.ca
Subject: Re: [INTERFACES] iodbc interface on Unix
In-Reply-To: <35E2270F.40C138DD@alumni.caltech.edu>
* 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