Received: from student.merz-akademie.de (73.ptr.merz-akademie.de
	[195.226.105.73] (may be forged))
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAL1aYs50450
	for <pgsql-interfaces@postgresql.org>;
	Mon, 20 Nov 2000 20:36:35 -0500 (EST)
	(envelope-from alvar.freude@merz-akademie.de)
Received: from merz-akademie.de (news.merz-akademie.de [195.226.105.70])
	by student.merz-akademie.de (8.9.3/8.9.3) with ESMTP id CAA30128
	for <pgsql-interfaces@postgresql.org>; Tue, 21 Nov 2000 02:34:34 +0100
Message-ID: <3A19D210.1CDBB1EE@merz-akademie.de>
Date: Tue, 21 Nov 2000 02:38:24 +0100
From: Alvar Freude <alvar.freude@merz-akademie.de>
Organization: http://a-blast.org/
X-Mailer: Mozilla 4.7 [de] (WinNT; I)
X-Accept-Language: de
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: Create tables using Perl DBI
References: <HEEKIDKMKOPLHIMFOPMLMEICCDAA.davidcoley@home.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200011/218
X-Sequence-Number: 254

Hi,

> $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, 
[...]

there is a default text required I guess!


bye
  Alvar



-- 
Alvar C.H. Freude  |  alvar.freude@merz-akademie.de

    Demo: http://www.online-demonstration.org/  |  Mach mit!
Blast-DE: http://www.assoziations-blaster.de/   |  Blast-Dich-Fit
Blast-EN: http://www.a-blast.org/               |  Blast/english