Re: Unrecognized Node Type Warning

2023-05-18 Thread Arora, Nick
To provide more complete information: Here is the name and version of each extension we have installed: azure (1.0) btree_gin (1.3) citext (1.6) pgcrypto (1.3) plpgsql (1.0) uuid-ossp (1.1) This email and any attachments thereto may contain private, confidential, and privileged material fo

Re: Unrecognized Node Type Warning

2023-05-18 Thread Arora, Nick
Hello Tom, Thanks for the information. Here are the extensions we are using: uuid-ossp pgcrypto citext btree_gin The warnings did start emitting shortly after the installation of btree_gin, so it seems somewhat suspect From: Tom Lane Date: Thursday, May 18, 2023 at 11:30 AM To: Arora, Nick

Unrecognized Node Type Warning

2023-05-18 Thread Arora, Nick
We are using PostgreSQL 12.13. We are noticing that queries that attempt to retrieve an element of an array by specifying its position cause a warning to be emitted: "WARNING: unrecognized node type: 110". Would appreciate your help diagnosing the issue and identifying steps to resolve. Queri