Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3072A6501AB for ; Thu, 11 Dec 2008 22:09:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29453-09 for ; Thu, 11 Dec 2008 22:09:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from wavecable.net (mail3.wavecable.com [24.113.32.25]) by mail.postgresql.org (Postfix) with ESMTP id A5AA464FD96 for ; Thu, 11 Dec 2008 22:09:50 -0400 (AST) Received: from [76.14.161.10] (HELO [192.168.1.215]) by wavecable.net (CommuniGate Pro SMTP 4.2.8) with ESMTP id 76469584 for pgsql-admin@postgresql.org; Thu, 11 Dec 2008 17:57:34 -0800 From: johnf To: pgsql-admin@postgresql.org Subject: Re: primary key and insert Date: Thu, 11 Dec 2008 18:09:47 -0800 User-Agent: KMail/1.9.6 (enterprise 20070904.708012) References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200812111809.47962.jfabiani@yolo.com> 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: 200812/102 X-Sequence-Number: 30935 On Thursday 11 December 2008 03:27:59 pm Marc Fromm wrote: > =A0id =A0 =A0 =A0 =A0 | integer =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 | not null I believe you did not set the field 'id' to a data type of serial. If you = had=20 you would have "nextval(" in the Modifiers column. =2D-=20 John Fabiani