User: jbu Date: 2007/01/08 13:22:11 Modified: dba/www/drivers/postgresql/index.html
Log: released 0.7.3 File Changes: Directory: /dba/www/drivers/postgresql/ ======================================= File [changed]: index.html Url: http://dba.openoffice.org/source/browse/dba/www/drivers/postgresql/index.html?r1=1.41&r2=1.42 Delta lines: +124 -103 ----------------------- --- index.html 28 Nov 2006 09:47:12 -0000 1.41 +++ index.html 8 Jan 2007 21:22:08 -0000 1.42 @@ -54,8 +54,7 @@ postgresql database</a> from OpenOffice.org without any wrapper layer such as odbc or jdbc. - - <p> The current version 0.7.2 can be considerded as beta quality ( + <p> The current version 0.7.3 can be considerded as good beta quality ( with some <a href="#known_bugs">known issues</a> and missing features). </p> @@ -92,7 +91,17 @@ md5sum</th> </tr> <tr> - <td> <strong>0.7.2 (recommended)</strong></td> + <td> <strong>0.7.3 (recommended)</strong> (released 2007-01-08 )</td> + <td> + Windows, Linux x86 (multi platform package) + </td> + <td> + <a href="postgresql-sdbc-0.7.3.zip">http://dba.openoffice.org/drivers/<wbr>postgresql/postgresql-sdbc-0.7.3.zip</a> + </td> + <td>8586328f1e57f17e458a42da949ea174</td> + </tr> + <tr> + <td> 0.7.2</td> <td> Windows, Linux x86 (multi platform package) </td> @@ -212,7 +221,7 @@ . Then install the new version with the following command: <pre> - unopkg add /path/to/your/download/postgresql-sdbc-0.7.2.zip + unopkg add /path/to/your/download/postgresql-sdbc-0.7.3.zip </pre> . Using the --shared option will install the driver for all users. @@ -257,7 +266,7 @@ or 0.6.0) file from the OpenOffice1.1.0/user/uno_packages folder. <p> - Copy the postgresql-sdbc-0.7.2.zip file in <code>OpenOffice1.1.0/user/uno_packages</code> folder + Copy the postgresql-sdbc-0.7.3.zip file in <code>OpenOffice1.1.0/user/uno_packages</code> folder <strong>(Note: USE the zip file as a whole, DO NOT extract it)</strong>. Open up a shell and switch to the OpenOffice1.1.0/program directory and start the </p> @@ -350,11 +359,12 @@ <a name="known_bugs">The</a> following features work with some limitations one needs to keep in mind: <ul> <li> Renaming tables<br> - OOo 2.x offers you to both change schema and table name, however there is no postgresqlcommand - to move a table from one schema to another (let me know, if this is not correct). When you change - the schema name, the table remains in its original schema and gets a table name NewSchema.NewTableName. + You can only change the schema of table or view, when your postgresql server's version is 8.1 or later. + Note that the change is not transactional, + (the alter table statement does not allow this). First the driver changes the schema + and if this succeeds, it tries to change the table's name. - OO1.1.x does not have this problem. + With former versions, you can only change the table's name. </li> <li> Data modifcation <br> Modification of data in tables via the UI (e.g. via the beamer window) is only possible, when @@ -365,7 +375,7 @@ <li> The serial datatype (and default values)<br> Support for serial (= auto increment ) datatype is difficult to implement, - because a) it is not really a type in postgresql. + because it is not really a type in postgresql. <p> You can create tables with serial columns. Therefor you have to choose a int or big int as data type of the column and set the autoincrement @@ -373,8 +383,8 @@ (before you press the save button the <strong>first</strong> time), as postgresql does not support serials in ALTER TABLE statements. - <p> Additionally it is difficult to to retrieve the generated value after an insertion in - such a table. The driver follows a two strategies here. When the table supports + <p> Additionally it is difficult to retrieve the generated value after an insertion in + such a table. The driver follows two strategies here. When the table supports posgresql oids, it uses oid to find the just inserted row again. In case it does not, it queries for the structure of the primary key of the table and uses the curr_val() function to retrieve the last increment of the serial in this session. @@ -419,7 +429,7 @@ implemented in the driver. The loglevel can be set by editing a .ini or rc file in the extracted package. The file is located in the following path : - ~/openoffice.org2/uno_packages/cache/uno_packages/postgresql-sdbc-0.7.2.zip.1086437099/postgresql-sdbc.unorc + ~/openoffice.org2/uno_packages/cache/uno_packages/postgresql-sdbc-0.7.3.zip.1086437099/postgresql-sdbc.unorc , where the number is different on your system. The file can be edited with a texteditor. The logevel can be set to NONE (no logging), ERROR (only errornouss situations are logged), @@ -529,6 +539,17 @@ <a name="changes"><h2>Changes</h2></a> <ul> + <li>Version 0.7.3<br> + <ul> + <li> Now both schema and table name can be changed via "table's context menu / Rename", + when postgresql-server's version is 8.1 or later. Note that the change is not transactional, + (the alter table statement does not allow this). First the driver changes the schema + and if this succeeds, it tries to change the table's name. + + <li> In former version, the retrieval of auto values failed, when the table/primary key column + names had to be quoted. This bug has been fixed. + <li> The driver now builds also in OOo 2.x build environment. + </ul> <li>Version 0.7.2<br> <ul> <li> postgresql >= 8.1.x fully supported<br> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
