Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
Unfortunately there are encoding problems on my machine. I'm getting this output: Testing with encoding UTF-8: PQfname(pResult, 4) returned incorrect field name. PQfname(pResult, 5) returned incorrect field name. PQfname(pResult, 6) returned incorrect field name. Testing with encoding SJIS: Quer

Re: [BUGS] BUG #5389: Column order on dump/reload broken from defined setof function

2010-03-26 Thread Dimitri Fontaine
"Timothy Seever" writes: > CREATE FUNCTION testfunc() RETURNS setof tablec AS $BODY$ SELECT * FROM > tablec; $BODY$ LANGUAGE 'sql' STABLE; Common wisdom saith to never ever use "SELECT *" in your code. You just found out a reason why. Regards, -- dim -- Sent via pgsql-bugs mailing list (pgsql

[BUGS] BUG #5392: Query Optimization

2010-03-26 Thread sachin
The following bug has been logged online: Bug reference: 5392 Logged by: sachin Email address: sachin.des...@gmail.com PostgreSQL version: PostgreSQL8.4.0 Operating system: 64 red hat - linux Description:Query Optimization Details: Hi, I am facing problem in optimi

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Hiroshi Saito
Hi Martin-san. Umm, I sent what corrected some of your TestPostgreSQLJapanese.cpp. http://archives.postgresql.org/pgsql-bugs/2010-03/msg00188.php Did you use it? Regards, Hiroshi Saito - Original Message - From: "Martin Schäfer" Unfortunately there are encoding problems on my mach

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
Hello Hiroshi-san, The only differences I found between my source file and yours are the file encoding (Unicode/SJIS), different #include-s and different parameters to PQsetdblogin. I had to undo the last two changes to compile and run on my machine. And the changed file encoding made no differ

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Hiroshi Saito
Hi. Ahh ok, Would you try this. C:\home\HIROSHI>"C:\Program Files\PostgreSQL\8.4\bin\psql.exe" -f SJIS_TEST.SQL -p5433 postgres postgres データベ ース一覧 \x96\xBC\x91O | \x8F\x8A\x97L\x8E | \x83G\x83\x93\x83R\x81[\x83f\x83B\x83\x93\

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
Hi, This worked fine, as you can see in the attached result. However, I can see that my database has a different locale (English_United Kingdom.1252) from yours (C). Can this cause the problem? Regards, Martin > -Original Message- > From: Hiroshi Saito [mailto:z-sa...@guitar.ocn.ne.j

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Hiroshi Saito
Hi. I think that the locale is not desirable. However, It is not related to this problem. Can you test without editing this program? http://winpg.jp/~saito/PGSQL_SJIS/ I think that it passes. Regards, Hiroshi Saito - Original Message - From: "Martin Schäfer" To: "'Hiroshi Saito'" ; "

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Martin Schäfer
Can you copy libpq.dll to the same destination please? I linked libpq as a static library into my project. Martin > -Original Message- > From: Hiroshi Saito [mailto:z-sa...@guitar.ocn.ne.jp] > Sent: Friday, March 26, 2010 4:35 PM > To: Martin Schäfer; 'Takahiro Itagaki' > Cc: pgsql-bug

Re: [BUGS] UTF-8 encoding failure

2010-03-26 Thread Hiroshi Saito
Hi. Eh, Have I missed something?_? set Path=%Path%;C:\Program Files\PostgreSQL\8.4\bin; It is not this. Regards, Hiroshi Saito - Original Message - From: "Martin Schäfer" To: "'Hiroshi Saito'" ; "'Takahiro Itagaki'" Cc: Sent: Saturday, March 27, 2010 12:46 AM Subject: Re: [BUGS] U

[BUGS] BUG #5393: Installer sets superuser password if passwords don't match

2010-03-26 Thread Joshua Tolley
I accidentally rejected this message while moderating -bugs, so I'm forwarding it to the list to atone for myself. Apologies to all involved... - Forwarded message from pgsql-bugs-ow...@postgresql.org - Content-Description: Original message From: Rens Admiraal Date: Fri, 26 Mar 2010 20:0