X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9800CD1B517 for ; Thu, 23 Oct 2003 10:07:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18138-04 for ; Thu, 23 Oct 2003 07:07:02 -0300 (ADT) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by svr1.postgresql.org (Postfix) with ESMTP id 329DFD1B50C for ; Thu, 23 Oct 2003 07:06:55 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 1ACcMr-0005N0-0V; Thu, 23 Oct 2003 11:06:57 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 633F417768; Thu, 23 Oct 2003 11:06:56 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id ADDB416D2D; Thu, 23 Oct 2003 11:06:55 +0100 (BST) From: Richard Huxton To: Christoph Haller Subject: Re: Automatic compat checking? (was 7.4 compatibility question) Date: Thu, 23 Oct 2003 11:06:55 +0100 User-Agent: KMail/1.5 Cc: pgsql-hackers@postgresql.org References: <200310230901.LAA01054@rodos> In-Reply-To: <200310230901.LAA01054@rodos> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200310231106.55184.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/1069 X-Sequence-Number: 45751 On Friday 24 October 2003 00:01, Christoph Haller wrote: > > A pg_compat_chk utility sounds great. > No idea, if this is practical, but it's desirable - at least to me. Well, I'm confident the first 90% is practical just by running some regexps against a pg_dumped schema. It doesn't need to guarantee there's a problem, just say "here's something you want to check". And there are things you could probably never check convincingly (e.g. the queries in an application). It's that final 10% that makes me uncertain. Maybe it'd be enough to just list "tests I couldn't perform", at first anyway. -- Richard Huxton Archonet Ltd