Обсуждение: [pgAdmin 4 UI bug] unable to add foreign keys through the UI
Hi,
--
I'm sorry if there is an official bugzilla or something for reporting bugs, but from the comments here it seems like this is the preferred way to report issues.
From the Create - Table dialog, I am unable to add foreign keys. Here's step by step what i'm trying to do:
- Click Constraints > Foreign Key and click Add
- A row appears where i can click edit, trash or enter a name, I also see a red banner at the bottom saying "Please Specify Columns for foreign key
- The columns field is greyed out, so I click the edit icon (If i enter a name, it populates to the name field under general)
- Click Columns
- Select the local column
- select the references table
- As a side note, if there is only 1 other table in the schema, the "references" drop down will default to it, but you cannot select a column from "referencing" from the default dropdown option. You must first change the "references" option, which is impossible if there is only 1 table. Also, even if there are multiple tables, and the references table is correct, you still have to change it to another option then change it back to get the columns in the "referencing" dropdown to show up. This bug has a workaround, but still feels like a bug.
- As a side note, if there is only 1 other table in the schema, the "references" drop down will default to it, but you cannot select a column from "referencing" from the default dropdown option. You must first change the "references" option, which is impossible if there is only 1 table. Also, even if there are multiple tables, and the references table is correct, you still have to change it to another option then change it back to get the columns in the "referencing" dropdown to show up. This bug has a workaround, but still feels like a bug.
- select the column for "Referencing"
- click add
- nothing happens, the red banner that says please specify columns for foreign key is still there.
I can just execute raw SQL to add the constraints, and the UI picks up on the fact that the constraints are there, but I'm still unable to add new FKs through the UI. Also, when I click edit on an existing FK, all the options on the columns and Action tabs are greyed out.
I'm running windows 10 64-bit.
-Mike
Hi Thanks - please log this here: https://redmine.postgresql.org/projects/pgadmin4/issues/new (if you do it rather than me, you'll get emailed when there are updates). Cheers, Dave. On Sat, Jul 23, 2016 at 7:04 PM, Michael Meerschaert <michaelmeerschaert@gmail.com> wrote: > Hi, > > I'm sorry if there is an official bugzilla or something for reporting bugs, > but from the comments here it seems like this is the preferred way to report > issues. > > From the Create - Table dialog, I am unable to add foreign keys. Here's step > by step what i'm trying to do: > > Click Constraints > Foreign Key and click Add > A row appears where i can click edit, trash or enter a name, I also see a > red banner at the bottom saying "Please Specify Columns for foreign key > The columns field is greyed out, so I click the edit icon (If i enter a > name, it populates to the name field under general) > Click Columns > Select the local column > select the references table > > As a side note, if there is only 1 other table in the schema, the > "references" drop down will default to it, but you cannot select a column > from "referencing" from the default dropdown option. You must first change > the "references" option, which is impossible if there is only 1 table. Also, > even if there are multiple tables, and the references table is correct, you > still have to change it to another option then change it back to get the > columns in the "referencing" dropdown to show up. This bug has a workaround, > but still feels like a bug. > > select the column for "Referencing" > click add > nothing happens, the red banner that says please specify columns for foreign > key is still there. > > I can just execute raw SQL to add the constraints, and the UI picks up on > the fact that the constraints are there, but I'm still unable to add new FKs > through the UI. Also, when I click edit on an existing FK, all the options > on the columns and Action tabs are greyed out. > > I'm running windows 10 64-bit. > > > -- > -Mike -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company