Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 8D4C8477430 for ; Fri, 14 Jun 2002 15:18:22 -0400 (EDT) Received: from pony (office.weilpublishing.com [207.5.188.53]) by postgresql.org (Postfix) with SMTP id CEA55477656 for ; Fri, 14 Jun 2002 14:45:08 -0400 (EDT) Received: (qmail 18193 invoked from network); 14 Jun 2002 18:45:09 -0000 Received: from unknown (HELO weilpublishing.com) ([192.168.1.61]) (envelope-sender ) by 192.168.2.2 (qmail-ldap-1.03) with SMTP for ; 14 Jun 2002 18:45:09 -0000 Message-ID: <3D0A3A44.2090401@weilpublishing.com> Date: Fri, 14 Jun 2002 14:47:32 -0400 From: Matt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9) Gecko/20020412 Debian/0.9.9-6 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: check Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/216 X-Sequence-Number: 8181 how would you go about enforcing the default value: I have a nextval('seq') as my default and on an insert I don't want any other value to be allowed. forget my last query about inheritance issues