Naming of colums returned from function have changed

  • mc_coder
  • Topic Author
  • Visitor
  • Visitor
9 years 6 months ago #9851 by 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

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #9861 by 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.

Please Log in or Create an account to join the conversation.

  • mc_coder
  • Topic Author
  • Visitor
  • Visitor
9 years 6 months ago #9866 by 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

Please Log in or Create an account to join the conversation.

More
9 years 5 months ago #9871 by Moderator
We sent "unofficial" build 3110 with the fixes. They will also be published "officially" shortly.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum