Re: [BUGS] BUG #2309: Wrong string comparison

2006-03-10 Thread Yury Don
On Friday 10 March 2006 12:36, Volkan YAZICI wrote: > Hi, > > On Mar 09 02:00, Yury Don wrote: > > Looks like string comparison operators ignore spaces isnside of string. > > Because of this sorting on text fields is wrong. > > > > mdb=# select 'a z'::text>'ad'::text; > > ?column? > > -- >

Re: [BUGS] Suse Installations

2006-03-10 Thread j6m
Up to SuSE 9.3, the Postgres versions shipped use version 3 of libpq. Postgres 8.1.x use version 4. Oddly enough, installing Postgres 8.1 works quite well with packages requiring Postgres (e.g. snort, php) if you replace in /usr/lib all libpq version 3 files with links to their version 4 counterpa

Re: [BUGS] BUG #2307: Buckup and sequences in DEFAULT part

2006-03-10 Thread Kamil Giza
OK. You are right. Everything is OK with PostgreSQL. The problem is with ZEOS components for Delphi. Sorry for trouble. regards, Kamil Giza begin:vcard fn:Kamil Giza n:Giza;Kamil org:ZETO Olsztyn;Projektowania i Programowania email;internet:[EMAIL PROTECTED] title;quoted-printable:Kierownik Zesp

Re: [BUGS] BUG #2310: "ALTER TYPE name OWNER TO new_owner" not working

2006-03-10 Thread berndlosert
-Original Message- From: Tom Lane <[EMAIL PROTECTED]> To: eKo1 <[EMAIL PROTECTED]> Cc: pgsql-bugs@postgresql.org; Christopher Kings-Lynne <[EMAIL PROTECTED]> Sent: Thu, 09 Mar 2006 20:10:54 -0500 Subject: Re: [BUGS] BUG #2310: "ALTER TYPE name OWNER TO new_owner" not working I wrote: