Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 286082E007F for ; Fri, 21 Mar 2008 06:41:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 77122-06 for ; Fri, 21 Mar 2008 06:40:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id 3CF492E0061 for ; Fri, 21 Mar 2008 06:41:02 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d37so2290503pye.29 for ; Fri, 21 Mar 2008 02:41:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=Epm4TaIisEdf7QPoyc13Hx8Tad90aI6yq73pYG1rwYA=; b=tcF195FnXqBh99BcQZl8kO+ps6LROZYvd6rtrV7Qy38gzguFb5EjWtrwDoT62HmLAHY7aDe1x2XKcsEeuEhjdf2FEdxw7v7zS4vcuRKA/kSIWISZyoL4ntlI1Yx0X5vYx9gHTpFR6tStpJP1Lnz6OvQAV/sSOVi1Oo1UJ79EOw4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=J4QXcRTKDIrEWXvTog7xFUYp1Ec03WDNsMrKY353fqRPLmSML7srXCfZX48jZ3qK8f4zr7jWefCTju6/pwyOyjtBMq4v+V5aO/u2QGKRxkSVgTIDt8DzR7yKrALZMzHmts78WthFtjmcIG4XNYMhbAWHmsDQ2iCizkwaXNTjwiA= Received: by 10.35.84.20 with SMTP id m20mr2148948pyl.55.1206092460324; Fri, 21 Mar 2008 02:41:00 -0700 (PDT) Received: by 10.35.32.13 with HTTP; Fri, 21 Mar 2008 02:41:00 -0700 (PDT) Message-ID: Date: Fri, 21 Mar 2008 02:41:00 -0700 From: "Ian Tegebo" To: pgsql-sql@postgresql.org Subject: Testing DDL MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/163 X-Sequence-Number: 30491 I've recently become curious as to how people are testing their DDL. So far, I've found: Re: The Right Way to manage schemas in SCM systems http://archives.postgresql.org/pgsql-sql/2006-08/msg00114.php http://www.bigsmoke.us/postgresql-unit-testing/ http://utplsql.sourceforge.net/ http://www.opensourcetesting.org/unit_sql.php Has anyone seen other approaches? -- Ian Tegebo