Issue 11059

Hi, 

I am using OpenOffice as a database client to connect to a Postgres database
using unixODBC. Version details are:

OpenOffice      1.0.1
Linux           2.4.2.2 
Postgres        7.2.3   (running with -i option for TCP/IP connections)
unixODBC        2.2.3

Problem1:
Creating a table using Table Design always result in "An unrecoverable error 
occurred ...." and soffice exits. When I restart Openoffice the table has been
created and can be used. 

Problem2:
Unless I create the table using Table Design I cannot update the table. 

If I use SQL or another database client (datadino) to create the table then 
I can use SQL or the application to update the table. I cannot use
OpeneOffice. I thought this might be due to the ODBC driver so I tried JDBC. 
Using JDBC I cannot write to any table at all (read only connections only).
Have you any suggestions for resolving this. My OpenOffice connections are 
configured as follows:

For ODBC

type:    ODBC
URL:     sdbc:odbc:MyOdbc.ini
obdc.ini:
------------------------------------------
[MyOdbc.ini]
Description		= MyOdbc.ini
Driver			= PostgreSQL
Trace			= Yes
TraceFile		= /home/atalanta1/leeder/odbc.log
Database		= <MyDatabase>
Servername		= <Ip Server Ip>
UserName		= <Myusername>
Password		= 
Port			= 5432
Protocol		= 6.4
ReadOnly		= No
RowVersioning		= No
ShowSystemTables	= No
ShowOidColumn		= No
FakeOidIndex		= No
ConnSettings		= 
-----------------------------------

For JDBC: (postgresql.jar added to classpath)

Driver Class: org.postgresql.Driver
URL:          sdbc:postgresql://<ip>:<myport>/<MyDataBase>


I tried to register with the user group earlier but have had problems with 
email the last couple of days (ISP problems!) so have not received a 
confirmation. I hope this query can still be dealt with.

I've been using OpenOffice for a few weeks now and have been 
very impressed at its configurability & scope. Our company is now using
it instead of MS word, excel etc.

Thanks for any help/advice you can provide on my problems.

Regards,
Glen
-----------------------------------------------------
Glen Leeder <leeder@atalanta-consulting.co.uk>
            <gjleeder@hotmail.com>

Tel: +44 1753 874436            
Fax: +44 1753 784365
http://www.atalanta-consulting.co.uk
-----------------------------------------------------