Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id E1AAC632EA1
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 13 Mar 2009 13:26:11 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 18907-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 13 Mar 2009 13:26:10 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qy0-f106.google.com (mail-qy0-f106.google.com
	[209.85.221.106])
	by mail.postgresql.org (Postfix) with ESMTP id 5D64A6354A4
	for <pgsql-admin@postgresql.org>; Fri, 13 Mar 2009 13:26:09 -0300 (ADT)
Received: by qyk4 with SMTP id 4so251754qyk.15
	for <pgsql-admin@postgresql.org>; Fri, 13 Mar 2009 09:26:08 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=WGlcrQaX4lAQo3cz9IvXBts5twusSdYzAOfW9EAY3zc=;
	b=uUuHxVeh+yp7LFrYGqgN3sOiEfzEK0++GFNcBLauJzComOBQhpa5/XvfeCwZuvaXRS
	uAA2Ro1TiT+4hF55htoLYrcjWIk5GSNgDTaoWiR9EyAl6cCMNf1pZaW37VbKqSJC/Zi8
	hUsLI+JChe/5y/RP5vd2HH/wEF6JtN5PXxTHk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=KGKYqqGvtrFW65fgT/5uDz1wU2qhXs2BIg3mbF0rClqVCkvk5x4OGIpPikrqwh1GZk
	T6f53q0EXY5XWX1Xm+uu4u4oyvejRI/K5LuXa4AmGi626Dn9DBtMIqufuKLgm5y+F6J4
	MKPtO7eQXFkTN2mT4ht3ZIlYXTN5dP09vsNp8=
MIME-Version: 1.0
Received: by 10.224.45.141 with SMTP id e13mr2222091qaf.165.1236961568514;
	Fri, 13 Mar 2009 09:26:08 -0700 (PDT)
In-Reply-To: <903E40F0-DB11-4815-9709-840813D4F3D7@indiana.edu>
References: <9114EFEB-B699-4EC0-9201-35C0A49BC326@indiana.edu>
	<20090313151319.GD4379@alvh.no-ip.org>
	<DCAA40F0-3DE4-45D8-BC0B-CAC58383D616@indiana.edu>
	<dcc563d10903130918y4fdf12f1m4cea966e0ab18684@mail.gmail.com>
	<903E40F0-DB11-4815-9709-840813D4F3D7@indiana.edu>
Date: Fri, 13 Mar 2009 10:26:08 -0600
Message-ID: <dcc563d10903130926u2f61215cj643a64d049bf2c20@mail.gmail.com>
Subject: Re: Strongly typed?
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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: 200903/169
X-Sequence-Number: 31669

On Fri, Mar 13, 2009 at 10:21 AM, Carol Walter <walterc@indiana.edu> wrote:
> That would be a better plan, but I don't know what they are. =A0Is there =
an
> integrity check utility that will run the databases and check this?

I'd just pg_dump -s (schema only) then restore the schema to an 8.3
and look for errors.