I have a similar problem, I check out contacts from the cvs head , this is a installation of new 5.2 on postgres 7.4
Installing packages...
Installing Contacts 1.1d12
* Installing data model for Contacts 1.1d12...
o Loading data model /var/lib/aolserver/elshk/packages/contacts/sql/postgresql/contacts-create.sql...
CREATE TABLE
content_type__create_type
---------------------------
0
(1 row)
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE VIEW
CREATE TABLE
CREATE TABLE
define_function_args
----------------------
1
(1 row)
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
content_folder__register_content_type
---------------------------------------
0
(1 row)
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
define_function_args
----------------------
1
(1 row)
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE TABLE
acs_object_type__create_type
------------------------------
0
(1 row)
CREATE TABLE
CREATE TABLE
define_function_args
----------------------
1
(1 row)
CREATE FUNCTION
CREATE FUNCTION
CREATE SEQUENCE
CREATE TABLE
CREATE TABLE
CREATE TABLE
INSERT 723952 1
INSERT 723953 1
INSERT 723954 1
INSERT 723955 1
INSERT 723956 1
CREATE TABLE
acs_object_type__create_type
------------------------------
0
(1 row)
Failed to install Contacts, version 1.1d12. The following error was generated:
CONTEXT: PL/pgSQL function "acs_object__new" line 17 at select into variables PL/pgSQL function "content_item__new" line 85 at assignment PL/pgSQL function "content_folder__new" line 34 at assignment PL/pgSQL function "content_folder__new" line 7 at return PL/pgSQL function "contact__folder_id" line 11 at assignment psql:contacts-messages-create.sql:38: ERROR: syntax error at or near ")" at character 965 psql:contacts-messages-create.sql:55: ERROR: syntax error at or near "cr" at character 181
NOTE: If the error comes from a sql script you may try to source it manually. When you are done with that you should revisit the APM and try again but remember to leave the manually souced sql scipts unchecked on the previous page.
