search

pgadmin-org / pgadmin3

Archive of the pgAdmin III project
https://www.pgadmin.org/
Other
178 stars 82 forks source link

Unable to backup table when quotation marks used in the name (RM #510) #280

Closed dpage closed 2 years ago

dpage commented 13 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/510 Originally created by Anonymous at 2010-10-23 10:11:01 UTC.

I am running pgAdmim 1.12 on [[WinXP]] SP3 but this issue was observed in previous releases also. When trying to do a backup of a table which has quotation marks in its name or in schema name then getting error:

(example1 quotation marks in schema name)

C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host XXX.com --port 5432 --username XXXX --format plain --data-only --verbose --file "C:\moja.sql" --table "TT_settings".moja "TT_dudulu" pg_dump: No matching tables were found pg_dump: *** aborted because of error

Process returned exit code 1.

or (example2 quotation marks in table name)

C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host XXX.com --port 5432 --username XXXX --format plain --data-only --verbose --file "C:\cwtest2.sql" --table n_dms."CFX" "TT_dudulu" pg_dump: No matching tables were found pg_dump: *** aborted because of error

Process returned exit code 1.

To bypass this problem I can manually run script with added surrounding quotation marks around the access path and escaping chars included in the name:

for the first example: "\"TT_settings\".moja"

for second example: "n_dms.\"CFX\""

dpage commented 13 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/416 Originally created by Guillaume Lelarge at 2010-11-17 22:48:21 UTC.

https://pgadmin-archive.postgresql.org/redmine/510/416-ticket266.patch

Description: v1 patch

dpage commented 13 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/510#note-2 Originally created by Guillaume Lelarge at 2010-11-17 22:48:34 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
dpage commented 13 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/510#note-3 Originally created by Guillaume Lelarge at 2010-11-23 11:11:45 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress Resolved
Resolution changed fixed
dpage commented 13 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/510#note-4 Originally created by Guillaume Lelarge at 2010-11-23 11:23:19 UTC.

Fixed in http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commit;h=09a197988db29dd79bca79b8b0c184050c06accc and http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commit;h=119cc74d133533ece4b666164230ecf1adb450bc.

dpage commented 2 years ago

Issue closed on Redmine.