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) 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 Friday, May 6, 2016 at 11:40:43 AM UTC-6, Jeremy Evans wrote: > > On Friday, May 6, 2016 at 8:39:38 AM UTC-7, Adrian Madrid wrote: >> >> 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' >> > > That's odd, you shouldn't get that if you are using > force_standard_strings=f. It looks like you might have taken that part out > even though you had it originally. With > "?force_strandard_strings=f&client_min_messages=" it shouldn't try to use > either of those queries. > > 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.
