Ubuntu
libreoffice package

  1. Bug #782292
  2. Comment #32

Comment 32 for bug 782292

Revision history for this message
In , Lionel Elie Mamane (lionel-mamane) wrote :

(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.