Re: [BUGS] BUG #3601: When we try to connect to postgres ti shows Unicode converter buffer overflow error.

2007-09-06 Thread Hiroshi Saito
Hi. Umm... If possible, please set up Debug by odbc.ini, and send me /tmp/mylog_xxx999.log. Regards, Hiroshi Saito From: "Unicode converter buffer overflow in psqlodbc driver" <[EMAIL PROTECTED]> The following bug has been logged online: Bug reference: 3601 Logged by: Unico

Re: [BUGS] BUG #3604: lo_import does not work with filenames with accents

2007-09-06 Thread Hiroshi Saito
Hi. I think that the problem's clarifying path and encoding need to be directed. Please see, http://winpg.jp/~saito/pg_work/LageObject_psql.png Sorry it is japanese:-) Regards, Hiroshi Saito - Original Message - From: "Pascal Van De Gucht" <[EMAIL PROTECTED]> The following bug has

Re: [BUGS] hu_HU.UTF8 case insensitive search fail to return values

2007-09-06 Thread Tom Lane
=?UTF-8?B?IkzDoXN6bMOzLVLDs2JlcnQsIEFsYmVydCI=?= <[EMAIL PROTECTED]> writes: > [ ILIKE fails to match case-insensitively in 8.1.2 ] The ILIKE code doesn't work well at all in multibyte encodings in 8.1 and before. You should get reasonable results in one of the LATINn encodings (and a matching lo

Re: [BUGS] create index concurrently blocks on transactions in other databases

2007-09-06 Thread Simon Riggs
On Thu, 2007-09-06 at 12:43 +0200, hubert depesz lubaczewski wrote: > steps to reproduce: > session1: connect using user1 to database1. > session2: connect using user2 to database2. > session1: create table x ( y int); > session2: begin; > session1: create index concurrently q on x(y); > it hangs.

Re: [BUGS] create index concurrently blocks on transactions in other databases

2007-09-06 Thread Simon Riggs
On Thu, 2007-09-06 at 15:55 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > On Thu, 2007-09-06 at 12:43 +0200, hubert depesz lubaczewski wrote: > >> i dont really see why this would be neccessary - i understand that we > >> need to wait for transactions in the same db, but wait

Re: [BUGS] create index concurrently blocks on transactions in other databases

2007-09-06 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Thu, 2007-09-06 at 12:43 +0200, hubert depesz lubaczewski wrote: >> i dont really see why this would be neccessary - i understand that we >> need to wait for transactions in the same db, but waiting for >> transaction in another database? > Manual says

[BUGS] BUG #3604: lo_import does not work with filenames with accents

2007-09-06 Thread Pascal Van De Gucht
The following bug has been logged online: Bug reference: 3604 Logged by: Pascal Van De Gucht Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows 2003 Description:lo_import does not work with filenames with accents Details: When I use t

Re: [BUGS] create index concurrently blocks on transactions in other databases

2007-09-06 Thread Simon Riggs
On Thu, 2007-09-06 at 12:43 +0200, hubert depesz lubaczewski wrote: > steps to reproduce: > session1: connect using user1 to database1. > session2: connect using user2 to database2. > session1: create table x ( y int); > session2: begin; > session1: create index concurrently q on x(y); > it hangs.

Re: [BUGS] BUG #3598: Strange behaviour of character columns in select with views

2007-09-06 Thread Tom Lane
"Luiz K. Matsumura" <[EMAIL PROTECTED]> writes: > Description:Strange behaviour of character columns in select with > views I've applied a fix for this in CVS HEAD (8.3-to-be), but it seems impractical to fix it in 8.2 (or 8.1 which also has the issue). The problem is that when "null::char

[BUGS] BUG #3603: ADO PostgreSQL OLE DB Provider ERROR

2007-09-06 Thread Jayaram R
The following bug has been logged online: Bug reference: 3603 Logged by: Jayaram R Email address: [EMAIL PROTECTED] PostgreSQL version: 1.6.3 Operating system: Windows ME Description:ADO PostgreSQL OLE DB Provider ERROR Details: i am using postgresSql in Windows ME.

[BUGS] BUG #3602: DO PostgreSQL OLE DB Provider

2007-09-06 Thread Jayaram R
The following bug has been logged online: Bug reference: 3602 Logged by: Jayaram R Email address: [EMAIL PROTECTED] PostgreSQL version: 1.6.3 Operating system: Windows Me Description:DO PostgreSQL OLE DB Provider Details: I am using postgresSql in Windows. And it is

[BUGS] hu_HU.UTF8 case insensitive search fail to return values

2007-09-06 Thread László-Róbert, Albert
Hi I have a problem related to the encoding. Maybe this is not the right place to ask for help, in this case please tell me where to ask for help. database version: PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13) The problem is the following: I have

[BUGS] create index concurrently blocks on transactions in other databases

2007-09-06 Thread hubert depesz lubaczewski
steps to reproduce: session1: connect using user1 to database1. session2: connect using user2 to database2. session1: create table x ( y int); session2: begin; session1: create index concurrently q on x(y); it hangs. session2: rollback/commit; session1: finishes. i dont really see why this would b

[BUGS] BUG #3601: When we try to connect to postgres ti shows Unicode converter buffer overflow error.

2007-09-06 Thread Unicode converter buffer overflow in psqlodbc driver
The following bug has been logged online: Bug reference: 3601 Logged by: Unicode converter buffer overflow in psqlodbc driver Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Solaris Sparc V9 32bit Description:When we try to connect to post

Re: [BUGS] [pgadmin-hackers] public.pg_class isn't a catalog table

2007-09-06 Thread Dave Page
Decibel! wrote: > Version 1.6.3; if you have a table in public called pg_class and try to > drop it, pgAdmin gives an error: > > ERROR: permission denied: "pg_class" is a system catalog > > The drop does work correctly from psql... I'm sure you (Jim) have seen the reasons why this happens pgAdmi