Обсуждение: [pgAdmin III] #266: Unable to backup table when quotation marks used in the name

#266: Unable to backup table when quotation marks used in the name
---------------------+------------------------------------------------------
 Reporter:  maiesky  |       Owner:  dpage  
     Type:  bug      |      Status:  new    
 Priority:  minor    |   Milestone:         
Component:  pgadmin  |     Version:  1.12   
 Keywords:  backup   |    Platform:  windows
---------------------+------------------------------------------------------
 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\""

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/266>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

#266: Unable to backup table when quotation marks used in the name
---------------------+------------------------------------------------------
 Reporter:  maiesky  |       Owner:  gleu    
     Type:  bug      |      Status:  assigned
 Priority:  minor    |   Milestone:          
Component:  pgadmin  |     Version:  1.12    
 Keywords:  backup   |    Platform:  windows 
---------------------+------------------------------------------------------
Changes (by gleu):

  * owner:  dpage => gleu
  * status:  new => assigned


--
Ticket URL: <http://code.pgadmin.org/trac/ticket/266#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

#266: Unable to backup table when quotation marks used in the name
----------------------+-----------------------------------------------------
  Reporter:  maiesky  |       Owner:  gleu  
      Type:  bug      |      Status:  closed
  Priority:  minor    |   Milestone:  1.12.2
 Component:  pgadmin  |     Version:  1.12  
Resolution:  fixed    |    Keywords:  backup
  Platform:  windows  |  
----------------------+-----------------------------------------------------
Changes (by gleu):

  * status:  assigned => closed
  * resolution:  => fixed
  * milestone:  => 1.12.2


--
Ticket URL: <http://code.pgadmin.org/trac/ticket/266#comment:2>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

#266: Unable to backup table when quotation marks used in the name
----------------------+-----------------------------------------------------
  Reporter:  maiesky  |       Owner:  gleu  
      Type:  bug      |      Status:  closed
  Priority:  minor    |   Milestone:  1.12.2
 Component:  pgadmin  |     Version:  1.12  
Resolution:  fixed    |    Keywords:  backup
  Platform:  windows  |  
----------------------+-----------------------------------------------------

Comment(by gleu):

 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.

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/266#comment:3>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III