Re: [Phpwebsite-developers] Postgres Support (making progress...)

[Brian G. <br...@vf...>]

David Macbanay wrote:
> Others need things changed like mediumtext and longtext to just text. 
> "Tinyint(*)" needs to be changed to "smallint", "int(*)" needs to be
> changed to "int" and the "unsigned" keyword needs to be removed. The

There are also some varchar binary's that need to have the binary 
stripped.

> biggest problem I've been having is in the "setup/install.sql" file.  I
> do not know the equivalent syntax for lines such as
> "index(mod_title,id)".  Someone has mentioned about removing these line

I used:

create index cache_idx on cache (mod_title, id);

This works just fine.  However, I don't know if it should be UNIQUE or 
not.  This is where an ER diagram would come in handy.  Perhaps this 
week I will be a single diff of everything I've changed so far.  I'm 
working on a Redhat Linux box against Postgres 7.3 but it should be 
similar for any other releases.


Brian