Received: from localhost.localdomain (IDENT:root@ghettotek.subimage.com [63.197.74.44]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA49327 for ; Sun, 27 Feb 2000 02:40:11 -0500 (EST) (envelope-from seth@subimage.com) Received: from GOLGO13 (megatron@golgo13.subimage.com [63.197.74.42]) by localhost.localdomain (8.9.3/8.8.7) with SMTP id XAA01692 for ; Sat, 26 Feb 2000 23:45:35 -0800 From: "Seth Banks" To: Subject: Default sequence values Date: Sat, 26 Feb 2000 23:45:36 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 I'm getting errors in pgsql when I try to run this create table statement past...Could someone help me out here? I think it's the default value of company_id that's erroring out. Any help is appreciated. CREATE SEQUENCE company_id_seq; CREATE TABLE company ( company_id int4 PRIMARY KEY DEFAULT nextval(company_id_seq), parent_id int4 NULL, name text NOT NULL, address_1 text NULL, address_2 text NULL, fax text NULL, city text NULL, state_province text NULL, zip text NULL, country text NULL, description text NULL, stock_symbol text NULL ); CREATE INDEX name_idx on company (name);