Opened 3 years ago

Last modified 3 years ago

#33187 closed Bug

Foreign key to a specific field is not handled in inspected — at Initial Version

Reported by: Thierry Bastian Owned by: nobody
Component: Database layer (models, ORM) Version: 3.2
Severity: Normal Keywords:
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

if you have a DB like that

CREATE TABLE foo ( id serial primary key, other_id int UNIQUE);

CREATE TABLE bar ( id serial primary key, other_id int,

constraint myconst

FOREIGN KEY(other_id) references foo(other_id)

);

the generated model for the bar table will have the other_id be a FK to foo and not foo(other_id).

I'm attaching a potential fix for this. Sorry I had no time for the UTs.

Change History (1)

by Thierry Bastian, 3 years ago

Attachment: handle_fk_to_field.diff added

simple patch to handle FK to non pk field.

Note: See TracTickets for help on using tickets.
Back to Top