PostgreSQL statement ERROR?

Previous topic

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!

Author

Message

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?

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);

Friday 26 September 2003 7:12:00 am

yes, this did the trick.

thanks a bunch!

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0051	588.2500	151.2266
Module start 'layout'	0.0051	0.0035	739.4766	36.6641
Module start 'content'	0.0085	0.0079	776.1406	90.1563
Module end 'content'	0.0164	0.0014	866.2969	33.9922
Script end	0.0178		900.2891

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	13.9101	14	0.0002
Check MTime	0.0011	6.3272	14	0.0001
Mysql Total
Database connection	0.0008	4.4768	1	0.0008
Mysqli_queries	0.0032	18.1839	3	0.0011
Looping result	0.0000	0.2071	1	0.0000
Template Total	0.0010	5.5	1	0.0010
Template load	0.0008	4.4034	1	0.0008
Template processing	0.0002	1.0527	1	0.0002
Override
Cache load	0.0006	3.2103	1	0.0006
General
dbfile	0.0036	19.9741	8	0.0004
String conversion	0.0000	0.0508	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs