Re: [BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale

2006-06-15 Thread Volkan YAZICI
On Jun 14 05:00, Bruce Momjian wrote: > Did we make any progress on this? If so, I can't find it. I've made some tests for upper(), lower(), ILIKE and ~* using cvs tip. Below are the details: Cluster Locale | client_encoding | upper() | lower() | ILIKE | ~* -+-+

Re: [BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale

2006-06-15 Thread Tom Lane
Volkan YAZICI <[EMAIL PROTECTED]> writes: > Also, if you'd wish, I can prepare an ad-hoc regression tests patch > for LATIN5 and UTF-8 support of Turkish characters. We know it's broken. What's needed is a patch. regards, tom lane ---(end of broad

Re: [BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale

2006-06-15 Thread Volkan YAZICI
On Jun 15 09:33, Tom Lane wrote: > Volkan YAZICI <[EMAIL PROTECTED]> writes: > > Also, if you'd wish, I can prepare an ad-hoc regression tests patch > > for LATIN5 and UTF-8 support of Turkish characters. > > We know it's broken. What's needed is a patch. I couldn't understand why you're so aggr

[BUGS] BUG #2480: Installation Error of RMP for RHEL4

2006-06-15 Thread Tetsuo Sakata
The following bug has been logged online: Bug reference: 2480 Logged by: Tetsuo Sakata Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: RedHat AS4 Description:Installation Error of RMP for RHEL4 Details: Hi, My name is Tetsuo Sakata. I f

[BUGS] BUG #2482: Wrong result in timestamp_in, timestamptz_in, date_in

2006-06-15 Thread Alexander Galler
The following bug has been logged online: Bug reference: 2482 Logged by: Alexander Galler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Windows XP Description:Wrong result in timestamp_in, timestamptz_in, date_in Details: SET SESSION D

[BUGS] BUG #2481: select from table's join with geometries doesn't go

2006-06-15 Thread Emilia Venturato
The following bug has been logged online: Bug reference: 2481 Logged by: Emilia Venturato Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Debian etch Description:select from table's join with geometries doesn't go Details: --I have data

Re: [BUGS] Compile Errors, 8.1.4 On Solaris 8 x86

2006-06-15 Thread Guy
Is there any particular file you'd care to see? Thanks, Guy -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 5:57 PM To: [EMAIL PROTECTED] Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] Compile Errors, 8.1.4 On Solaris 8 x86 "Guy" <[EMAIL PROT

[BUGS] Unable to set priveleges of user

2006-06-15 Thread Garima Bajpai
We actually want to access database of postgresql through a java program.How do we make the user in postgresql with a encrypted password and with proper priveleges.Please provide the exact syntax for that. ---(end of broadcast)--- TIP 2: Don't 'kill

Re: [BUGS] BUG #2481: select from table's join with geometries doesn't go

2006-06-15 Thread Tom Lane
"Emilia Venturato" <[EMAIL PROTECTED]> writes: > Postgis developper said it could be a postgresql bug. Or it could be a postgis bug. Without a test case we can use to reproduce the problem, it's all speculation. Please send a complete, self-contained test case... regards

Re: [BUGS] BUG #2482: Wrong result in timestamp_in, timestamptz_in, date_in

2006-06-15 Thread Tom Lane
"Alexander Galler" <[EMAIL PROTECTED]> writes: > select '20.01.01 BC'::timestamp; > Result: > "2020-01-01 00:00:00 BC" > I want "20-01-01 00:00:00 BC" You can write select '0020.01.01 BC'::timestamp; I agree it seems like a bug that the 'yy'->'20yy' conversion is applied to BC dates. The code

Re: [BUGS] BUG #2481: select from table's join with geometries doesn't go

2006-06-15 Thread Michael Fuhr
On Thu, Jun 15, 2006 at 11:48:37PM -0400, Tom Lane wrote: > "Emilia Venturato" <[EMAIL PROTECTED]> writes: > > Postgis developper said it could be a postgresql bug. > > Or it could be a postgis bug. Without a test case we can use to > reproduce the problem, it's all speculation. Please send a co

Re: [BUGS] BUG #2480: Installation Error of RMP for RHEL4

2006-06-15 Thread Devrim GUNDUZ
Hi, On Thu, 2006-06-15 at 07:11 +, Tetsuo Sakata wrote: > I found an error when I tried to install an RPM > postgresql-docs-8.1.4-1PGDG.i686.rpm which was downloaded via > http://www.postgresql.org/ftp/binary/v8.1.4/linux/rpms/redhat/rhel-as-4/. > > I typed an rpm command to see the error mes