EXCLUDE does not exclude SEQUENCE and TYPE objects

[taneraruk]

Hi,

I am running a test count with this command,

ora2pg -t TEST --count_rows -c ora2pg_test.conf

In config file I exclude a couple of sequences and types like this,

ALLOW	ABC_.*,  DEF_.*
EXCLUDE SEQUENCE GHI_.*
EXCLUDE TYPE JKL, MNL

ALLOW works properly for tables but EXCLUDE does not filter SEQUENCE and TYPE objects.

Environment,

ora2pg Version: 24.1
PostgreSQL Version: 15
Oracle Client Version: 12.2
OS: Openshift Linux

[darold]

If ALLOW is set, EXCLUDE is not taken in account.

About sequences and types, how about:

EXCLUDE SEQUENCE[GHI_.*];TYPE [JKL MNL]

[taneraruk]

I have removed ALLOW and kept only EXCLUDE but none of the combination below worked, seems EXCLUDE only filters tables, neither sequences nor types.

EXCLUDE SEQUENCE[GHI_.*];TYPE [JKL MNL]

EXCLUDE SEQUENCE[GHI_.*],TYPE [JKL MNL]

EXCLUDE SEQUENCE[GHI_.*] TYPE [JKL MNL]

EXCLUDE SEQUENCE[GHI_.*]
EXCLUDE TYPE [JKL MNL]

[darold]

This work just perfectly with me:

EXCLUDE         TYPE[LANGUAGE_T LANGUAGES_T];SEQUENCE[ADDRESS.* FILM.*]

On your setting there is an extra space after TYPE this can be the cause of the problem.

[taneraruk]

this is what exactly my configuration, without ALLOW, and space. Only table is being filtered but sequence and type not.

EXCLUDE TABLE[GDW_.*];SEQUENCE[MDRS_.*];TYPE[ENTITY_VALUE_LIST_TYPE ATTRIBUTE_LIST_TYPE]

This worked for table and type but not sequence

EXCLUDE TABLE[GDW_.*]
EXCLUDE SEQUENCE[MDRS_.*]
EXCLUDE TYPE[ENTITY_VALUE_LIST_TYPE ATTRIBUTE_LIST_TYPE]

During the test count, it does not count the sequence values as well. The problem is with sequences.

The sequence names starts with MDRS_, contains $ sign (MDRS_9A9FC$, MDRS_9AFD$), that might cause the problem?
*Btw tested with EXPORT_INVALID parameters with enabled and disabled status.