pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 638 forks source link

Tablespace Field can have default value selected if available (RM #2611) #1309

Closed dpage closed 2 years ago

dpage commented 7 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/2611 Originally created by Surinder Kumar at 2017-07-27 11:48:08 UTC.

Behaviour:

While creating a new database object (For example: Table), the tablespace field do not have any default tablespace selected, even though "default" template is listed in dropdown. It should be selected.

As per my conversation with Ashesh, the field tablespace must have a default value if available in dropdown.

Please refer screenshots.

Dave, your thoughts ?

dpage commented 7 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/2462 Originally created by Surinder Kumar at 2017-07-27 11:47:20 UTC.

https://pgadmin-archive.postgresql.org/redmine/2611/2462-tablespace_by_default_not_selected.png

dpage commented 7 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/2461 Originally created by Surinder Kumar at 2017-07-27 11:47:20 UTC.

https://pgadmin-archive.postgresql.org/redmine/2611/2461-tablespace_available.png

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2611#note-3 Originally created by Dave Page at 2017-07-27 11:54:43 UTC.

This behaviour is intentional. pg_default is the default tablespace at initdb time, but it might not be the default tablespace for a given database or table (though it could still be used).

By leaving the option blank, a table will use the default tablespace for the database, which may or may not be pg_default.

Redmine ticket header update:

Name Old Value New Value
Status changed New Rejected
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2611#note-4 Originally created by Dave Page at 2017-07-27 11:54:50 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Dave Page Surinder Kumar
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2611#note-5 Originally created by Khushboo Vashi at 2017-07-27 11:56:37 UTC.

Reference RM #2069 Please refer the thread https://www.postgresql.org/message-id/flat/CAFOhELf-rP9pfQ8M7hiPPa9GU4AALL1nsRX2jaGZvMZFeGM4Sw%40mail.gmail.com#CAFOhELf-rP9pfQ8M7hiPPa9GU4AALL1nsRX2jaGZvMZFeGM4Sw@mail.gmail.com

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2611#note-6 Originally created by Surinder Kumar at 2017-07-27 12:42:08 UTC.

Thanks Dave and Khushboo.

dpage commented 2 years ago

Issue closed on Redmine.