X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 5CE77329F2F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Sep 2004 17:34:51 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 41618-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Sep 2004 16:34:43 +0000 (GMT)
Received: from web25101.mail.ukl.yahoo.com (web25101.mail.ukl.yahoo.com
	[217.12.10.49])
	by svr1.postgresql.org (Postfix) with SMTP id 326DF329F15
	for <pgsql-sql@postgresql.org>; Mon, 27 Sep 2004 17:34:42 +0100 (BST)
Message-ID: <20040927163440.94901.qmail@web25101.mail.ukl.yahoo.com>
Received: from [195.154.193.241] by web25101.mail.ukl.yahoo.com via HTTP;
	Mon, 27 Sep 2004 18:34:40 CEST
Date: Mon, 27 Sep 2004 18:34:40 +0200 (CEST)
From: vab ip <vab_ip@yahoo.fr>
Subject: Error : could not send data to client
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1054728824-1096302880=:92311"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0
	tests=HTML_FONTCOLOR_UNKNOWN, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200410/8
X-Sequence-Number: 19111

--0-1054728824-1096302880=:92311
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit


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 !
--0-1054728824-1096302880=:92311
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>
<P>Hello,</P>
<P>Perhaps could you help me...</P>
<P>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). </P>
<P>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.</P>
<P>For information, in the log postmaster, we have the following messages:</P><FONT face=Arial size=2>
<P>&lt;&lt;ERROR: could not send data to client: Connection aborted</P>
<P>&lt;&lt;CONTEXT: PL/pgSQL function "calculactivitesite" line 18 at SQL statement</P>
<P>&lt;&lt;LOG: could not receive data from client: Connection aborted</P>
<P>&lt;&lt;LOG: unexpected EOF on client connection</P></FONT>
<P>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). </P>
<P>Thank you for your assistance.</P></DIV><p>
		<hr size=1>
Créez gratuitement votre Yahoo! Mail avec <font color="red"><b>100 Mo de stockage !</b></font>
<br><a href="http://fr.rd.yahoo.com/mail/taglines/*http://fr.rd.yahoo.com/evt=25917/*http://fr.rd.yahoo.com/mail/mail_taglines_100/default/*http://fr.benefits.yahoo.com/">Créez votre Yahoo! Mail</a><br><br>
<font color="red"><b>Le nouveau Yahoo! Messenger est arrivé !</b></font> Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis.
<a href="http://fr.rd.yahoo.com/mail/taglines/*http://fr.rd.yahoo.com/evt=26111/*http://fr.rd.yahoo.com/messenger/mail_taglines/default/*http://fr.messenger.yahoo.com">Téléchargez GRATUITEMENT ici !</a>
--0-1054728824-1096302880=:92311--