New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Schema inference not supported on CockroachDB #523

Open
jethrogb opened this Issue Dec 5, 2016 · 1 comment

Comments

Projects
None yet
2 participants
@jethrogb
Contributor

jethrogb commented Dec 5, 2016

Thanks to CockroachDB's protocol compatibility, it almost works out of the box. There are just some minor things that need fixing:

  • In Postgres terms, CockroachDB does not have databases. Only schemas inside a single database. This breaks inference (unless your database is named “public”).
  • CockroachDB's information_schema.columns.data_type values are different.
    • INT is diesel::types::BigInt
    • STRING is diesel::types::Text
    • (others?)

You can detect CockroachDB like so: SELECT version() LIKE 'CockroachDB%';

Of course, to make the example code work with BigInt, I also needed to change the Rust datatype in the model and code to i64.

@theduke

This comment has been minimized.

Contributor

theduke commented Apr 29, 2018

Duplicate of #1134, so one of them can be closed.
This issue is older, but the other one has more disussion.

@theduke theduke referenced this issue Apr 29, 2018

Closed

CockroachDB support: tracking issue #1667

0 of 3 tasks complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment