Oracle partition tables to migrate to PostgreSQL with same partition names

[tayalarun1]

Hello Darold,

I am trying to migrate 2 partition tables from Oracle to PostgreSQL using ora2pg. Here my issue is that both partitioned table have the same name of partitions. For example:

Oracle Code

Create table arun_1 (id number, name varchar2(50), dept number) 
partition by list(dept)
(partition dept_1 values (1),
partition dept_2 values (2),
partition dept_3 values (3));

Create table arun_2 (id number, name varchar2(50), dept number) 
partition by list(dept)
(partition dept_1 values (1),
partition dept_2 values (2),
partition dept_3 values (3));

Now when I generate script via ora2pg v23.2, I get the create table & create partitions(table) as below:

PostgreSQL Code

CREATE TABLE arun_1 (
    id bigint,
    name varchar(50),
    dept bigint
) PARTITION BY LIST (dept) ;

CREATE TABLE dept_1 PARTITION OF arun_1 FOR VALUES IN ('01');
CREATE TABLE dept_2 PARTITION OF arun_1 FOR VALUES IN ('02');
CREATE TABLE dept_3 PARTITION OF arun_1 FOR VALUES IN ('03');

CREATE TABLE arun_2 (
    id bigint,
    name varchar(50),
    dept bigint
) PARTITION BY LIST (dept) ;

CREATE TABLE dept_1 PARTITION OF arun_2 FOR VALUES IN ('01');
CREATE TABLE dept_2 PARTITION OF arun_2 FOR VALUES IN ('02');
CREATE TABLE dept_3 PARTITION OF arun_2 FOR VALUES IN ('03');

So upto create of table arun_2 is good. But as I execute statement:

CREATE TABLE dept_1 PARTITION OF arun_2 FOR VALUES IN ('01');
ERROR:  relation "dept_1" already exists

Please advise.

Thanks Arun

[darold]

Sorry for the response delay, I guess you have found the PREFIX_PARTITION configuration directive. It is now replaced by RENAME_PARTITION to fully rename the partition instead of just prefixing with the table name.