search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.4k stars 630 forks source link

Create Column can't add Foreign Key directly with REFERENCES (RM #4274) #2607

Open dpage opened 5 years ago

dpage commented 5 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/4274 Originally created by Michel Feinstein at 2019-05-17 19:42:35 UTC.

REFERENCES is a quick way to create a column and at the same time create a Foreign Key relationship with it, but this ability is currently missing in pgAdmin.

I would like to see something like this in pgAdmin, so I won't have to create an entire table, and then later have to create Foreign Keys for all the fields that need one.

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4274#note-1 Originally created by Michel Feinstein at 2019-05-17 19:44:48 UTC.

Just to clearer, the current way of doing it and the code generated seems bulky and it could be streamlined.

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4274#note-2 Originally created by Akshay Joshi at 2019-05-24 11:28:32 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4274#note-3 Originally created by Rahul Shirsat at 2021-06-25 11:27:33 UTC.

Redmine ticket header update:

Name Old Value New Value
Difficulty changed Easy