#58 Transfer Tool snags on _float8

open
nobody
None
5
2007-05-29
2007-02-27
niels
No

Hi,

I am using the transfer tool to migrate a postgres 8.0 database into hsql. The transfer tool is getting stuck because a floating point field in postgres is mapped to _FLOAT8 in hsql ddl, which throws an exception. The type in postgres is a "double precision[]". I am running hsqldb 1.8.0.7 and postgres 8.0.8.

Here is the stack trace from Transfer Tool:
org.hsqldb.util.DataAccessPointException: Wrong data type: _FLOAT8 in statement [CREATE TABLE array_results(array_results_id INTEGER IDENTITY ,stored_data_main_id INTEGER,name VARCHAR,value _float8]
at org.hsqldb.util.TransferDb.execute(Unknown Source)
at org.hsqldb.util.TransferTable.transferStructure(Unknown Source)
at org.hsqldb.util.Transfer.transfer(Unknown Source)
at org.hsqldb.util.Transfer.actionPerformed(Unknown Source)
at java.awt.Button.processActionEvent(Button.java:388)

Thanks,
Niels

Discussion

  • Fred Toussi
    Fred Toussi
    2007-05-29

    • labels: 325105 -->
     
  • Fred Toussi
    Fred Toussi
    2007-05-29

    Logged In: YES
    user_id=150940
    Originator: NO

    Moved to HSQLDB Utils.

    Needs some code to be added to org.hsqldb.util.PostgresTransferHelper class to translated _float8 to DOUBLE