From: Robert Haas <robertmhaas@gmail.com>
To: Donald Fraser <postgres@kiwi-fraser.net>
Cc: [BUGS] <pgsql-bugs@postgresql.org>
Cc: [ADMIN] <pgsql-admin@postgresql.org>
Subject: Re: [BUGS] [JDBC] Missing documentation for error code: 80S01
Date: Mon, 25 Apr 2011 15:57:17 -0400
Message-ID: <BANLkTi=QOf2v3fZhTPqq3TLR+-HeQFgJnA@mail.gmail.com> (raw)
In-Reply-To: <D100DC2FEE9E48788D640D6E7E110D21@DEVELOP1>
References: <00C88DF265FC483EBE2322C834A76698@DEVELOP1>
<4DA42B42020000250003C6F8@gw.wicourts.gov>
<3670D8885C9549A393E47A0C1582B07A@DEVELOP1>
<4DA45EA2020000250003C711@gw.wicourts.gov>
<6A526FFBDB9D4EE2947C4E5E282530E3@DEVELOP1>
<BANLkTimwwzsxhq36T4k7jNUexPEiyeVz_w@mail.gmail.com>
<D100DC2FEE9E48788D640D6E7E110D21@DEVELOP1>
On Wed, Apr 13, 2011 at 6:52 AM, Donald Fraser <postgres@kiwi-fraser.net> wrote:
>> If the server is shut down mid-query, doesn't the backend complete the
>> current query cycle before closing the connection?
>> i.e. we'd see ErrorResponse, ReadyForQuery, and return control to the
>> app before seeing EOF anyway?
>> The protocol spec is a bit vague there.
>
> From an observation perspective only: It would seem that in the case where
> the server is shut down gracefully yes, however in the case where the server
> has either crashed or the connection terminated un-gracefully via software
> control (for example a C funcion: elog(FATAL, "Terminating connection...");)
> then no.
A smart shutdown waits for clients to exit on their own. A fast or
immediate shutdown kills them immediately, even mid-query.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
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-admin@postgresql.org
Cc: robertmhaas@gmail.com, postgres@kiwi-fraser.net, pgsql-bugs@postgresql.org
Subject: Re: [BUGS] [JDBC] Missing documentation for error code: 80S01
In-Reply-To: <BANLkTi=QOf2v3fZhTPqq3TLR+-HeQFgJnA@mail.gmail.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