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

1: Truncation errors when loading data model

Posted by Mike Slack on 04/02/00 07:02 PM

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

2: Response to Truncation errors when loading data model (response to 1)

Posted by Ben Adida on 04/02/00 07:07 PM

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

3: Response to Truncation errors when loading data model (response to 1)

Posted by Mike Slack on 04/02/00 07:11 PM

Oh, good, thanks.

4: Response to Truncation errors when loading data model (response to 1)

Posted by Don Baccus on 04/03/00 01:04 AM

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.