A How-To: PostgreSQL from Tcl via ODBC
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
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/
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
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/
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/
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
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
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
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