X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 19B279DCAD4 for ; Wed, 8 Feb 2006 06:36:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16000-02 for ; Wed, 8 Feb 2006 06:36:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.aircomp.aero (60.Red-80-36-217.staticIP.rima-tde.net [80.36.217.60]) by postgresql.org (Postfix) with ESMTP id BAD4A9DCAC9 for ; Wed, 8 Feb 2006 06:36:07 -0400 (AST) Received: from [192.168.0.101] (unknown [192.168.0.101]) by smtp.aircomp.aero (Postfix) with ESMTP id 40ABD43B17 for ; Wed, 8 Feb 2006 11:36:18 +0100 (CET) Message-ID: <43E9C995.4060904@aircomp.aero> Date: Wed, 08 Feb 2006 11:36:05 +0100 From: lrotger Organization: AIRCOMP, SL User-Agent: Mozilla Thunderbird 0.8 (X11/20040926) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: Actual expression of a constraint References: <43E71F51.7030108@aircomp.aero> <27878.1139249149@sss.pgh.pa.us> <43E8BDE3.6000802@aircomp.aero> <7508.1139328081@sss.pgh.pa.us> <43E8D024.40900@aircomp.aero> <27461.1139336188@sss.pgh.pa.us> In-Reply-To: <27461.1139336188@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.214 required=5 tests=[AWL=0.025, MISSING_HEADERS=0.189] X-Spam-Score: 0.214 X-Spam-Level: X-Archive-Number: 200602/80 X-Sequence-Number: 20501 Tom Lane wrote: > > > Yes, you should. Someday one of those bugs will eat your data. The > fact that it hasn't happened yet does not mean you're not at risk; > a lot of them are simply race conditions with very small windows. > > regards, tom lane I read some of the logs up until 7.3 (from my old 7.2.1); I should benefit from upgrading but there are issues to consider, for example, I see 'timestamp' was changed from with to without time zone in 7.3, I'll have to follow these changes carefully to upgrade without problems. Thanks, L Rotger