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

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

You forgot the cache_idx. You must name an index in order to create it.

- Richard Sumilang


On Nov 4, 2003, at 6:01 PM, David Macbanay wrote:

>>> 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);
>>
> Here is the error that I get when I use that statement
>
> DB Error: syntax error
> CREATE INDEX on cache (mod_title) [nativecode=ERROR: parser: parse 
> error
> at or near "on" at character 14 ]
>
> David
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>