A friend asked me to figure out how to access PostgreSQL from Tcl via
ODBC. For posterity, here's the step by step "how I did it" that I
emailed to him. I don't know Tcl, this was just about getting the
compile options correct and doing the proper sysadminning to make
things work.

Comments, suggestions and clarifications appreciated, hopefully this
will save the next person going through the pain a few steps:

http://www.flutterby.com/archives/2001_Feb/19_PostgreSQLfromTclwithODBC.html

Mon, 19 Feb 2001 14:49:45 -0800 (PST)
Dan Lyke <danlyke@flutterby.com>
A How-To: PostgreSQL from Tcl via ODBC

Hooray! These instructions are just what an
almost-novice needs.

With the exception of changing the password to
'postgresql', the procedures started smoothly.

Ran into a hitch at 'make' which reported that 'bison'
was not installed.  I'm running debian potato, so used
the apt-get install of bison.  Bison is installed in
/usr/bin. I copied it to /home/billb/pgsql.

Still getting the 'bison missing' message.

Can anyone show me the error of my ways.

TIA
Bill



--- Dan Lyke <danlyke@flutterby.com> wrote:
> A friend asked me to figure out how to access
> PostgreSQL from Tcl via
> ODBC. For posterity, here's the step by step "how I
> did it" that I
> emailed to him. I don't know Tcl, this was just
> about getting the
> compile options correct and doing the proper
> sysadminning to make
> things work.
> 
> Comments, suggestions and clarifications
> appreciated, hopefully this
> will save the next person going through the pain a
> few steps:
> 
>
http://www.flutterby.com/archives/2001_Feb/19_PostgreSQLfromTclwithODBC.html


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Tue, 20 Feb 2001 08:40:17 -0800 (PST)
Bill Barnes <kgbsoft@yahoo.com>
Re: A How-To: PostgreSQL from Tcl via ODBC
Bill Barnes <kgbsoft@yahoo.com> writes:
> Ran into a hitch at 'make' which reported that 'bison'
> was not installed.  I'm running debian potato, so used
> the apt-get install of bison.  Bison is installed in
> /usr/bin. I copied it to /home/billb/pgsql.

> Still getting the 'bison missing' message.

Re-run configure, and watch to make sure that it finds bison this time.
You'll need flex too, if you intend to build from CVS sources.

			regards, tom lane

Tue, 20 Feb 2001 12:28:39 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: A How-To: PostgreSQL from Tcl via ODBC 

Thanks.  That cleared the bison problem.

flex didn't work the same way though.  Copied it also
to /home/billb/pgsql.  Reported missing.  Needs to go
someplace else?

TIA
Bill

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Bill Barnes <kgbsoft@yahoo.com> writes:
> > Ran into a hitch at 'make' which reported that
> 'bison'
> > was not installed.  I'm running debian potato, so
> used
> > the apt-get install of bison.  Bison is installed
> in
> > /usr/bin. I copied it to /home/billb/pgsql.
> 
> > Still getting the 'bison missing' message.
> 
> Re-run configure, and watch to make sure that it
> finds bison this time.
> You'll need flex too, if you intend to build from
> CVS sources.
> 
> 			regards, tom lane


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Tue, 20 Feb 2001 10:15:01 -0800 (PST)
Bill Barnes <kgbsoft@yahoo.com>
Re: Re: A How-To: PostgreSQL from Tcl via ODBC 
> Ran into a hitch at 'make' which reported that 'bison'
> was not installed.  I'm running debian potato, so used
> the apt-get install of bison.  Bison is installed in
> /usr/bin. I copied it to /home/billb/pgsql.
>
> Still getting the 'bison missing' message.

You need to remove config.cache before reconfiguring.

Here's a hint for all who are getting PostgreSQL from CVS, are anyone else
really:  Run configure with --cache=/dev/null.  There is never a reason
why you would need that cache, and there is an infinite number of reasons
why you don't want it.  It's going to save you a lot of head aches.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Tue, 20 Feb 2001 19:23:40 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: Re: A How-To: PostgreSQL from Tcl via ODBC
Bill Barnes <kgbsoft@yahoo.com> writes:
> Thanks.  That cleared the bison problem.

> flex didn't work the same way though.  Copied it also
> to /home/billb/pgsql.  Reported missing.  Needs to go
> someplace else?

Hmm, should work the same: configure will find it if it's in your PATH.

			regards, tom lane

Tue, 20 Feb 2001 13:39:28 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: A How-To: PostgreSQL from Tcl via ODBC 
Bill Barnes writes:
> Ran into a hitch at 'make' which reported that 'bison'
> was not installed.  I'm running debian potato, so used
> the apt-get install of bison.  Bison is installed in
> /usr/bin. I copied it to /home/billb/pgsql.

I'm a Debian user too, but I had bison installed. Remove it from
/home/billb/pgsql (as long as it's in your path things should be
okay), and try running "configure" again.

Dan

Tue, 20 Feb 2001 11:03:48 -0800 (PST)
Dan Lyke <danlyke@flutterby.com>
Re: A How-To: PostgreSQL from Tcl via ODBC
Tom Lane writes:
> Re-run configure, and watch to make sure that it finds bison this time.
> You'll need flex too, if you intend to build from CVS sources.

And if you're going to use the ODBC drivers under Linux (or any other
OS that links C "strings" into read only memory) you'll need pretty
recent CVS sources.

One of the bugs I had to track down even though my original CVS update
was only a few weeks old.

Dan

Tue, 20 Feb 2001 11:06:06 -0800 (PST)
Dan Lyke <danlyke@flutterby.com>
Re: Re: A How-To: PostgreSQL from Tcl via ODBC 
Dan Lyke <danlyke@flutterby.com> writes:
> Bill Barnes writes:
>> Ran into a hitch at 'make' which reported that 'bison'
>> was not installed.  I'm running debian potato, so used
>> the apt-get install of bison.  Bison is installed in
>> /usr/bin. I copied it to /home/billb/pgsql.

> I'm a Debian user too, but I had bison installed. Remove it from
> /home/billb/pgsql (as long as it's in your path things should be
> okay), and try running "configure" again.

Yeah, if it's in your path to begin with then it shouldn't be necessary
to copy it (and it's hard to believe that /usr/bin isn't in your path).

I suspect Peter Eisentraut had the right answer: flush the config.cache
file before running configure, else it'll reuse its previous result
about whether bison exists.

			regards, tom lane

Tue, 20 Feb 2001 16:04:58 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: A How-To: PostgreSQL from Tcl via ODBC 