[Phpwebsite-developers] postgresql errors

[Richard S. <ri...@ri...>]

I tried setting up a copy of phpwebsite with a postgre db and I got the  
following error trying to setup the core only.

Bad....
------------------------------------------------------------------------ 
-------------

DB Error: syntax error
CREATE TABLE cache ( mod_title varchar(30) NOT NULL default '', id  
varchar(32) NOT NULL default '', data text NOT NULL, ttl int NOT NULL  
default '0', index (mod_title, id) ) [nativecode=ERROR: parser: parse  
error at or near "(" at character 166 ]




Good...
------------------------------------------------------------------------ 
-------------
CREATE TABLE cache ( mod_title varchar(30) NOT NULL default '', id  
varchar(32) NOT NULL default '', data text NOT NULL, ttl int NOT NULL  
default '0', primary key (mod_title, id) )



With postgre, index's are not created within the "create table" syntax  
and since it's not the SQL standard then it probably wont work with  
Oracle and other databases (I think). With using a primary key you  
don't need to index since primary keys are always indexed and I think  
mod_title and id are never exactly the same correct?

I would like to have pws working on postgre since I am porting most of  
my applications to it so if you guys want me to do any tests of setting  
up pws and using some of the mods let me know.

- Richard S.