dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

Problem with duplicate column name

Open BorisDomajnko opened this issue 4 years ago • 5 comments

Description: Cannot restore database: ERROR: column "OB_ID" specified more than once Call getNextException to see other errors in the batch.

If I check the initial dbptk-report-20170126124051360.txt for creation with older DBPTK, I see:

- Type conversion in import module: in `RPE.UL_.OB_ID` (format: schema.table.column) has original type `NUMBER(3,0)` and was converted to the standard type `DECIMAL(3)`
   . . .
- Type conversion in import module: in `RPE.UL_.OB_ID` (format: schema.table.column) has original type `NUMBER(3,0)` and was converted to the standard type `DECIMAL(3)`

And db creation log dbptk-app.log.txt with 2.4.0:

 CREATE TABLE "RPE"."UL_" (
  . . .
 "OB_ID" numeric(3) NOT NULL,
 . . . 
 "OB_ID" numeric(3) NOT NULL,
 . . . 
 
 was aborted: ERROR: column "OB_ID" specified more than once  Call getNextException to see other errors in the batch.

Is it possible to have columns with duplicate names? Is the problem in old siard package or in export into database? Regards, Boris

BorisDomajnko avatar Sep 04 '19 12:09 BorisDomajnko