Forum OpenACS Q&A: Truncation errors when loading data model

I loaded the data model and most things work ok, but there are a
number of random places where I get a server error when trying to
access certain pages or functions.

When I check datamodel.txt for errors, I see a number of places where
there are truncation errors like these:

psql:user-groups.sql:317: NOTICE:  identifier
"set_user_group_roles_creation_date" will be truncated to
"set_user_group_roles_creation_d"

psql:user-groups.sql:321: NOTICE:  identifier
"set_user_group_roles_creation_date" will be truncated to
"set_user_group_roles_creation_d"

It looks like plpgsql function names are all getting truncated at 31
characters whenever the length is longer than that.  I am using
PostgreSQL 7.0b3.  I assume this will cause problems (am I right?)
Also, is there an easy way around this? (like maybe recompiling
Postgres with different parameters?)

Collapse
Posted by Ben Adida on
The truncation will not be a problem, because other places where you use the identifiers will also result in the same truncation. There are still some errors due to things that still need to be ported, and you should definitely report these at our bug tracker (follow the link from the front page, use beta3 as the version you're reporting to if you got the latest CVS).
Collapse
Posted by Mike Slack on
Oh, good, thanks.
Collapse
Posted by Don Baccus on
For those who care, the 31-char truncation can be increased via a compile-time define.  No need for the ACS, thus far at least there are no identifiers in the system that actually clash in the first 31 characters, and if we find some I'd recommend we make them unique when truncated so folks don't HAVE to increase this limit.

But, I thought I'd point out that increasing it is possible, since Mike asked specifically.