From: | "Kristian =?iso-8859-1?Q?K=F6hntopp?=" <kk(at)shonline(dot)de> |
---|---|
To: | Oliver Duke-Williams <oduke(at)gisca(dot)adelaide(dot)edu(dot)au> |
Cc: | pgsql-sql(at)postgresql(dot)org, phplib(at)mail(dot)shonline(dot)de |
Subject: | Re: [PHPLIB] SQL probs with phplib |
Date: | 1998-09-14 09:28:17 |
Message-ID: | 35FCE1B1.49CB7635@shonline.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | David Hartwig | 1998-09-14 20:10:02 | Re: [SQL] SQL probs with phplib |
Previous Message | Szandor van Verseveld | 1998-09-14 09:23:34 | Re: [PHPLIB] SQL probs with phplib |