public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dave Page <[email protected]>
To: Michael Meerschaert <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: [pgAdmin 4 UI bug] unable to add foreign keys through the UI
Date: Mon, 25 Jul 2016 09:16:04 +0100
Message-ID: <CA+OCxowEaAofkmHZJ6kqeRZ_JGuU1bS=fXY5sgHGUr461-tuaQ@mail.gmail.com> (raw)
In-Reply-To: <CANdgRMBE7MaGoLRLPWNbryZ4gz6EgYoefPq90yutZC6H+Ubocw@mail.gmail.com>
References: <CANdgRMBE7MaGoLRLPWNbryZ4gz6EgYoefPq90yutZC6H+Ubocw@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgadmin-hackers>

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
<[email protected]> 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


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: [pgAdmin 4 UI bug] unable to add foreign keys through the UI
  In-Reply-To: <CA+OCxowEaAofkmHZJ6kqeRZ_JGuU1bS=fXY5sgHGUr461-tuaQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox