linked server connection for postgres table in SQL does not display new colum,

Hi,

There is a weird issue while retrieving data using linked server connection for postgres table with a pgnp driver in SSMS

A new column with datatype double precision was added to postgres table recently but it does not reflect while queried in linked server connection

select * from OPENQUERY(servername, 'select  *  from tblname');

 0 result (table does not reflect new column and no data displayed)

However if i use a cast function for the column i am able to see result

select * from OPENQUERY(servername, 'select cast(newcolumn as float)  from tblname');

Any idea what is going on ?


Thanks