linked server: certain tables giving problem: An extra colum

  • Visitor
  • Visitor
12 years 3 months ago #4399 by
I'm getting this same/similar error: "ERROR: bind message has 7 result formats but query has 6 columns " whenever I reboot my server. I've tried executing the EXEC('pgnp_refreshmetadata('''',''remotetablename'')') AT REMOTESERVER ; on my SQL Server 2008 box, but it has no effect.

As inferred, I'm running Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64), the PGOLEDB driver is a 64-bit, v1.3.0.2257 and the PostGres server is PostgreSQL 8.3.8 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.3.2 20081105 (Red Hat 4.3.2-7).

Most of the time, the error would almost cure itself and we're not sure why. Whether it was running the queries manually through a query analyzer or dropping and re-adding the linked server or some other random act. Currently we're experiencing random failures where one time a query runs and it works, other times it runs and generates the aforementioned error.

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

More
12 years 2 months ago #4419 by Moderator
Does this error happen after a table schema change? How often it happens?

Please send more details to support.

Thank you!

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

Time to create page: 0.142 seconds
Powered by Kunena Forum