Hi
st 16. 11. 2022 v 19:01 odesílatel shashidhar Reddy <shashidharreddy001@xxxxxxxxx> napsal:
Extension version is 2.2. Is anything need to be done? To fix this issue?On Wed, 16 Nov, 2022, 10:06 pm Tom Lane, <tgl@xxxxxxxxxxxxx> wrote:shashidhar Reddy <shashidharreddy001@xxxxxxxxx> writes:
> I could see an error in syslogs, I am not sure what it means.
> kernel: [93631.415790] postgres[86383]: segfault at 80 ip 00007f07f3e3eefd
> sp 00007fffcf1db500 error 4 in plpgsql_check.so[7f07f3e2e000+34000]
That would certainly suggest a problem in plpgsql_check.
It might or might not be related to the node-type error.
The extension plpgsql_check does not contain this message. More in typical usage, the plpgsql_check is not active at runtime (but it depends on usage).
Node with number 350 should be ParamRef
Can you show source code of functions that fail? Can you show plpgsql_check configuration?
Regards
Pavel
regards, tom lane