Re: backend process crash - PL/pgSQL functions - parsing problem?

damonhart@yahoo.com (Damon Hart) writes:
> The postgresql log indicates that the backend is crashing with
> SIGSEGV. This is postgreSQL 7.2 running on Linux (Intel, roughly
> Mandrake 8.2)

> I adjusted whatever came to mind in the functions themselves until,
> just by luck, I found that if I shortened the length of the function
> names, the crash disappeared.

I think this is probably due to this bug:

2002-05-05 13:38  tgl

    * src/pl/plpgsql/src/pl_funcs.c (REL7_2_STABLE):
    plpgsql_dstring_append was broken for long strings.

If so, updating to 7.2.2 or later should fix it.

            regards, tom lane