Start a new topic

error when using dblink

[This topic is migrated from our old forums. The original author name has been removed]

I am trying to run a query which uses dblink but I get the following error: 15:31:31 [SELECT - 0 row(s), 0.046 secs] [Error Code: 0, SQL State: 08006] The server's DateStyle parameter was changed to Redwood, SHOW_TIME. The JDBC driver requires DateStyle to begin with ISO for correct operation. ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.046/0.000 sec [0 successful, 0 warnings, 1 errors] I don't get any error instead when I run it from command line. Both my database and the one I'm trying to connect to are postgresql. What is the reason of this error? Thanks a lot! Erica
1 Comment

[This reply is migrated from our old forums.]

Re: error when using dblink
Hi Erica, These messages are generated by the JDBC driver or the database, and not by DbVisualizer. I'm afraid you need to ask for help in the PostgreSQL forums as this is not a problem we are familiar with. Please let us know what you find in case someone else runs into this problem. Best Regards, Hans