Tried that but then I get another error [1]. It seems though that since they don't support any of the schema commands it will be trouble anyway. Not sure how much Sequel uses that though.
[1] /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 DB : (Sequel::Postgres::Database) #<Sequel::Postgres::Database: "postgresql://root@localhost:36350/bank"> /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: "STANDARD_CONFORMING_STRINGS" (Sequel::DatabaseConnectionError) from /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 `block in execute_query' from /usr/local/var/rbenv/versions/2.2.2/lib/ruby/gems/2.2.0/gems/sequel-4.34.0/lib/sequel/database/logging.rb:35:in `log_yield' On Thursday, May 5, 2016 at 4:26:27 PM UTC-6, Jeremy Evans wrote: > > On Thursday, May 5, 2016 at 3:04:29 PM UTC-7, Adrian Madrid wrote: >> >> Has anybody had any luck connecting to a cockroachdb [1]? I can't seem to >> shake issues with the connection: >> >> /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=1 >> DB : (Sequel::Postgres::Database) #<Sequel::Postgres::Database: >> "postgresql://root@localhost:36350/bank?sslmode=disable&force_standard_strings=f&client_min_messages=1"> >> /usr/local/var/rbenv/versions/2.2.2/lib/ruby/gems/2.2.0/gems/sequel-4.34.0/lib/sequel/adapters/shared/postgres.rb:674:in >> >> `connection_configuration_sqls': Sequel::Error: Unsupported >> client_min_messages setting: 1 (Sequel::DatabaseConnectionError) >> > > From the error message, you could try using: > postgresql://root@localhost:36350/bank?sslmode=disable&force_standard_strings=f&client_min_messages= > > 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.
