Tested with OOO320_RC1 w/ Ubuntu 9.10 and Win XP, PostgreSQL driver 0.7.6
Confirmed
Change OS to all

@oj,jbu: please have a look.

@jbu: Please have a look at http://www.openoffice.org/issues/show_bug.cgi?id=101587
and the corresponding feature mail.

@oj:

the feature mail leaves me with no clue what to do. Do you have a spec (or can
you point me to a sample source file) for at least the mandatory parameters
(urlpattern,ParentURLPattern , driver) ? Shall the configuration still be passed
in the DataAccess.xcu ?

Bye,

Joerg

-------
her my old DataAccess.xcu, which used to wor.
<?xml version="1.0" encoding="UTF-8"?>
<oor:node xmlns:oor="http://openoffice.org/2001/registry"
xmlns:xs="http://www.w3.org/2001/XMLSchema" oor:name="DataAccess"
oor:package="org.openoffice.Office">
 <node oor:name="UserDefinedDriverSettings">
       <node oor:name="Postgresql Driver" oor:op="replace">
	     <prop oor:name="DriverPageDisplayName">
		   <value>Postgresql-SDBC Driver V 0.7.5</value>
	     </prop>
	     <prop oor:name="DriverTypeDisplayName">
		   <value>postgresql</value>
	     </prop>
	     <prop oor:name="DriverDsnPrefix">
		   <value>sdbc:postgresql:</value>
	     </prop>
       </node>
 </node>
</oor:node>

You may have a look at 
http://svn.services.openoffice.org/opengrok/xref/Current%20%28trunk%29/connectivity/source/drivers/jdbc/jdbc.xcu

or 

http://svn.services.openoffice.org/opengrok/xref/Current%20(trunk)/connectivity/source/drivers/hsqldb/hsqldb.xcu

or any other driver at 
http://svn.services.openoffice.org/opengrok/xref/Current%20(trunk)/connectivity/source/drivers

- oj

Created attachment 67427 [details]
add the file to drivers zip-file

ok, adding the attached postgresql.xcu to the drivers zip file helps.


After a short rudimentary smoke test, most functionality seems to work, but the
office loops endlessly when entering the extras/relations. Switching off the
postgresql admin tables via the table filter helps here. It seems, that the
office now does a lot of expensive lookups, will need to have a look at this. 

Will do some more qa during the next days and release a new driver version.

Bye,

Joerg

Could you be more descriptive?

Should I add xml code from attached postgresql.xcu to file:
/opt/openoffice.org/basis3.2/share/registry/data/org/openoffice/Office/DataAccess.xcu
??

I would like to use OOo with postgresql in 3.2 release too.

@ h0l0fernes what I did 
- Removed the extension from my OO.o instance
- replaced the contents of DataAccess.xcu INSIDE the extension zip file. 
- installed the extension again

did the trick for me.

@oj: In OO3.1 and earlier, there was a user/password tab page in the connection
settings, this is gone in OOo3.2 with my minimal config file. Can I add
something in the config file, so that the user/password page appears again ? I
looked through the various options, but I didn't find a setting for it.

Otherwise the user must add the password human readable within the url ...

The performance issue in the relations dialog existed already in 3.1, I will
follow this at a later time.

Bye,

Joerg

Hi Joerg,
this one should enable the user - password dialog.

<node oor:name="MetaData">
        <node oor:name="Authentication" oor:op="replace">
          <prop oor:name="Value" oor:type="xs:string">
            <value>UserPassword</value>
          </prop>
        </node>
      </node>

@atjensen
Thank You!
Did the trick to me also.

@oj
Thank You also, password dialog is also usefull

3.2 runs a lot smoothier than 3.1. 
Great job!

I have released driver version 0.7.6a which includes the fixes mentioned in this
issue. Check the drivers hompage. http://dba.openoffice.org/drivers/postgresql/

So this issue can be closed I guess.