Re: [PHPLIB] SQL probs with phplib

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 <oduke@gisca.adelaide.edu.au>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>; phplib@shonline.de
<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 <phplib@shonline.de>.
>To unsubscribe, send "unsubscribe" to <phplib-request@shonline.de> in
>the body, not the subject, of your message.
>