Re: [BUGS] UTF-8 encoding failure

2010-03-25 Thread Takahiro Itagaki
"Hiroshi Saito" wrote: > Probably it is not a bug. > > Testing with encoding UTF-8: > NOTICE: CREATE TABLE will create implicit sequence "蝗帛ョ誉gid_seq" for serial > column "蝗帛ョ・gid" > Testing with encoding SJIS: > NOTICE: CREATE TABLE will create implicit sequence "四宗_gid_seq" for serial > colu

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

2010-03-25 Thread Tom Lane
"Timothy Seever" writes: > Adding a column to an inherited table in-place works as expected with the > combined table/etc. However on dump/reload the physical order changes, so > any? predefined select from a setof function pulling from the combined table > will result in a mismatch. Yup. This

Re: [BUGS] BUG #5390: pg_dump does not check/include additional schema dependencies when writing schema/search path

2010-03-25 Thread Tom Lane
"Timothy Seever" writes: > 1. Create schema A > 2. Create schema B > 3. Create function in schema A which depends on something in schema B > without specifying it (i.e. the connected user has B included in the > search_path, and the function A.xyz() has something like val := yyz(); > where yyz

[BUGS] BUG #5391: coding issues displaying server messages

2010-03-25 Thread Victor Vargas
The following bug has been logged online: Bug reference: 5391 Logged by: Victor Vargas Email address: kamu...@gmail.com PostgreSQL version: 8.4 Operating system: Ubuntu Lucid Description:coding issues displaying server messages Details: This report was originally fi

[BUGS] BUG #5388: bortdagos

2010-03-25 Thread bortdagos
The following bug has been logged online: Bug reference: 5388 Logged by: bortdagos Email address: bortda...@ucla.edu PostgreSQL version: bortdagos Operating system: bortdagos Description:bortdagos Details: 1980 anthropogenic google environmental depend trends geoeng

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

2010-03-25 Thread Timothy Seever
The following bug has been logged online: Bug reference: 5389 Logged by: Timothy Seever Email address: tim.see...@gmail.com PostgreSQL version: 8.3.5, others Operating system: Linux Description:Column order on dump/reload broken from defined setof function Details:

[BUGS] BUG #5390: pg_dump does not check/include additional schema dependencies when writing schema/search path

2010-03-25 Thread Timothy Seever
The following bug has been logged online: Bug reference: 5390 Logged by: Timothy Seever Email address: tim.see...@gmail.com PostgreSQL version: 8.3.5, others Operating system: Linux/RHEL5.2 Description:pg_dump does not check/include additional schema dependencies when

Re: [BUGS] Question about installation in 2003 server

2010-03-25 Thread Jaime Casanova
if you prefer spanish (and because of your english is maybe a good idea maybe you want to write to pgsql-es-ay...@postgresql.org ;) On Thu, Mar 25, 2010 at 10:51 AM, ALCALDIA DE INFANTE ALCALDIA DE INFANTE wrote: > Hello, i´m try to install postgresql 8.10 in a server with Windows 2003 > server s

[BUGS] Question about installation in 2003 server

2010-03-25 Thread ALCALDIA DE INFANTE ALCALDIA DE INFANTE
Hello, i´m try to install postgresql 8.10 in a server with Windows 2003 server standart edition. I install XAMPP and postgresql 8.10 but the sistem don´t work. All components are tested, i can open a database with postgre but in the sistem, the paga that do it dont work. What do it?, are there an

Re: [BUGS] GIN overlap vs empty arrays

2010-03-25 Thread Jeff
On Mar 25, 2010, at 11:44 AM, Tom Lane wrote: Hmm, that case is supposed to work, in 8.3 and later ... but it doesn't because of a stupid typo in contrib/intarray. This works. - thanks! -- Jeff Trout http://www.stuarthamm.net/ http://www.dellsmartexitin.com/ -- Sent via pgsql-bugs m

Re: [BUGS] UTF-8 encoding failure

2010-03-25 Thread Hiroshi Saito
Hi Martin-san. Probably it is not a bug. Does this help you? Please see. C:\home\HIROSHI>cl TestPostgreSQLJapanese.cpp -I"C:\Program Files\PostgreSQL\8.4 \include" "C:\Program Files\PostgreSQL\8.4\lib\libpq.lib" Microsoft(R) 32-bit C/C++ Optimizing Compiler Version 15.00.30729.01 for 80x86 Copyr

Re: [BUGS] GIN overlap vs empty arrays

2010-03-25 Thread Tom Lane
Jeff writes: > Ran into this and I'm trying to decide if this is functioning as > designed or if this is a bug that should be fixed: (PG 8.4.2) > create table gintest > ( > idList int[], > foo text > ); > create index gintest_gin_idx on gintest using gin(idList gin__int_ops); > in

[BUGS] GIN overlap vs empty arrays

2010-03-25 Thread Jeff
Ran into this and I'm trying to decide if this is functioning as designed or if this is a bug that should be fixed: (PG 8.4.2) create table gintest ( idList int[], foo text ); create index gintest_gin_idx on gintest using gin(idList gin__int_ops); insert into gintest(idlist, f

[BUGS] UTF-8 encoding failure

2010-03-25 Thread Martin Schäfer
Hi, Is this the right place to report bugs? The attached program creates a table with Japanese column names. When the column names are retrieved in a query using PQfname, and invalid string is returned. The invalid column names can also be seen in PGAdmin III. This only seems to happen with on