Naming of colums returned from function have changed

[mc_coder]

Hi,

I have some code which calls functions in a PostgreSQL DB using SQL linked servers. When called in PostgreSQL the column name is usually the same as the function called and up until I updated to the latest version of PGOLEDB the behaviour was the same. With the latest version I know get a column name like COLUMN1. To test try the folowing:

In PostgreSQL - select version(); - you should see a column called version
In SQL Server using a linked server - select * from OPENQUERY(LINKEDSERVER,'select version()') - you should see a column called COLUMN1

I can fix this by changing the SQL Server query to the following select * from OPENQUERY(LINKEDSERVER,'select version() as version') but I'd rather not have to do that.

Version 1.4.0.3056 was the version I was using that worked as expected. Can anyone shed some light on this?

Regards,

Martin

[Moderator]

We have fixed the bug and will publish it shortly. It will be available in any build after 3108.

Thank you! Please let us know if you notice any defect.

[mc_coder]

Thanks. I'm waiting for suppport to issue me with a fix for the other issue I reported. Will this fix be included in the build?

Regards,

Martin

[Moderator]

We sent "unofficial" build 3110 with the fixes. They will also be published "officially" shortly.