(In reply to comment #21)
> Kubuntu 11.10 with LO 3.4.3 and the SDBC driver 0.8.
> With this I still can not add/modify records (as opposed to the minimal patch
> in comment #17 which did solve the problem).
> Things that I can think of that cause this:
> - The psql version on the server is 8.3
This is the most likely culprit in my opinion. I use the array function "unnest" in the driver, and "unnest" appeared in PostgreSQL 8.4. Take a look at http://wiki.postgresql.org/wiki/Array_Unnest, it contains instructions on how to add "unnest" to PostgreSQL 8.3 and lower.
> - I might need to set IgnoreDriverPrivileges
This might indeed work around this particular issue, but I think adding "unnest" function will be more robust, as it is used also in other parts of the driver.
(In reply to comment #21)
> Kubuntu 11.10 with LO 3.4.3 and the SDBC driver 0.8.
> With this I still can not add/modify records (as opposed to the minimal patch
> in comment #17 which did solve the problem).
> Things that I can think of that cause this:
> - The psql version on the server is 8.3
This is the most likely culprit in my opinion. I use the array function "unnest" in the driver, and "unnest" appeared in PostgreSQL 8.4. Take a look at http:// wiki.postgresql .org/wiki/ Array_Unnest, it contains instructions on how to add "unnest" to PostgreSQL 8.3 and lower.
> - I might need to set IgnoreDriverPri vileges
This might indeed work around this particular issue, but I think adding "unnest" function will be more robust, as it is used also in other parts of the driver.