I have been using postgres with base for several years now. (unlike most I only used mysql in a recent project, and my feeling is postgres is way better)
Right now it is impossible to add/edit/change rows in tables or forms using the SDBC driver. Reverting to the JDBC driver restores normal functionality. Unfortunately the JDBC driver is very slow, especially across a WAN. My guess is the problem is with sdbc driver. The same in OO 3.3 and 3.4 BETA. For a working LO/SDBC?Porgresql combination we need to fall back to OO 3.2.1. Which is hard when you just upgraded to Natty. I hope somebody will take the time to fix the driver. Ferry Joe Collura schreef op vr 08-04-2011 om 01:15 [-0400]: > On 6 April 2011 <[email protected]> wrote about postgresql with > libre-3.3.2 base: > > I'm struggling with Inserting/Updating/Deleting data using BASE forms and > > the postgresql-server, i'm using both the jdbc and sdbc driver, But both > > does not allow me to Insert/Update/Delete data with the postgresql server > > > > same issue with LibO-3.3.2 on Linux/Ubuntu-10.10 and winXP > > > > Plz if anyone can help > > > > good luck to you all! > > > > hi armine, > > i havent quite got postgres to talk to libre yet either > > these might be worth following though: > > 0) "Bug 35683 - RFE: consider adding SDBC into libreoffice for better > access to postgresql" > https://bugs.freedesktop.org/show_bug.cgi?id=35683 > > 1) "Bug 31398 - RFE: LibreOffice Base should allow update/insert/drop > query in sql-editor > with hsqldb access controls" > https://bugs.freedesktop.org/show_bug.cgi?id=31398 > > > also a while ago there was a patch to fedora implementation to > postgresql-libs-8.4.7-1.fc14 that seemed to help but still havent quite > got it. > > jc. > > -- > > Wherever you go; There you are. --BB > > -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
