Received: from mail2.rdc3.on.home.com (mail2.rdc3.on.home.com [24.2.9.41]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eALLles26875 for ; Tue, 21 Nov 2000 16:47:41 -0500 (EST) (envelope-from davidcoley@home.com) Received: from cr572379a ([24.114.120.154]) by mail2.rdc3.on.home.com (InterMail vM.4.01.03.00 201-229-121) with SMTP id <20001121214529.CTLB25249.mail2.rdc3.on.home.com@cr572379a> for ; Tue, 21 Nov 2000 13:45:29 -0800 From: "David Coley" To: Subject: RE: Create tables using Perl DBI Date: Tue, 21 Nov 2000 16:50:54 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 In-Reply-To: <20001121145414.A5837@rice.edu> Importance: Normal X-Archive-Number: 200011/226 X-Sequence-Number: 262 Hum... I tried adding that extra ) at end of the prepare: $sth = $dbh->prepare("create table customer (ID serial PRIMARY KEY, name text NOT NULL, email text NOT NULL, phone text NOT NULL, fax text DEFAULT, address text NOT NULL, address2 text DEFAULT, zip text NOT NULL, city text NOT NULL, state text NOT NULL, country text NOT NULL)") or die "Could not Create Table: $DBI::errstr"; $sth->execute; #disconnect from the database. $dbh->disconnect(); > > It looks like you're missing a ")" in there somewhere. > Parse error usually = syntax error. > Still the same error: DBD::Pg::st execute failed: ERROR: parser: parse error at or near "," David Coley davidcoley@home.com http://www.davidcoley.com