Error : could not send data to client - Mailing list pgsql-sql

From vab ip
Subject Error : could not send data to client
Date
Msg-id 20040927163440.94901.qmail@web25101.mail.ukl.yahoo.com
Whole thread Raw
List pgsql-sql

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 !

pgsql-sql by date:

Previous
From: Dag Gullberg
Date:
Subject: Concurrency problem
Next
From: sreejith s
Date:
Subject: Postgres Doubt