New discussion topic on DataCleaner's online discussion forum (https://datacleaner.org/forum):
David posted the subject 'Can't query postgresql 10 db' ------------------- Hi, I've just downloaded DataCleaner community edition to try it out. I could create a new connection / datastore to my postgres db and the Test connections is successful. I then create a new job and this is where the issues start. I can see all my db tables fine. when adding one of these and try to preview data, I get an error: An unexpected error occurred while building data set: Could not execute query: ERROR: zero-length delimited identifier at or near """" Looking at the postgres log it seems the schema qualifier is missing from the query: SELECT "somestuff" FROM ""."at_applicants" The same issue occurs when I try and link to any analyses components or create an ad hoc query on any of the DB tables. The ad-hoc query that gets generated looks as follows: SELECT * FROM .at_applicants a Once again the schema qualifier is missing, and gives the same error. Adding it manually also doesn't work and gives a new error: Not capable of parsing FROM token: dc.at_applicants a Any ideas what the issue here is? p.s. just tested connecting to an older postgres 9 server, and the connetion and preview of data worked fine. Is postgres 10 unsupported at this moment or is there some other other incompatibility to be aware of? Thanks and regards! David ------------------- View the topic online to reply - go to https://datacleaner.org/topic/2905/Can%27t-query-postgresql-10-db -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
