Thread: 8.0.1 and the ODBC driver
I am attempting to install PostgreSQL 8.0.1 and an ODBC driver. I downloaded the psqlodbc-08.00.0101.tar.gz and according to the README the driver is now a part of the tree, even though the doc continues to refer to 7.2.3. I have unixODBC installed and have configured PostgreSQL 8.0.1 with --with-unixodbc yet I haven't seen the driver being mentioned anywhere during the build process. The 8.0 manual mentions nothing of ODBC driver either. Can someone please clarify this? What one should do to install 8.0.1 and ODBC? Thank you.
Script Head wrote: > Can someone please clarify this? What one should do to install 8.0.1 > and ODBC? The ODBC driver and the PostgreSQL server are completely separate packages to download and install. If you find documentation to the contrary, please tell us so we can remove the confusion. -- Peter Eisentraut http://developer.postgresql.org/~petere/
Peter Eisentraut wrote: >Script Head wrote: > > >>Can someone please clarify this? What one should do to install 8.0.1 >>and ODBC? >> >> > >The ODBC driver and the PostgreSQL server are completely separate >packages to download and install. If you find documentation to the >contrary, please tell us so we can remove the confusion. > > > --with-unixodbc is mentioned in the following three psqlodbc CVS files: configure.ac odbc.sgml README.unix Another thing is the dependencies with the PostgreSQL server: According to the documentation in README.unix, ODBC driver compilation requires PostgreSQL server sources. I compiled from the CVS sources, but I did not use the recommended PostgreSQL 7.3 sources (see README.unix). I compiled the ODBC driver against PostgreSQL 8.0.1. The first command, that is needed for compilation, is aclocal-1.6 -I . -I $PGSRC/config It refers to the PostgreSQL server's sources. Marko Ristola
> The ODBC driver and the PostgreSQL server are completely separate > packages to download and install. If you find documentation to the > contrary, please tell us so we can remove the confusion. It seems my confution has been caused by a type in README.unix in psqlodbc-08.00.0101. The sentence reads: "Since psqlODBC has be moved from the main PostgreSQL source tree, we have yet to create a new build system for the driver." I belive it has to read: "Since psqlODBC has been moved out of the main PostgreSQL source tree, we have yet to create a new build system for the driver." Further, the very same file continues to reference to an older version of the driver, which can also cause confusion as at this point the person isn't sure which version of the driver they are working with. I belive the section that follows should be: To install, just try something like: % tar -zxvf psqlodbc-x.y.z.tar.gz % cd postgresql-x.y.z % ./configure % make % make install where x.y.z is the version of the driver. On a side note it'd be useful to add an ODBC related subchapter to the 8.0.1 installation instructions (chapter 14) and explain that the driver has been moved out of the source tree. I spent quite some time trying to figure that out. Sincerely, ScriptHead
My hypotesis is, that the automake information is not needed in the tar archive at all. If it is needed, it is better to use the CVS stuff as such. Maybe it would be good to separate the build information into two README files in the CVS: README.first (in CVS, build instructions from CVS) README.unix (in CVS and tar archive, build instructions from the tar archive) README.first would contain the CVS archive build instructions: * Prerequisites * Bootstrapping * "See README.unix for further instructions." With these you are able to build the ./configure script. README.unix would contain the normal build instructions: * Building ./configure make make install So, then the tar archive would contain only the README.unix file. In that way the source tar archive users would get the correct and needed information. The configure script makes the process of configuring and compiling easy. Why to make it hard by giving too much or confusing information? This is fast to fix, and fixing has a very low risk, but helps a lot the tar archive users, that compile the psqlodbc by the first time. I mean those, who do not know the psqlodbc building process beforehand. Marko Ristola Script Head wrote: >>The ODBC driver and the PostgreSQL server are completely separate >>packages to download and install. If you find documentation to the >>contrary, please tell us so we can remove the confusion. >> >> > >It seems my confution has been caused by a type in README.unix in >psqlodbc-08.00.0101. The sentence reads: > >"Since psqlODBC has be moved from the main PostgreSQL source tree, we have yet >to create a new build system for the driver." > >I belive it has to read: > >"Since psqlODBC has been moved out of the main PostgreSQL source tree, >we have yet >to create a new build system for the driver." > >Further, the very same file continues to reference to an older version >of the driver, which can also cause confusion as at this point the >person isn't sure which version of the driver they are working with. I >belive the section that follows should be: > >To install, just try something like: > >% tar -zxvf psqlodbc-x.y.z.tar.gz >% cd postgresql-x.y.z >% ./configure >% make >% make install > >where x.y.z is the version of the driver. > >On a side note it'd be useful to add an ODBC related subchapter to the >8.0.1 installation instructions (chapter 14) and explain that the >driver has been moved out of the source tree. I spent quite some time >trying to figure that out. > >Sincerely, >ScriptHead > >---------------------------(end of broadcast)--------------------------- >TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > >