Thanks! Got it to connect and even create a table. Sadly cockroachdb does not support any of the standard postgres schema information.
https://gist.github.com/aemadrid/87d5b950f8e2618de9f218a6d02f7fdf I'd like to look at what it would take to get a cockroachdb adapter going. Do you have any docs on how to do that? I'll take a look at the postgres adapter but I'm wondering if you ever presented or wrote anything about making sequel adapters. Adrian Madrid [email protected] On Fri, May 6, 2016 at 2:36 PM, Jeremy Evans <[email protected]> wrote: > On Friday, May 6, 2016 at 12:42:09 PM UTC-7, Adrian Madrid wrote: >> >> You're right. I'm getting this error now but I'm not sure if >> >> /usr/local/var/rbenv/versions/2.2.2/bin/ruby -e >> $stdout.sync=true;$stderr.sync=true;load($0=ARGV.shift) >> /Users/aemadrid/code/aem/cockroachdb/test/test.rb >> >> conn_str : postgresql://root@localhost >> :36350/bank?sslmode=disable&force_standard_strings=f&client_min_messages= >> >> DB : (Sequel::Postgres::Database) #<Sequel::Postgres::Database: >> "postgresql://root@localhost >> :36350/bank?sslmode=disable&force_standard_strings=f&client_min_messages="> >> >> /usr/local/var/rbenv/versions/2.2.2/lib/ruby/gems/2.2.0/gems/sequel-4.34.0/lib/sequel/adapters/postgres.rb:186:in >> `async_exec': PG::InternalError: ERROR: unknown variable: "DATESTYLE" >> (Sequel::DatabaseConnectionError) >> > > Try adding &use_iso_date_format=f to the connection URL. > > Thanks, > Jeremy > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" 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/sequel-talk. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sequel-talk" 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/sequel-talk. For more options, visit https://groups.google.com/d/optout.
