postgresql 这是什么意思：SQL 状态：42703 上下文：名为“未命名”的 dblink 连接发生错误：无法执行查询
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2997253/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What does it mean: SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": could not execute query
提问by Z77
I tried to create exactly the same but new table from old table in another database using dblink. This procedure used to worked last two times, but this time I got message: "SQL state: 42703 Context: Error occurred on dblink connection named "unnamed": could not execute query."
我尝试使用 dblink 从另一个数据库中的旧表创建完全相同但新的表。此过程过去曾运行过两次，但这次我收到消息：“SQL 状态：42703 上下文：名为“未命名”的 dblink 连接发生错误：无法执行查询。”
Anyone knows where is the problem or how to solve it? Please!
任何人都知道问题出在哪里或如何解决？请！
回答by Ashwin Balamohan
I encountered this problem and fixed it by using single quotes, rather than double quotes, for the string I was searching for:
我遇到了这个问题，并通过对我正在搜索的字符串使用单引号而不是双引号来修复它：
select * from table where column = 'value';
回答by Tom Gullen
Here is a list of possible causes:
以下是可能的原因列表：
http://www.sqlerror.de/db2_sql_error_-206_sqlstate_42703.html
http://www.sqlerror.de/db2_sql_error_-206_sqlstate_42703.html
Best to catch the query before it is executed, then you will be able to see what exactly the problem is. If you post it here, we can help you further.
最好在执行之前捕获查询，然后您将能够看到问题到底是什么。如果您将其发布在这里，我们可以进一步帮助您。
