On Fri, Dec 12, 2003 at 11:59:45AM +0530, Shridhar Daithankar wrote:
>Rajesh wrote:
>>$sSql = "select func_stockoutitems('$txtFromDate', '$txtToDate',
>>'$txtDescription')";
>>$lResult = pg_query($oConn, $sSql);
>>Similar kind of stuff is done in other scripts where stored procedure
>>functions are called and that is working without any problems...
>>
>>Can anybody throw light on the above error and what could be the
>>probable cause ?
>
>Check two things. One, if there is anything relevant in postgresql logs.
>Probably you can log the statements as well so that you can see the exact
>query sent to backend.
Nothing in postgresql logs...
Only three parameters are passed to the function. That's all.. See
below.
>
>Secondly does the same query runs from psql?
I had done this too.. But the same error :
DBCURRENT=# select func_stockoutitems('01/10/2003', '05/10/2003', '');
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#
Thanks
Warm Regards
--
Rajesh
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
