PostgresSQL

[Milan Roubal]

byl to tento dotaz ktery jinak prosel uz nepocitane krat v poradku.
SELECT DISTINCT
nabidky.id_nabidky,nabidky.pozice,nabidky.id_pobocky,registr_pobocek.nazev,n
abidky.pracoviste,nabidky.jazyk,nabidky.datum,nabidky.id_oblast FROM
nabidky,nabidky_obor,registr_pobocek WHERE nabidky.active='t' and
nabidky.id_pobocky=registr_pobocek.id_registr_pobocek AND
nabidky.id_nabidky=nabidky_obor.id_nabidky  AND nabidky_obor.id_obor='11'
ORDER BY nabidky.datum DESC

Zdravi
   Milan Roubal
   roubm9am na barbora.ms.mff.cuni.cz


----- Original Message -----
From: "Karel Zak" <zakkr na zf.jcu.cz>
To: <linux na linux.cz>
Sent: Thursday, June 28, 2001 9:07 AM
Subject: Re: PostgresSQL


On Wed, Jun 27, 2001 at 07:26:49PM +0200, Milan Roubal wrote:
> DD,
> dnes na me vychrlil PHP 4.0.4pl1 napojeny na postgreSQL verze 7.0.3  tuto
hlasku
>
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.

     To je jednoduche, PG obdrzel od kernelu signal 11 za nejakou
nepeknou operaci. Mozna to je nejaky bug, pokud ano je dulezite
jaky to byl dotaz. Obecna odpoved je prejdete na 7.1 kde bylo
opraveno par memory leaku.

Karel