Thread: 8.0.1 and the ODBC driver

8.0.1 and the ODBC driver

From
Script Head
Date:
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.

Re: 8.0.1 and the ODBC driver

From
Peter Eisentraut
Date:
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/

Re: 8.0.1 and the ODBC driver

From
Marko Ristola
Date:
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



Re: 8.0.1 and the ODBC driver

From
Script Head
Date:
> 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

Re: 8.0.1 and the ODBC driver

From
Marko Ristola
Date:
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
>
>