Re: [pgadmin-hackers] Degrade(character conversion problem) pga3?

2003-10-08 Thread Hiroshi Saito 
Hi Andreas.

It is a little strange...

pgSet *pgConn::ExecuteSet(const wxString sql)
{
// Execute the query and get the status.
PGresult *qryRes;
wxLogSql(wxT(Set query (%s:%d): %s), this-GetHost().c_str(), this-GetPort(), 
sql.c_str());
qryRes = PQexec(conn, sql.mb_str(wxConvUTF8));

When this conv is made wxConvUTF8, a problem doesn't come out.
why??
It is ignored though this connection thread has already been set up.
Does it know anything though it tries to go on?
Logging  is sent by separate mail.

regards,
Hiroshi Saito

From: Andreas Pflug [EMAIL PROTECTED]
 Hiroshi Saito wrote:
 
 Hi Andreas.
 
 I have a problem.
 It is a happening within this week.
 
 See below.
 http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg
 http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg
 
 Tonight, let me know it if you know something though it will be examined.
 Thank you.
 
 
 There's obviously something wrong... How about the error log?


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] Degrade(character conversion problem) pga3?

2003-10-08 Thread Andreas Pflug 
Hiroshi Saito wrote:

Hi Andreas.

I have a problem.
It is a happening within this week.
See below.
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg
http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg
Tonight, let me know it if you know something though it will be examined.
Thank you.
 

Hi Hiroshi,

AFAICS this is a backend problem. I re-posted this on pgsql-bugs too, 
the attached log is your's, reduced to the relevant part. Please check 
the query in the Query Tool, try to modify the column name which seems 
to provoke this problem.
Maybe you found a bug in the EUC_JP - UTF-8 conversion.

Regards,
Andreas

2003-10-09 01:25:27 QUERY  : Set query (128.77.50.202:5432): SELECT null_frac AS Null 
Fraction, avg_width AS Average Width, n_distinct AS Distinct Values, 
most_common_vals AS Most Common Values, most_common_freqs AS Most Common 
Frequencies, histogram_bounds AS Histogram Bounds, correlation AS Correlation
  FROM pg_stats
 WHERE schemaname = 'public'
   AND tablename = 'stimsdb'
   AND attname = '要素識別番'
2003-10-09 01:25:27 QUERY  : WARNING:  UtfToLocal: could not convert UTF-8 (0xca94). 
Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  UtfToLocal: could not convert UTF-8 (0xd427). 
Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9776) EUC_JP 
to UTF-8. Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9166) EUC_JP 
to UTF-8. Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9522) EUC_JP 
to UTF-8. Ignored
2003-10-09 01:25:27 ERROR  : ERROR:  parser: unterminated quoted string at or near 
'・ｯ at character 351



---(end of broadcast)---
TIP 8: explain analyze is your friend