Re: About db session time-out while uploading data to database

------=_Part_31658_29820804.1206082687507
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,
Thanks a lot for your reply.



On Fri, Mar 21, 2008 at 11:54 AM, Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:

> "=?ISO-2022-JP?B?GyRCIXkbKEJQdW11IDotRCAbJEIheRsoQiA=?=" <
> paricharts@[EMAIL PROTECTED]
> writes:
> > I have a ****tion that uploading data.
> > if DB session time-out has happen while data is uploading,
> > I wonder that data in my database have been rollback or not.
>
> You are not very clear about what you mean by "uploading", but in
> general a PG backend will never commit a command that it hasn't fully
> received from the client.
>
>                        regards, tom lane


my file-upload function is run on a web and connect to postgreSQL
database.
While this upload function was uploading data to database,its web page
turn
to  display "
The page cannot be displayedThe page you are looking for is currently
unavailable. The Web site might be experiencing technical difficulties, or
you may need to adjust your browser settings. "
( I think one of this event 's  cause is DB access time out )

regards,
parichart

------=_Part_31658_29820804.1206082687507
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,<br>Thanks a lot for your reply.<br><br><font style="font-family:
verdana; font-style: normal; font-variant: normal; font-weight: normal;
font-size: 8pt; line-height: 11pt; font-size-adjust: none; font-stretch:
normal; color: black;"><br>
</font><br><div class="gmail_quote">On Fri, Mar 21, 2008 at 11:54 AM, Tom
Lane &lt;<a href="mailto:tgl@[EMAIL PROTECTED]
">tgl@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div
class="Ih2E3d">&quot;=?ISO-2022-JP?B?GyRCIXkbKEJQdW11IDotRCAbJEIheRsoQiA=?=&quot;
&lt;<a href="mailto:paricharts@[EMAIL PROTECTED]
">paricharts@[EMAIL PROTECTED]
>&gt;
writes:<br>
&gt; I have a ****tion that uploading data.<br>
&gt; if DB session time-out has happen while data is uploading,<br>
&gt; I wonder that data in my database have been rollback or not.<br>
<br>
</div>You are not very clear about what you mean by &quot;uploading&quot;,
but in<br>
general a PG backend will never commit a command that it hasn&#39;t
fully<br>
received from the client.<br>
<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp;regards, tom lane</blockquote><div><br>my file-upload
function is run on a web and connect to postgreSQL database.<br>While this
upload function was uploading data to database,its web page turn to&nbsp;
display &quot; <br>
<h1 id="textSection1" style="font-family: verdana; font-style: normal;
font-variant: normal; font-weight: normal; font-size: 13pt; line-height:
15pt; font-size-adjust: none; font-stretch: normal; color: black;"><span
id="errorText">The page cannot be displayed</span></h1>
<font style="font-family: verdana; font-style: normal; font-variant:
normal; font-weight: normal; font-size: 8pt; line-height: 11pt;
font-size-adjust: none; font-stretch: normal; color: black;">The page you
are looking for 
is currently unavailable. The Web site might be experiencing technical 
difficulties, or you may need to adjust your browser settings. &quot;<br>
( I think one of this event &#39;s&nbsp; cause is DB access time out
)<br></font><br>regards,<br>parichart<br></div></div><br>

------=_Part_31658_29820804.1206082687507--