#35 Serial / integer column type mismatch error on FK

open
None
5
2011-08-22
2011-06-28
Anonymous
No

When creating a FK from an integer (child record) to a serial (parent record ID), PGD generates an error even though both fields are technically equivalent (integers). (PostgrSQL 9.x).

Discussion

  • Mind And Go

    Mind And Go - 2011-08-22

    Hy,

    Wich version of pgdesigner are you using?
    Have you tried to create the relation and then change the type in the child table?

    regards

     
  • Carlotto Luigi

    Carlotto Luigi - 2011-08-22
    • assigned_to: nobody --> md9327
     
  • Carlotto Luigi

    Carlotto Luigi - 2011-08-22

    pgDesigner not understand the difference between the types, but if two fields are related, the change in the scope of the parent table is reflected in the field of the table (or tables) daughter. It is, therefore, changed the type of dependent fields.
    If you want to use a particular type of field, all fields must be employees of the same type.
    It is also not allowed to create partial fields, and thus should be connecting 1 to 1.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks