Anyone using PostgreSQL

[Snotface]

Hi,
i am currently using PostgreSQL, but there seems to be a problem with the RCO.
The normal pwdata table is storing and retrieving the testval in aps_demo fine.
The SCO is saving the campaign object fine (or it seems that way) to pwobjdata, but the retrieve is not working.
I get 0 records back, even though the records are in the database.
Anyone got a solution?
Apparently there is a difference between the Blob on most sql DBs and PostgreSQL's bytea. Do i need to do anything in-code around this or does the PostgreSQL ODBC drive take care of the translation?

Using NWNX_ODBC2_0924.

Thanks
Snotty.

[DarkstarsDad]

try this

[Snotface]

Thanks. Downloaded it, but i forgot to mention i'm on Win32.
I've installed the 4.1.11 of MySQL instead and that seems to be running fine.
Thanks for the help anyway.

[Papillon]

Hmm, the PostgreSQL's ODBC driver should take care of this, there is probably nothing we can do about it (and especially not without a snippet from the odbc log file ).
_________________
Papillon

[Snotface]

Hi Papillon,

the ODBC log file wasn't really showing anything, just the normal attach, hook and then disconnect.
In the demo app, retrieving the string was fine, but the blob just kept retrieving 0 records. The SQL statement that was being sent was fine if displayed in the server window, or cut and pasted into a query window, but it kept failing the ValidObject test.
Anyway, MySQL is doing the trick.

I really hope we'll be able to use this, or somehting very close, when NWN2 gets released.

Cheers
Snotty