Forum OpenACS Development: truncated postgres identifiers

Collapse
1: truncated postgres identifiers
Posted by Mark Aufflick on 01/28/03 05:19 AM
Hi All,

while trying to find an error in my postgres server log, it occurred to me that life would be easier wiuthout 2056 instances of the lines:

NOTICE:  identifier "workflow_case__sweep_timed_transitions" will be truncated to "workflow_case__sweep_timed_tran"
NOTICE:  identifier "workflow_case__sweep_hold_timeout" will be truncated to "workflow_case__sweep_hold_timeo"

since workflow is part of the core install, and it seems to be the only offender in most instances, maybe these two names could be shortened.

unless anyone disagrees, i'll do a global find replace and post the successful patches

Collapse
2: Re: truncated postgres identifiers (response to 1)
Posted by Lars Pind on 01/28/03 05:24 PM
Please do.

Note, though, that acs-workflow is no longer part of a default OpenACS install, and that the new workflow package won't have this problem (Mohan's fixing this for us right this moment ;))

/Lars

Collapse
3: Re: truncated postgres identifiers (response to 2)
Posted by Mark Aufflick on 01/29/03 03:25 AM
I patched the files:

sql/postgresql/workflow-case-package-body.sql:2
tcl/workflow-procs-postgresql.xql:2

and uploaded the bug/patch:

https://openacs.org/bugtracker/openacs/bug?bug_number=188

I only changed the plpgsql function names, and a grep over the whole packages directory showed that no other packages used the plpgsql functions directly.