on 02-08-2017 4:27 PM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.