X-Original-To: pgsql-interfaces@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 2D7E092500B for ; Mon, 26 May 2003 13:05:22 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 38313-08 for ; Mon, 26 May 2003 13:05:21 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id 575B7924FFB for ; Mon, 26 May 2003 13:05:21 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4QH5JU6002389; Mon, 26 May 2003 13:05:20 -0400 (EDT) To: "Dietmar May" Cc: pgsql-interfaces@postgresql.org Subject: Re: Race condition with libpq In-reply-to: <00a001c323a6$cbb02d90$fb02a8c0@muskrat> References: <00a001c323a6$cbb02d90$fb02a8c0@muskrat> Comments: In-reply-to "Dietmar May" message dated "Mon, 26 May 2003 12:49:38 -0400" Date: Mon, 26 May 2003 13:05:19 -0400 Message-ID: <2388.1053968719@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/72 X-Sequence-Number: 4190 "Dietmar May" writes: > So, why can't the server-side code that closes the connection release any > resources associated with that connection before the socket is closed? It > seems that doing so could fix this problem quite cleanly. How would that help? The client isn't waiting around for it, because it already closed its socket. > Perhaps I'm misunderstanding the manual - "4.1: When a new database is > created, the template database [template1] is essentially cloned. At least in recent versions, template1 is only the default template, not the sole possibility. In theory you could in fact run without any template1, but it would break enough client-side code that I doubt anyone would find it useful to do so in practice. regards, tom lane