Found two bugs in the EnterpriseDB-Migration Toolkit

Hi

I have been asked to port a number of Oracle databases to Postgres and have started working with the EnterpriseDB Migration Toolkit. Things are generally fine but, with the latest release downloaded with Postgres 9.1 I get two specific errors. I would be happy to look at them (as I think they will be pretty simple) but I can't seem to find the source for the Migration Toolkit or a issue tracker.

Problem 1.

I have an Oracle column defined as:

IGNORE_HOLIDAYS NUMERIC(1) DEFAULT 0 NOT NULL

When I migrate this the default value does not get converted so the migration script fails:

IGNORE_HOLIDAYS BOOLEAN DEFAULT 0 NOT NULL

Problem 2.

The second problem is more akward (I can obviously change the script manually for the above error). I try and run a data import via the tool and the SQL insert statements created are incorrect. This occurs only when I have a Blob AND a Boolean field in the table in question. So for example I have the following two columns on my Oracle table:

FILE_CONTENT BLOB,
LIVE NUMERIC(1) NOT NULL,

And these will be converted to

FILE_CONTENT BYTEA,
LIVE BOOLEAN NOT NULL,

The problem then occurs during the creation of the insert statements. Looking at the logs these are created as follows:

... '<stream of 18111 bytes>', 1, ...

The problem is the number 1 is used instead of TRUE.

The insert SQL is created correctly for tables where there is a BOOLEAN field but not when there is a BOOLEAN field and a BLOB/BYTEA field.

Chris Mein