On Fri, 27 Feb 1998, Thomas G. Lockhart wrote:
> The test is to start up psql and try
> select '$1.00'::money;
> which fails. I believe this works on other platforms, and I distinctly recall getting
That is true, it fails. However, if you could point to me where exactly
something is going wrong I could try and have a look at it. I don't really
feel like digging into postgresql source to see which functions are at
fault. A small C test program will be nice.
> 2) pre-glibc2.0.7 has rounding bugs which cause odd results in some date/time
> routines. The test is to try
> select '4 hours'::timespan;
Yepp, it fails.
> which will return '3 hours 59 mins 60 secs' on a machine with problems. We have
> reports from someone running Debian that glibc2.0.7-pre1 (?) fixes the problem. Any
> idea on when glibc2.0.7 might be available?
the 2.0.7pre1 is available. However, if the debian folks fixed this
problem, I can tell you that their patch didn't made it so far in the
glibc source tree. Again, a small C test program that shows what exactly
fails will be nice.
> 3) the ownership of the data area is incorrect as shipped (I assume this is
> rpm-specific). On my RH5.0 machine, which is a VAResearch system with Linux/Postgres
> preinstalled, the data area was owned by root, and the backend cannot start up. If
> the ownership is changed to the postgres account then the backend starts.
I think that is a VAResearch thing. The package definitely installs the
/var/lib/pgsql directory owned by postgres account.
> Thanks for building a new RPM. I'll try it at work on my production machine tomorrow.
> Also, we will have new documentation in v6.3, including html and hardcopy, and you
> will want to repackage that too. Look in the doc directory (in a day or two; I'm
> still building the docs and haven't committed anything yet to the source tree).
I am still waiting to find out a way to get cvs read-only access to the
postgres sources. Downloading a full snapshot evey other day is not my
favorite game. Especially when a nice shell script can take care of
automatically generating new rpms every day... :-)
Cristian Gafton -- gafton(at)redhat(dot)com -- Red Hat Software, Inc.
UNIX is user friendly. It's just selective about who its friends are.
In response to
pgsql-hackers by date
|Next:||From: Herouth Maoz||Date: 1998-03-01 10:25:30|
|Subject: Re: [QUESTIONS] Re: [HACKERS] Is "CREATE DOMAIN" in 6.3 ??|
|Previous:||From: Cristian Gafton||Date: 1998-03-01 09:23:53|
|Subject: Re: [HACKERS] Re: [QUESTIONS] 6.2.1 COPY X FROM stdin; -- broken pipe|