Just had a linked server added (from PGADMIN) in SSMS which when we try to access the tables gives us the error in the screenshot. Our report server is in SSMS so any data that is held in PGADMIN that re require, we use OPEN QUERY to pull this through.
I've found a potential fix for the error by going into the odbc connection and adjusting character length
My question is... will changing this on the linked server have an affect on any current stored procedures/OPEN QUERIES we have that are using the tables from PGADMIN?