Skip site navigation (1) Skip section navigation (2)

Re: contrib/fixchar (Was: Large databases, performance)

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: contrib/fixchar (Was: Large databases, performance)
Date: 2002-10-10 13:49:11
Message-ID: 3DA5D2AF.24682.4EDF20B@localhost (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-performancepgsql-sql
On 10 Oct 2002 at 15:30, Manfred Koizar wrote:

> On Wed, 09 Oct 2002 10:00:03 +0200, I wrote:
> >here is an implementation of a set of user types: char3, char4,
> >char10.
> 
> New version available.  As I don't want to spam the list with various
> versions until I get it right eventually, you can get it from
> http://members.aon.at/pivot/pg/fixchar20021010.tgz if you are
> interested.
> 
> What's new:
> 
> . README updated (per Shridhar's suggestion)
> . doesn't crash on NULL (p. Tom)
> . version-1 calling conventions (p. Tom)
> . isCachable (p. Tom)
> . works for 7.2 (as delivered) and for 7.3 (make for73)
> 
> Shridhar, you were concerned about signed/unsigned chars;  looking at
> the code I can not see how this is a problem.  So no change in this
> regard.

Well, this is not related to postgresql exactly but to summerise the problem, 
with libc patch PHCO_19090 or compatible upwards, on HP-UX11, isspace does not 
work correctly if input value is >127. Can cause lot of problem for an external 
app. It works fine with unsigned char

Does not make a difference from postgrersql point of view but would break non-
english locale if they want to use this fix under some situation.

But I agree, unless somebody reports it, no point fixing it and we know the fix 
anyway..


Bye
 Shridhar

--
Live long and prosper.		-- Spock, "Amok Time", stardate 3372.7


In response to

pgsql-performance by date

Next:From: Adam WitneyDate: 2002-10-10 15:41:43
Subject: Info on explain output
Previous:From: Manfred KoizarDate: 2002-10-10 13:30:31
Subject: contrib/fixchar (Was: Large databases, performance)

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-10-10 14:04:20
Subject: Open items
Previous:From: Greg CopelandDate: 2002-10-10 13:44:40
Subject: Re: Bison 1.50 was released

pgsql-sql by date

Next:From: John DuffyDate: 2002-10-10 15:17:40
Subject: NOTICE: generated by sequence nextval()
Previous:From: Manfred KoizarDate: 2002-10-10 13:30:31
Subject: contrib/fixchar (Was: Large databases, performance)

pgsql-general by date

Next:From: Adam WitneyDate: 2002-10-10 13:49:26
Subject: Re: pg_restore error
Previous:From: Manfred KoizarDate: 2002-10-10 13:30:31
Subject: contrib/fixchar (Was: Large databases, performance)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group