Re: [HACKERS] Re: Postgresql broken
От | Cristian Gafton |
---|---|
Тема | Re: [HACKERS] Re: Postgresql broken |
Дата | |
Msg-id | Pine.LNX.3.96.980301042725.31158G-100000@localhost.localnet обсуждение исходный текст |
Ответ на | Re: [HACKERS] Re: Postgresql broken ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>) |
Список | pgsql-hackers |
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... :-) Best wishes, Cristian -- ---------------------------------------------------------------------- Cristian Gafton -- gafton@redhat.com -- Red Hat Software, Inc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ UNIX is user friendly. It's just selective about who its friends are.
В списке pgsql-hackers по дате отправления: