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

BUG:pgAdmin4 doesn't handle \'s in data fields correctly. (RM #3551) #2000

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3551 Originally created by richard coleman at 2018-08-06 14:16:36 UTC.

It appears that pgAdmin4 has trouble properly displaying data that has \'s in it.

For example (using a var char200 field):

in pSQL(and anywhere else) the field 'filelocation' has this value:

"\starswirl\Documents\2017\12\19\AD93E646-E5FE-11E7-85AE-EB2E217F96F0.tif"

But in pgAdmin4 it's this:

"\starswirl\Documents 7 9\AD93E646-E5FE-11E7-85AE-EB2E217F96F0.tif"

This is the create script for the database in question:

CREATE DATABASE tms_production WITH OWNER = local_user ENCODING = 'SQL_ASCII' LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252' TABLESPACE = pg_default CONNECTION LIMIT = -1;

ALTER DATABASE tms_production SET default_transaction_read_only TO off; ALTER DATABASE tms_production SET client_encoding TO sql_ascii; ALTER DATABASE tms_production SET standard_conforming_strings TO off;

pgAdmin4 v3.1

Google chrome v68.0.3440.84 (64-bit)

Windows Server 2016 x 64

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-1 Originally created by Akshay Joshi at 2018-08-10 10:38:29 UTC.

Fahar,

Can you please verify it.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Fahar Abbas
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-2 Originally created by richard coleman at 2018-08-10 13:22:48 UTC.

steps to replicate:

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-3 Originally created by richard coleman at 2018-09-11 13:52:21 UTC.

Any progress? This is really impacting my ability to use pgAdmin.

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-4 Originally created by Fahar Abbas at 2018-09-11 14:13:03 UTC.

Hi Richard,

Can you please share sql queries for table and psql set values?

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Fahar Abbas richard coleman
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-5 Originally created by Fahar Abbas at 2018-09-11 16:09:37 UTC.

I am able to reproduce the issue:

Here is the output of psql:

tms_production=# SELECT * from public.test; test_field

-- \\starswirl\Documents\2017\12\19\AD93E646-E5FE-11E7-85AE-EB2E217F96F0.tif

While output is different through view data through query tool window:

\starswirl\Documents\2017\12\19\AD93E646-E5FE-11E7-85AE-EB2E217F96F0.tif

The output of select statement is different for psql and through query tool.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed richard coleman
Sprint changed Ready
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-6 Originally created by Dave Page at 2018-09-12 08:24:58 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.4
Sprint changed Ready EDB Sprint 23
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-7 Originally created by Akshay Joshi at 2018-09-14 04:51:57 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Akshay Joshi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-8 Originally created by Akshay Joshi at 2018-09-14 11:49:26 UTC.

Patch sent: https://www.postgresql.org/message-id/CANxoLDeRod2vdkV-5-4uJcgbWBFgKRQ1uvq8zqRqC03y4xWZtA@mail.gmail.com

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-9 Originally created by Akshay Joshi at 2018-09-25 14:34:38 UTC.

Applied in changeset commit:15fe26a7106610b710f3de5b604cd038302c926a.

Redmine ticket header update:

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

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3551#note-10 Originally created by Fahar Abbas at 2018-10-01 05:50:40 UTC.

https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2018-09-26/

Tested on Windows 64 and MAC OS X.

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.