Hello!
On Sunday 01 March 2009 04:37:44 Don Baccus wrote:
> nspostgres works fine with both aolserver 4.0.10 and 4.5. It's used
> in production at education sites with tens of thousands of users
> running aolserver/postgres-based e-learning software.
AOL Server 4.5 doesn't work with PostgreSQL 8.1 on my debian etch and lenny
boxes. May be it works with PostgreSQL 8.3, I don't know. I think this is
problem of debian AOL Server build or PostgreSQL build.
> So Jeff's suggestion of rebuilding against 4.5 is a good one.
>
> What kind of datatype errors are you getting in PG 8.3 in debian
> lenny? I use PG 8.3 w/o problems, but must admit I've built mine from
> source.
offline1=# select '1'=1;
?column?
----------
t
(1 row)
offline1=# select avalue('a 1','a');
avalue
--------
1
(1 row)
offline1=# select avalue('a 1','a')=1;
ERROR: operator does not exist: text = integer
As I did find in google the problem is resolved in PostgreSQL trunk but debian
lenny build doesn't fixed now.
Best regards.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to
<[email protected]> with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.