Received: from kundera.shonline.de (kundera.shonline.de [194.172.236.18]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA16107 for ; Mon, 14 Sep 1998 05:28:12 -0400 (EDT) Received: from kafka.shonline.de (kafka [194.172.236.17]) by kundera.shonline.de (8.8.8/8.8.8) with ESMTP id LAA18783; Mon, 14 Sep 1998 11:28:05 +0200 (MET DST) Received: from shonline.de (lenz [194.172.236.13]) by kafka.shonline.de (8.8.8/8.8.8) with ESMTP id LAA03619; Mon, 14 Sep 1998 11:28:04 +0200 (MET DST) Message-ID: <35FCE1B1.49CB7635@shonline.de> Date: Mon, 14 Sep 1998 11:28:17 +0200 From: "Kristian =?iso-8859-1?Q?K=F6hntopp?=" Organization: SH Online Dienst GmbH X-Mailer: Mozilla 4.5b1 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Oliver Duke-Williams CC: pgsql-sql@postgresql.org, phplib@mail.shonline.de Subject: Re: [PHPLIB] SQL probs with phplib References: <9809141757.ZM3032@tsg109.gisca.adelaide.edu.au> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Oliver Duke-Williams wrote: > changed varchar(14) DEFAULT '' NOT NULL, > ERROR: type name lookup of changed failed changed is a regular varchar(14) and should be taken by Postgres without problems. At least my Postgres did. > ERROR: parser: Syntax error at or near "k_username" Just donīt name that key (leave out the k_username). Alternatively define the table without keys first and add the keys later using the CREATE INDEX statement. > Having drawn a blank in searching list archives, I'd be grateful > for any advice about what the correct pgsql versions of the above > should be. Postgres support is new in release-5 of PHPLIB. There are not many success reports with Postgres up to now. I am a MySQL type myself and very new to Postgres... Kristian -- SH Online Dienst GmbH, Kristian Koehntopp, Siemenswall, 24107 Kiel, +49 431 386 436 00 Using PHP3? See our web development library at http://phplib.shonline.de/ (GPL)