[pgadmin-support] pgadmin doesn't show field contents

[kaeptn haddock]

Dear List

We have databases in SQL_ASCII (I know, uft-8 would be better).
In Windows, pgadmin works fine.
In Ubuntu, pgadmin doesn't show field content when fields contain
special characters such aus umlaute.

Is this a bug, and is there a workaround (other than changing the
encoding of the db?)

Many thanks for any help
best regards
pl


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] pgadmin in ubuntu: copy-paste to query window often fails

[kaeptn haddock]

Dear List

This is an ubuntu-specific bug, but I suspect it could be fixed in
pgadmin3. When I try to copy-paste large chunks of sql-code to the query
window, pasting usually fails (query-window stays empty). However,
pasting to the scratch-pad (docket on the right-hand side within the
query window) always works, and from there I can copy-paste the code to
the query field.
Copy-pasting small chunks of code usually seems to work as expected.

Best regards
pl


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Bug/Feature Request: pgAdmin should show "context" part of error message for problems with COPY command

[kaeptn haddock]

When issueing a COPY command like this one


COPY tablename FROM '/var/www/hdberat.tab' WITH NULL AS '';



The error-message in pgadminIII is quite short 

** Error ***
FEHLER: fehlende Daten für Spalte »termin_dauer_eingabe«
SQL state: 22P04
-

(For those who don't understand German: it says: missing data for column
xy). In PHP-pgadmin the errormessage is much more meaningful, because it
adds the CONTEXT-line, where it actually tells me the number of the line
("Zeile") in the source-file, where the error occurred:



FEHLER:  fehlende Daten für Spalte »termin_dauer_eingabe«
CONTEXT:  COPY fm_hdberat, Zeile 10421: »admin1Gründler Pius   
archiviert  "Texteingabe"   "Texteingabe"   "Texteingabe"   "Texteingabe"   
"Textein...«
---

It'd be a big help, if pgadmin was as verbose as php-pgadmin.
Best regards
pl


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support