Re: [SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-06-01 Thread Dean le Roux
I installed the recommended JDBC driver. Set it up to connect using Open office. Still need to test to see how the queries build now, but problem is that the access to the database is dramatically slower than using the sdbc. Is this to be expected. thanks. On 05/24/2011 07:58 AM, Dean le Ro

Re: [SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-05-23 Thread Adrian Klaver
On Monday, May 23, 2011 9:53:47 am Dean le Roux wrote: > postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new > install) Did the OO version change also? > > I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and other > updates have been effected. I used webmin to rest

Re: [SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-05-23 Thread Dean le Roux
Here is the sql statements. We don't pass update, I guess base or the relevant programmes does that. Some transactions that are based on forms seem to update, but sometimes they don't, and it would seem that certain constraints are not met, causing holes in the database. This didn't happen prior

Re: [SQL] problem with update data sets from front ends 8.4, Ubuntu 10.04

2011-05-23 Thread Samuel Gendler
On Mon, May 23, 2011 at 9:53 AM, Dean le Roux wrote: > postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new > install) > > I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and other > updates have been effected. I used webmin to restore the databases. > > Since migrat