Search code examples
postgresqlcitus

citusdb ERROR: ERROR: cannot execute PREPARE for a distributed query plan

I'm just did the citusdb tutorial. And local using "psql" works fine. But when I try do the same query using native postgres jdbc I get the error:

ERROR: ERROR: cannot execute PREPARE for a distributed query plan
Query = SELECT count(*) FROM customer_reviews

Local works fine,

postgres=# SELECT count(*) FROM customer_reviews;

count

589859 (1 row)

http://www.citusdata.com/downloads

Solution

  • Well I was using RazorSQL query tool using JDBC. But I change to ODBC and now is working.