Postgres Pro
Downloads
Home   >   mailing lists

Re: [pgAdmin4][Patch][RM2257]: Query tool - Insertrow doesn't use default values - Mailing list pgadmin-hackers

From Matthew Kleiman
Subject Re: [pgAdmin4][Patch][RM2257]: Query tool - Insertrow doesn't use default values
Date
Msg-id CAFS4TJbr9cCQUgOVXHuLBFtsxqo7ka3-0DpyAZ6DKPOTm2ysgg@mail.gmail.com
Whole thread Raw
In response to [pgAdmin4][Patch][RM2257]: Query tool - Insert row doesn't usedefault values  (Surinder Kumar <surinder.kumar@enterprisedb.com>)
List pgadmin-hackers
Tree view
Hi Surinder,

We looked at your fix for default values in the query tool editor.

We think the user experience could be further improved by seeing the actual default value instead of the empty cell.

As an intermediate step, there would be user value in seeing "[default]" instead of the blank cell (or what used to be "[null]").

Thanks,
George and Matt



On Sat, Apr 1, 2017 at 7:45 AM, Surinder Kumar <surinder.kumar@enterprisedb.com> wrote:
Hi

Issues fixed:

1. If a column is defined with a default modifier, there is now way to insert the row with those defaults.
The column will be left blank and it will take default value automatically.

2. If a column has a not-null constraint then an error is returned and the row is not inserted.
The column will be left blank
​ ​

​The default values for new added rows will be displayed on refresh/execute.

Please find attached patch and review.


Thanks
Surinder


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


pgadmin-hackers by date:

Previous
From: Atira Odhner
Date:
Subject: Re: [patch] Column selection on SQLEditor
Next
From: Atira Odhner
Date:
Subject: Re: [patch] Column selection on SQLEditor