Akshay Joshi
0d6f07a035
1) Ensure compound triggers should be displayed under Views. Fixes #4638 .
...
2) Ensure Truncate option should be available for Compound Triggers. Fixes #4641 .
2019-08-20 09:39:31 +05:30
Murtuza Zabuawala
3155380621
Fix issue where Deleting N number of rows makes first N number of rows disable. Fixes #3605
2019-08-19 12:12:28 +05:30
Akshay Joshi
24f9f65b1b
Ensure compound triggers for event should be updated properly. Fixes #4635
2019-08-17 15:58:50 +05:30
Murtuza Zabuawala
3f541200d9
Add Reverse Engineered SQL tests for Columns. Fixes #4546
2019-08-16 17:36:13 +05:30
Yosry Muhammad
687204771c
Add support in query history to show internal queries generated by pgAdmin during save data operations. Fixes #4612
2019-08-16 17:17:12 +05:30
Akshay Joshi
35bbee3023
Fix generation of reverse engineered SQL for Rules. Fixes #4586
2019-08-12 14:27:02 +05:30
Yosry Muhammad
b618dfe286
Fix double click issue to expand the contents of a cell if the resultset was not editable. Fixes #4585
2019-08-09 11:45:05 +05:30
Aditya Toshniwal
1281f5cd6c
Fix console error when changing kind(SQL/BATCH) for pgAgent job step. Fixes #4582
2019-08-08 18:43:38 +05:30
Akshay Joshi
350ffcce7c
1) Add support of Compound Triggers for EPAS 12+. Fixes #4144 .
...
2) Ensure enable trigger menu should be visible when trigger is disabled. Fixes #4578 .
2019-08-08 16:59:11 +05:30
Khushboo Vashi
c29275011a
Ensure the comment on a Primary Key constraint can be edited under the Table node. Fixes #4581
2019-08-08 09:52:10 +01:00
Akshay Joshi
7f53e13aa7
Fix generation of reverse engineered SQL for partition table, partitions were shown as a child of indexes. Fixes #4414
2019-08-07 17:49:13 +05:30
Dave Page
3a5464b278
Display the row count in the popup message when counting table rows, not just in the properties list. Fixes #4574
2019-08-07 11:17:57 +01:00
Aditya Toshniwal
9cdb3b40ab
Add Reverse Engineered SQL tests for Trigger Functions. Fixes #4554
...
Fix the reverse engineered SQL for trigger functions with the WINDOW option selected. Fixes #4565
2019-08-06 14:26:11 +01:00
Aditya Toshniwal
6800b1f723
Add an optimisation to the internal code responsible for searching for treeview nodes. Fixes #4570
...
Attached is a tiny but very effective patch to improve the speed of
finding a node using path (used internally).
If you right click or just click on a node, internally the node is
traversed using its path. But currently, it compares with the path of
all the open nodes to find a match.
So if you 1000+ tables and the tables node is open and if you click on
a view, the view path is compared with all the 1000+ tables (and with
any other open nodes above) before arriving to path. You're at bad luck
if you have more open servers above.
Code is changed to check if the path of node to be found starts with the
current node path. If it doesn't match, why bother the children's of
current node.
This change will not show much effect for small data, but it does matter
for large servers.
One more change is to remove unnecessary calls to find node and use the
data available with Main Menu -> Object to enable/disable node context
menu items.
2019-08-06 14:02:57 +01:00
Aditya Toshniwal
db7a2e3023
Add a --modules option to the RE-SQL test suite to allow testing of specific object types. Fixes #4560
2019-08-06 13:43:49 +01:00
Murtuza Zabuawala
ee8fec6d7f
Allow enhanced cookie protection to be disabled for compatibility with dynamically addressed hosting environments. Fixes #4566
2019-08-06 09:21:31 +01:00
Khushboo Vashi
f8afe2ef94
Add Reverse Engineered SQL tests for Exclusion Constraint. Fixes #4555
2019-08-05 16:25:55 +05:30
Aditya Toshniwal
b5c8c85c90
Ensure triggers should be updated properly for EPAS server. Fixes #4559
2019-08-05 12:49:33 +05:30
Aditya Toshniwal
99a8b70e00
Fix some errors thrown on the JS console when dragging text in the Query Tool. Fixes #4552
2019-08-02 11:28:57 +01:00
Yosry Muhammad
0cfd76c279
Fix load on demand in View/Edit data mode. Fixes #4536
2019-08-02 10:39:19 +01:00
Akshay Joshi
537c27a58e
Use the full tab space for CodeMirror instances on dialogues where appropriate. Fixes #4540
2019-08-02 10:25:21 +01:00
Aditya Toshniwal
aab5fadc01
Update wcDocker to allow the browser's context menu to be used except in tab strips and panel headers. Fixes #4229
...
Update wcDocker to prevent window state loading creating blank dialogues. Fixes #4489
2019-08-01 15:36:40 +01:00
Yosry Muhammad
97e39699ea
Ensure the Query Tool doesn't throw an error when viewing the contents of a table with no columns. Fixes #4492
2019-08-01 14:39:02 +01:00
Yosry Muhammad
76e658ee12
Ensure command tags are shown in the messages tab of the Query Tool. Fixes #4520
2019-08-01 14:29:38 +01:00
Yosry Muhammad
7b65507533
Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updateable resultsets. Fixes #4520
2019-08-01 13:59:53 +01:00
Aditya Toshniwal
bcb1392a1a
Ensure type names are properly encoded in the results grid. Fixes #4401
2019-08-01 13:17:00 +01:00
Dave Page
9a8a28e4f9
Allow a banner to be displayed on the login and other related pages showing custom text. Fixes #4549
2019-08-01 11:39:40 +01:00
Akshay Joshi
2ef3080d0e
Add support for generated columns in Postgres 12+. Fixes #4334
...
Ensure columns can be created when they are IDENTITY fields with the CYCLE option enabled. Fixes #4496
Ensure purely numeric comments can be saved on new columns. Fixed #4497
2019-07-25 16:38:26 +01:00
Daniel Gustafsson
5b322d94e8
Fix generation of reverse engineered SQL for tables with Greenplum 5.x. Fixes #4179
2019-07-25 16:16:44 +01:00
Khushboo Vashi
adb5cd34bf
Add support for planner support functions in PostgreSQL 12+ functions. Fixes #4333
2019-07-25 16:09:37 +01:00
Murtuza Zabuawala
108af5c10b
Fix accessibility issue for Datetime cell in backgrid. Fixes #4508
2019-07-25 17:54:24 +05:30
Ganesh Jaybhay
136bb412a1
1) Fix accessibility issue for checkbox in IE11. Fixes #4490
...
2) Fix adjacent switch cell focus issue in backgrid for IE.
2019-07-25 17:23:56 +05:30
