Skip to Content
avatar image
Former Member

Generate 'ALTER SEQUENCE'

Hi all and thank you for your help.

I'm using powerdesigner 16.6 SP1 to model an postgresql database, but i can't associate sequences with PKs...

"To associate the sequence with the column, double-click the column entry. Then, in the General tab, specify the name of the sequence."

but i already did this...

the problem is that when i generate database, the sequences are simply created, but not associated with the column...

create sequence SQ_CARGO;

create table CARGO (
   ID                   INT4                 not null,
   NOME                 VARCHAR(20)          not null,
   ROLE                 VARCHAR(100)         not null,
   constraint PK_CARGO primary key (ID)
);

It's missing

ALTER SEQUENCE sequence_name OWNED BY table_name.colum_name;

Thanks for you help,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 05, 2018 at 03:15 PM

    Hello,

    I confirm your findings. The ALTER SEQUENCE command is not available in the PostgreSQL DBMS resource file provided with PD.
    I recommend you contact SAP Product Support to open an incident and have a Change Request logged.

    Cheers,
    Arnaud

    Add comment
    10|10000 characters needed characters exceeded