73 results found
-
More detailed insert/update/delete errors
For example: In pgAdmin I ran an insert statement and was told exactly what value was causing the foreign key constrain error. In dbForge I'm not told what value is causing the error.
pgAdmin Error:
ERROR: insert or update on table "return" violates foreign key constraint "FKreturncategorycategoryid"
DETAIL: Key (category_id)=(Lodging) is not present in table "category".
SQL state: 23503dbForge Error:
1 insert or update on table "return" violates foreign key constraint "FKreturncategorycategoryid" SQL.sql 1 13 votes -
Copy or cut line in one keystroke like in Visual Studio
"if you just want to cut or copy one line, you don't have to select the line. All you have to do is put your cursor on the line and press Control+X or Control+C. Visual Studio will cut or copy the whole line, including the carriage return."
https://visualstudiomagazine.com/Blogs/Tool-Tracker/2015/02/Cut-Copy-One-Keystroke.aspx
2 votes -
Make dbForge work on monitor> 100Hz
It flickers above it. 100Hz and below seems to be ok
1 vote -
Session browser
A screen similar to Toad or DBeaver which show active sessions, allows grouping, sorting, filtering. Provides runtime information from pgstatactivity. Allows auto-refresh. For example:
postgres 9119 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 (null) (null) active
tagmanager 13679 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
tagmanager 13316 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
rdsadmin 26264 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 23469 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 23470 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
tagmanager 13317 xxxxx 2020-10-05 15:52:34.000000 2020-10-05 15:52:34.000000 Client ClientRead idle
maxnote 24322 xxxxx 2020-10-05…3 votes -
Menu "Set Value to" with Boolean
Hi! Would be great for multiple selection.
1 vote -
Add Roles to the Database Explorer
Only Database objects are display in the DE, Roles would be handy.
2 votes -
Filter for schemas and tables (using names and wildcards) during Schema Comparing
Product: dbForge Schema Compare for PostgreSQL
Product Version: 1.1.1
Schema filtering is important, because some schemas include temporary and internal data. For example in many extension (timescaledb, pg_partman).
Some time developer want to include these schema, some time does not.1 vote -
one instance
Hallo,
es wäre super, wenn man DB-Forge optional nur einmal starten könnte. Leider habe ich oft mehrere Instanzen gestartet. Die geöffneten/gespeicherten Tabs sind dann unterschiedlich.
1 vote -
Permit the SQL results as text vs grid to be set both before and after a query
Permit the SQL results as text vs grid to be set both before and after a query. Sometimes once a query is run, it's useful to be able to convert it to text without running the query again.
1 vote -
Query execution on a timed interval
The ability to execute a query repeatedly base on a time interval - a refresh rate if you will.
1 vote -
Fix correspondence of sort order for stacked bar chart and its legend
Check the correspondence between a pivot table / stacked bar chart's legend sort order and the sort order of the bar stack. Its wrong- read the bar from base to top and the legend reads from top to bottom, they should be inverted to be WYSIWYG.
1 vote -
to support selection of multiple tables or sequences for deleting a group of them.
This was the reason why I downloaded the trial since pgAdmin did not allow that either.
1 vote -
1 vote
-
View RAISE NOTICE results
According to the PostgreSQL documentation, the RAISE statement can be used to report messages and raise errors. I would like to be able to see the results of a RAISE NOTICE statement in the OUTPUT panel in dbForge.
It will be a great help in the debugging of functions and complex code.
15 votes -
Query Builder
A Query Builder is missing and it would be really useful for sql sheets.
4 votes -
Command execution keyboard shortcuts
Execute selected or current sql block with CTRL-Enter or CTRL-E.
2 votes -
edit table
edit table like dbForge Studio for mysql
12 votes -
Add Format SQL option
Is there a "format SQL" option?
8 votes -
Add a possibility to script a table / view / materialized view
Is there a way to script a table / view / materialized view?
9 votes -
Change column type on Import
When importing data from CSV Studio detects column types, but no way to change mapping. For example, int isn't enough, I'd like to change type to bigint.
5 votes
- Don't see your idea?