Generate 'ALTER SEQUENCE'

[Former Member]

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,

[arnaud_laurent]

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