Forum .LRN Q&A: Ecommerce error installation

Collapse
1: Ecommerce error installation
Posted by Felix Paco on 01/23/08 04:17 PM
Hi all,

when I'm trying to install the package ecommerce I get the following error:

Error: apm_package_install: Error installing E-Commerce version 5.05: psql:ecommerce-create.sql:51: ERROR: syntax error at or near "(" at character 22 psql:ecommerce-create.sql:51: LINE 1: create function least(numeric,numeric)

I'm working with dotlrn 2.3.0 and postgresql 8.1.9, did anyone get the same error? can anyone help me?

Thanks in advance.

Collapse
2: Re: Ecommerce error installation (response to 1)
Posted by Dave Bauer on 01/23/08 04:23 PM
Hi, looks like least is a built in funciton in newer versions of PostgreSQL.

Try commenting out that function declartion in ecommerce-create.sql.

Collapse
3: Re: Ecommerce error installation (response to 2)
Posted by Don Baccus on 01/23/08 08:06 PM
Yes, greatest (value [, value]) and least (value [,value]) are now pre-declared. This is an oracle function that wasn't defined previously in PG, and also back then "create or replace" didn't exist.

I've removed the declaration from CVS HEAD.