Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 938044768B8 for ; Mon, 17 Jun 2002 11:32:32 -0400 (EDT) Received: from mail.iinet.net.au (symphony-03.iinet.net.au [203.59.3.35]) by postgresql.org (Postfix) with SMTP id 11489476444 for ; Mon, 17 Jun 2002 10:43:34 -0400 (EDT) Received: (qmail 9389 invoked by uid 666); 17 Jun 2002 14:43:34 -0000 Received: from unknown (HELO SOL) (203.59.103.47) by mail.iinet.net.au with SMTP; 17 Jun 2002 14:43:34 -0000 Message-ID: <005501c2160c$e554be30$0200a8c0@SOL> From: "Christopher Kings-Lynne" To: "Matt" , References: <3D0A3A44.2090401@weilpublishing.com> Subject: Re: check Date: Mon, 17 Jun 2002 22:40:13 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Archive-Number: 200206/217 X-Sequence-Number: 8182 Look at: http://techdocs.postgresql.org/ Look at the introduction to RULES where they do a read-only column. Chris ----- Original Message ----- From: "Matt" To: Sent: Saturday, June 15, 2002 2:47 AM Subject: [SQL] check > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >