ODBC, ssl, problems with.

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

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

There are docs for ODBC driver for *nix, I need to access my pg from
windoze.
Anyhow, I'll switch to pgsql-odbc, sorry for polluting this list.

I don't think that exists.

Pity, so I have to write one myself?
anyone coded ssl on windoze platforms?

--
Dariusz Pietrzak
Certified Nobody

At 02:08 PM 6/16/01 +0200, Dariusz Pietrzak wrote:

Hello,

I am seeking SSL enabled driver for postgres ( running ssh tunnel
involves installing cygwin on every client machine, hmm, maybe putty's

You might want to try stunnel. www.stunnel.org.

Works on Windows too.

And example setup:

Server
service listening on 127.0.0.1:port
|
stunnel server mode listening on <Server interface>:<some other port>
connecting to 127.0.0.1:port
|
SSL connection
|
stunnel client mode listening on 127.0.0.1:port2 connecting to <Server
interface>:<some other port>.
|
actual client connecting to 127.0.0.1:port2

Hope that helps.

I remote admin my firewalls that way. I personally don't trust SSH - took a
brief look at it a couple of years ago and got the impression that features
were slapped on, and there would be many security problems. So far I
haven't regretted my decision.

Cheerio,
Link.

You might want to try stunnel. www.stunnel.org.

Thnx, good idea. Generally I wanted to avoid having to use tunneling and
have native ssl odbc driver. But that would be good enough.

--
Dariusz Pietrzak
Certified Nobody