hi postgres-team,
i have set up a the mnogosearch engine on our webserver using postgresql
version 7.0.2. in the last time i experienced server errors when searching
for certain keywords. it turned out that the problem was the database
crashing on certain select statements on the mnogosearch url
- Postgresql 7.1RC2
- installed from the RPM on Red Hat 7.0 on x86
- fresh databases built (initdb)
- error happens connecting with psql on UNIX domain sockets,
but there's no evidence it's exclusive to that interface
I am not sure whether this is a bug or a tightening-up of a previous
loose SQL
Some background:
Version: postgresql-7.0.3 installed in nonstandard location
(/home/nssrta/pgsql)
OS:Solaris 2.6 (patch level unknown, but definitely not current)
Running under the installed user id
Item #1 Bug in runtest:
In order to get the runtest regression test to wor
Justin,
I am using the Redhat 7.0 distribution, updated with a 2.2.18 kernel.
> Hi Jay,
>
> Which OS are you using? Mandrake-Linux 7.2 is known to have bugs in
> the version of PostgreSQL they supply as RPM's.
>
> Regards and best wishes,
>
> Justin Clift
>
> [EMAIL PROTECTED] wrote:
>>
>> Jay
Dear sir,
I build PostgreSQL 7.0.3 with jumbo-20010318.patch.gz on Vine Linux2.1.5.
Following result are incorrect. Am I under an illusion?
test=# select '3424082'::numeric % '3471'::numeric;
?column?
--
-46918
(1 row)
test=# select '3424082'::numeric - '3471'::num
Dear sir,
I build PostgreSQL 7.0.3 with jumbo-20010318.patch.gz on Vine Linux2.1.5.
Following result are incorrect. Am I under an illusion?
test=# select '3424082'::numeric % '3471'::numeric; ?column?
--
-46918
(1 row)
test=# select '3424082'::numeric - '3471'::nume
