jakob / jakob/Postico

Composite foreign keys don't show up anywhere in the table structure.

Open
#318 14 comments 29 reactions 0 assignees View on GitHub
enhancement
Dominant language
Python
Stars
486
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Taking the following tables:

```
create table a (id1 int, id2 int, primary key (id1, id2));
create table b (id1 int, id2 int, foreign key (id1, id2) references a (id1, id2));
```

Looking at table `b` structure in postico doesn't show the foreign key that references table a.

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the report using the SQL for tables a and b, then inspect table b's structure view and the code that gathers and displays foreign keys. Done means the composite foreign key from b(id1, id2) to a(id1, id2) appears in Postico's table structure.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.