search

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.53k stars 656 forks source link

"Download as .csv" F8 does NOT work when one of joined files is a TEMPORARY file (RM #3673) #2096

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3673 Originally created by Hal McKinney at 2018-09-25 19:53:44 UTC.

"Download as .csv" button (F8) outputs error to .csv when one of joined files is a TEMPORARY file however it does work when output to "Data Output" tab on screen.

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-1 Originally created by Hal McKinney at 2018-09-25 20:01:16 UTC.

Steps to recreate:

create a temporary file insert a few records make a select query joining this temporary file to some other table click "Download as .csv" button this will output a .csv with an error

(if instead of "Download as .csv" you press lightning button (Execute) it outputs fine to "Data Output" tab on screen)

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-2 Originally created by Hal McKinney at 2018-09-25 20:07:45 UTC.

Also, it outputs fine to .csv when you CREATE TEMP TABLE etc. in pgAdmin III, just not pgAdmin 4

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-3 Originally created by Akshay Joshi at 2018-09-28 10:10:31 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-4 Originally created by Akshay Joshi at 2018-09-28 10:10:43 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (duplicates) changed RM #1987
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-5 Originally created by Khushboo Vashi at 2019-01-30 10:42:20 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready EDB Sprint 33
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-6 Originally created by Khushboo Vashi at 2019-01-31 07:05:29 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Khushboo Vashi
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-7 Originally created by Khushboo Vashi at 2019-02-13 04:40:13 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (duplicated) changed RM #3990
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-8 Originally created by Akshay Joshi at 2019-02-13 10:31:41 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 33 EDB Sprint 34
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-9 Originally created by Akshay Joshi at 2019-02-15 10:45:18 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (relates) changed RM #3372
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-10 Originally created by Khushboo Vashi at 2019-02-19 05:41:11 UTC.

Patch sent. https://www.postgresql.org/message-id/CAFOhELeLpXHsOfX95DXPtiiWbVe_adfnpbknv5ELSx1Huzakcw@mail.gmail.com

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-11 Originally created by Khushboo Vashi at 2019-02-20 11:49:50 UTC.

Applied in changeset commit:34045efb38c15ef4ec3d84dbeebb694d78760d00.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-12 Originally created by Dave Page at 2019-02-22 16:27:23 UTC.

Redmine ticket header update:

Name Old Value New Value
Relationship (relates) changed RM #4013
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3673#note-13 Originally created by Fahar Abbas at 2019-02-25 07:43:31 UTC.

This is resolved in latest Build: https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2019-02-25/

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.