Re: ODBC, ssl, problems with. - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: ODBC, ssl, problems with.
Date
Msg-id Pine.LNX.4.30.0106161442020.755-100000@peter.localdomain
Whole thread Raw
In response to ODBC, ssl, problems with.  (Dariusz Pietrzak <dariush@ajax.umcs.lublin.pl>)
Responses Re: ODBC, ssl, problems with.
List pgsql-general
Dariusz Pietrzak writes:

>  I am having some problems with ODBC, namely - I can't find documentation
> about it ( it  meaning ODBC driver for postgres ).

http://www.de.postgresql.org/users-lounge/docs/7.1/postgres/odbc.html

>  I am seeking SSL enabled driver for postgres

I don't think that exists.

>  what is row versioning?
> It adds 'xmin' column to all my tables, and then Access becomes unable to
> modify 'row versioned' tables because postgres complains about
> incompatibility between 'xid' and 'int4' types. (xmin presumably being xid
> type ).

The xmin column does exist in all PostgreSQL tables.  Presumably this
option merely makes it show.  I don't think this is useful for general
use.

>  Show oid shows oids, but what are they usefull for?

If you don't use them then they're not useful for you.

> Show oids option is also dangerous because it adds column
> before not after any columns, thus forcing changes to application
> expecting something at given column.

If your application is coded like that then you should evidently not use
the show oids option.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Gunnar Rønning
Date:
Subject: Re: [JDBC] The bytea datatype and JDBC
Next
From: Dariusz Pietrzak
Date:
Subject: Re: ODBC, ssl, problems with.