\dp option is throwing error in pSQL version 15.1.0.

Products

• VMware Tanzu for Postgres
• VMware Tanzu SQL
• VMware Tanzu Data Suite

Issue/Introduction

You might see below error trying to use below command:

[testdb]> \dp test.databasechangeloglock 
ERROR: operator is not unique: unknown || "char" LINE 16: E' (' || polcmd || E'):' 
^ HINT: Could not choose a best candidate operator. You might need to add explicit type casts.

Environment

VMware Tanzu Postgres

Resolution

+ DBeaver fix for this was patched in DBeaver 22.3.1.

+ Beyond that, this error is caused by a mismatch between the client and server binaries. This is especially common when there are multiple sets of binaries and isn’t using the latest one.

+ Using a pg14- psql binary with a pg15+ server leads to this exact issue, for example - If the client isn’t sure which binaries are being used,

check the result of this query: 

run mspsql —version