Skip to Content
0

Generate 'ALTER SEQUENCE'

Feb 08, 2017 at 04:27 PM

36

avatar image
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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers