Received: from duck.standby.nl (root@duck.computel.nl [193.67.110.3]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA15566 for ; Mon, 14 Sep 1998 05:23:44 -0400 (EDT) Received: from verseveld (verseveld.computel.nl [193.67.110.222]) by duck.standby.nl (8.8.5/8.7.3) with SMTP id IAA14122; Mon, 14 Sep 1998 08:23:34 -0100 Message-ID: <011e01bddfc1$58ef4580$de6e43c1@verseveld.computel.nl> From: "Szandor van Verseveld" To: "Oliver Duke-Williams" , , Subject: Re: [PHPLIB] SQL probs with phplib Date: Mon, 14 Sep 1998 11:23:34 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3155.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0 I use the following to create the Postgres database: CREATE TABLE active_sessions ( sid varchar(32) DEFAULT '' NOT NULL, name varchar(32) DEFAULT '' NOT NULL, val text, changed varchar(14) DEFAULT '' NOT NULL ); CREATE INDEX active_sessions_index ON active_sessions USING hash (sid varchar_ops); GRANT ALL ON active_sessions TO apache; You can set the permissions to another user than apache. Met vriendelijke groet, Szandor van Verseveld Nederland.Net Icq: 14801584 -----Original Message----- From: Oliver Duke-Williams To: pgsql-sql@postgresql.org ; phplib@shonline.de Date: maandag 14 september 1998 10:45 Subject: [PHPLIB] SQL probs with phplib >Hi, > >I'm trying to set up phplib (release 5) for use with postgresql(6.3 I >_think_ but pg_version is empty, and I can't see an actual version >number anywhere... ), and having a couple of problems with the supplied >file create_database.sql (originally written with mySQL in mind). > >Specifically, in the first table created: > >CREATE TABLE active_sessions ( > sid varchar(32) DEFAULT '' NOT NULL, > name varchar(32) DEFAULT '' NOT NULL, > val text, > changed varchar(14) DEFAULT '' NOT NULL, > PRIMARY KEY (sid,name), > KEY changed (changed) >); > >an error is reported: > >ERROR: type name lookup of changed failed > >(In postgres, do I need to go though a 'create type' process here?) > >and in the second table: > >CREATE TABLE auth_user ( > uid varchar(32) DEFAULT '' NOT NULL, > username varchar(32) DEFAULT '' NOT NULL, > password varchar(32) DEFAULT '' NOT NULL, > perms varchar(255), > PRIMARY KEY (uid), > UNIQUE k_username (username) >); > >the following error is generated: > >ERROR: parser: Syntax error at or near "k_username" > >(Will this need some additional command aling the lines of >'create unique index'?) > >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. > >NB: This is posted to two lists - I'm happy to summarise later if people >don't want to xpost replies. > >Thanks, > >Oliver > >- >PHP3 Base Library Mailing List. Send messages to . >To unsubscribe, send "unsubscribe" to in >the body, not the subject, of your message. >