Database modeling: support for sequences (Postgres

[Robert Rohm]

Hi,

I am using EA 4.5 Corporate for database modeling, mainly with Postgres. Is there any way to have sequence created in the DDL automatically?

I use initial values like nextval(''issue_ID_seq""::text), thus I need the specified ID sequence. Generally, how can sequences represented in the data model?

Thanks in advance,
rrohm

[Bruno.Cossi]

Hi,

there is no built in support for sequences, you could however use classes and assign them a stereotype such as <<sequence>>

Bruno

[peter]

Hi,

don't know if it works for Postgress as well, but when using the "column properties" button in the attributes details dialog, you can choose to use "autonumber".

When selecting this checkbox and generating DDLs for Oracle, the code for the required Sequences and Trigger code for unsing the sequence uppon inserts will be created

cheers
peter

[Bruno.Cossi]

I didn't know about this, that's pretty cool. Thanks Peter!