pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

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

Open dpage opened this issue 6 years ago • 3 comments

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 avatar May 17 '19 19:05 dpage

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 avatar May 17 '19 19:05 dpage

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 avatar May 24 '19 11:05 dpage

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

dpage avatar Jun 25 '21 11:06 dpage