X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 935179DCBB6 for ; Tue, 29 Nov 2005 06:31:17 -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 14817-04 for ; Tue, 29 Nov 2005 06:31:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id EB4F19DCB10 for ; Tue, 29 Nov 2005 06:31:14 -0400 (AST) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr2.postgresql.org (Postfix) with ESMTP id 0A36CF0B57 for ; Tue, 29 Nov 2005 10:31:16 +0000 (GMT) Received: from lfix.demon.co.uk ([80.177.205.209] helo=cerberus.lfix.co.uk) by anchor-post-32.mail.demon.net with esmtp (Exim 4.42) id 1Eh2lT-000IFE-75; Tue, 29 Nov 2005 10:31:11 +0000 Received: from linda.lfix.co.uk ([192.168.1.1]) by cerberus.lfix.co.uk with esmtp (Exim 4.50) id 1Eh2lP-0005rP-6A; Tue, 29 Nov 2005 10:31:07 +0000 Subject: Re: DEFAULT Constraint based on table type? From: Oliver Elphick Reply-To: olly@lfix.co.uk To: Announce Cc: pgsql-sql@postgresql.org In-Reply-To: <1133260318.10517.34.camel@linda.lfix.co.uk> References: <1133260318.10517.34.camel@linda.lfix.co.uk> Content-Type: text/plain Date: Tue, 29 Nov 2005 10:33:08 +0000 Message-Id: <1133260388.10517.36.camel@linda.lfix.co.uk> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-LFIX-MailScanner: Found to be clean X-LFIX-MailScanner-SpamCheck: not spam, SpamAssassin (score=-4.399, required 5, autolearn=not spam, ALL_TRUSTED -1.80, BAYES_00 -2.60) X-LFIX-MailScanner-From: olly@lfix.co.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/267 X-Sequence-Number: 23518 On Tue, 2005-11-29 at 10:31 +0000, Oliver Elphick wrote: > SELECT tableoid::regproc, * from animals; regproc should be regclass; sorry. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html