Book a Demo

Author Topic: v15 - more strict FKs  (Read 2857 times)

MaXyM

  • EA User
  • **
  • Posts: 120
  • Karma: +8/-0
    • View Profile
v15 - more strict FKs
« on: June 04, 2019, 10:30:03 pm »
Our model has been created using reverse engineering feature of EA from existing db. It imported serial datatype showing it as valid datatype of column. In postgresql, serial datatype is nothing more or less than integer designating assigned sequence to the column.
Anyway it works without additional effort before v15.

In v15, serial datatype remained in tables, but attempt of creating FK referencing this such column ended with error.

I figured out, that I need to add serial (and bigserial) datatype do database datatype dictionary (you can find it in Develop / Data Modeling / Datatypes).

It seems that EA turn into more strict mode, comparing datatypes when creating relationship. But they forgot to add datatypes being already in-use to dictionary.

BTW when I mentioned that serial means integer plus linkage between column and a sequence, it is how it work in postgresql. It's not surprising that EA doesn't cover this relationship.
« Last Edit: June 04, 2019, 10:34:04 pm by MaXyM »