postgres 9 ? (Zeos)
lazarus / 16-Databases

----------------------------------------------------------------------
TurboRascal · 2011-02-05 00:53

I've tried to access a PostgreSQL 9.0.2 database server, both using
TPSQLConnection (from Lazarus version 0.28.2) and using ZeosDBO 6.6.6.
(tried protocol 'postgres' since 'postgres7' and 'postgres8' obviously
wouldn't work), but both failed to load postgres client DLL (on
Windows). Tried it on the same machine where postgres is installed, so
any missing DLL's should't be a problem.

So the question is, is there a way I can connect to the postgres 9?

----------------------------------------------------------------------
Marc · 2011-02-05 15:34

why is it obviously that a postgres8 connection won't work ? Did you
try ?

----------------------------------------------------------------------
TurboRascal · 2011-02-05 17:27

Uhm, I just assumed so, because there exist different protocols for
different versions. 

I'm not sure if it is an issue though, both controls complained about
problem with client DLL, not connection...?

----------------------------------------------------------------------
Marc · 2011-02-06 01:04

iirc a postgres 8 client can connect to a postgres 9 database

but a v9 client might have v9 specific dlls (which don't have the v8
name)

----------------------------------------------------------------------
TurboRascal · 2011-02-06 01:41

So I guess I could connect by supplying v8 client dll to the
program...

I wonder when will v9 client dlls be supported by Lazarus
components...

----------------------------------------------------------------------
TurboRascal · 2011-02-08 21:36

I managed to identify the problem in the meantime.

Another DLL upon which the client DLL depends was missing, obviously
it simply refused to load without it. The message about missing DLL
which was really present confused me.

----------------------------------------------------------------------
Marc · 2011-02-08 23:25

so you were able to connect using v9 client dlls ?

----------------------------------------------------------------------
TurboRascal · 2011-02-08 23:58

Yes, both by using the TPQConnection and TZConnect (set simply to
"postgres" protocol). Accessing it via TZTable provoked a crash
though, I'm not sure if it is due to problems with pg 9 or maybe the
OS being Win7 x64... That worked fine on another machine with WinXP
and pg 8.4.

BTW another question, TZQuery locks up on both machines, although I
only did a "select * ..." which works fine with the builtin TSQLQuery
and the same  worked fine with TZTable (on XP + pg 8.4). Why might
that happen?