Forums / Install & configuration / PostgreSQL statement ERROR?

PostgreSQL statement ERROR?

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

christian stampf

Wednesday 24 September 2003 9:31:32 pm

hi,

i just run kernel_schema.sql against my postgreSQL server (version 7.2.x) and get an error:

aradirect=> CREATE INDEX ezurlalias_source_url ON ezurlalias(source_url(255));
ERROR: parser: parse error at or near "255"

any idea how to fix this?

Jan Borsodi

Thursday 25 September 2003 12:18:11 am

Try removing the (255) part from the text, ie.
CREATE INDEX ezurlalias_source_url ON ezurlalias(source_url);

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

christian stampf

Friday 26 September 2003 7:12:00 am

yes, this did the trick.

thanks a bunch!