[Question] How to generate ALTER COLUMN instructions to set default values to sequences nextval?

[samueldc]

Hi everyone,
I'm taking my first steps with this amazing tool.
I'm trying to migrate an Oracle old database (of an old OTRS 5 instance). In this old database, that has almost 158 tables, most id fields (private keys) are autoincremented using sequences and triggers to insert a sequence nextval into the id field.
ora2pg is doing just fine generating the sequences and updating their current values. But I'm missing the alter column instructions to set default values to the sequences nextval in PostgreSQL (or, maybe, convert all this fields to type identity or serial).
Is that in the scope of ora2pg? Any thoughts on that?
Thanks in advance!
Samuel

[samueldc]

Just to mention I've already looked for similar questions. The issues below seem to be related, but I don't think they address this question:

#1438

#1101

[darold]

Use -t SEQUENCE_VALUES to export the alter statements to set the latest value of each sequences

[samueldc]

I'm using ora2pg v23.2. I'm afraid this export type is not available.

Does export type SEQUENCE_VALUES generate the ALTER TABLE ... ALTER COLUMN id SET DEFAULT nexval... instructions?

[darold]

It is available since version 24.0:

commit b711cc638f945e320237cf2457136021f08186a2
Author: Gilles Darold <[email protected]>
Date:   Thu Mar 16 22:51:31 2023 +0100

    Add SEQUENCE_VALUES export type to export DDL to set the last values of
    sequences like the folowing statements:

      ALTER SEQUENCE departments_seq START WITH 290;
      ALTER SEQUENCE employees_seq START WITH 207;
      ALTER SEQUENCE locations_seq START WITH 3300;

    Thanks to sergey grinko for the feature request.

[samueldc]

Thank you very much. Since I'm looking for a way to generate the set default nextval instructions, I'll keep with version 23. I think I'll generate those instructions by hand.