Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA49630 for ; Sun, 27 Feb 2000 02:48:24 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id CAA20759; Sun, 27 Feb 2000 02:48:20 -0500 (EST) To: "Seth Banks" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Default sequence values In-reply-to: References: Comments: In-reply-to "Seth Banks" message dated "Sat, 26 Feb 2000 23:45:36 -0800" Date: Sun, 27 Feb 2000 02:48:20 -0500 Message-ID: <20756.951637700@sss.pgh.pa.us> From: Tom Lane "Seth Banks" writes: > company_id int4 PRIMARY KEY DEFAULT nextval(company_id_seq), Try company_id int4 PRIMARY KEY DEFAULT nextval('company_id_seq'), Actually, this would work just as well: company_id SERIAL, and it'd even make the sequence object for you. regards, tom lane