From: vab ip <vab_ip@yahoo.fr>
To: pgsql-sql@postgresql.org
Subject: Error : could not send data to client
Date: Mon, 27 Sep 2004 18:34:40 +0200 (CEST)
Message-ID: <20040927163440.94901.qmail@web25101.mail.ukl.yahoo.com> (raw)
Hello,
Perhaps could you help me...
We work under Windows. Postgres is installed and functions in the form of service NT (postmaster). We also use a service "cron" which carries out regular tasks (same than the crontab under Linux).
We added an order (carried out every hour) in the "crontab" who launches file Shell script. This last file carries out (with psql call) a function defined in our PostGres database. The task is well carried out but the function does not seem to be carried out or not called. If we carry out the same file Shell script under Cygwin, the function is called and all the treatment is carried out.
For information, in the log postmaster, we have the following messages:
<<ERROR: could not send data to client: Connection aborted
<<CONTEXT: PL/pgSQL function "calculactivitesite" line 18 at SQL statement
<<LOG: could not receive data from client: Connection aborted
<<LOG: unexpected EOF on client connection
I realize that my message is long, but I tried to describe the situation as well as possible (especially taking into account my english level).
Thank you for your assistance.
---------------------------------
Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage !
Créez votre Yahoo! Mail
Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis.Téléchargez GRATUITEMENT ici !
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vab_ip@yahoo.fr
Subject: Re: Error : could not send data to client
In-Reply-To: <20040927163440.94901.qmail@web25101.mail.ukl.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox