Forum OpenACS Development: truncated postgres identifiers

Collapse
Posted by Mark Aufflick on
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
Posted by Lars Pind on
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
Posted by Mark Aufflick on
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.