[Qt-interest] Postgresql 9 support

[Diego Schulz]

On Tue, Nov 2, 2010 at 1:11 PM, Konrad Rosenbaum <konrad at silmor.de> wrote:
> On Tuesday 02 November 2010 14:38:49 Harry Sfougaris wrote:
>> I'm not sure anyone here can answer this, but I was wondering since
>> Postgresql 9 is not supported currently by Qt, how long does it usually
>> take for a major release of a database server to be supported?
>> Will it be in a 4.7.x release, or are there chances of it being updated
>> before (and I just download the updated code and recompile the plugin)?
>> Sorry if this seems off-topic; maybe if there is a more appropriate
>> mailing list where I should be asking this, someone can please let me
>> know...
>
> Postgres is backwards compatible. Meaning older client libs can access newer
> servers and vice versa. You might miss a few features that only work between
> newest server and newest client (it is likely that you wouldn't want to use a
> wrapper like QtSql if you needed any of those).
>
> If you insist on using the newest client lib - just recompile Qt.
>
>
>        Konrad
>

Hi,

I suspect that by just recompiling Qt isn't enough. A quick peek at
the source [0][1] suggests that there's some missing code in order to
play nice with PostgreSQL 9.x, at least to avoid the warning.

I don't know if there's new functionality and/or schema changes in pg
9.x that needs to be reflected in the qpsql driver, though.

regards,

diego

[0] http://qt.gitorious.org/qt/qt/blobs/4.7/src/sql/drivers/psql/qsql_psql.h
[1] http://qt.gitorious.org/qt/qt/blobs/4.7/src/sql/drivers/psql/qsql_psql.cpp


http://qt.gitorious.org/qt/qt/blobs/4.7/src/sql/drivers/psql/qsql_psql.cpp