On Wednesday, April 6, 2016 at 1:46:26 PM UTC-7, [email protected] wrote: > > Hi, > I am a newbie. Just started using Sequel with my Ruby framework. > > This is the code I am using to connect to postgress database hosted on a > remote server from my Mac terminal. I have made changes to postgres.conf > and added the my Mac's IP address to to hba_ > > require 'rubygems' > > require 'sequel' > > > begin > > DB = Sequel.connect(:adapter=>'postgres',:host=>'10.x.x.x', :port=> > '5432', :database=>'dbname',:user=>'myUser',:password=>"" > > dataset = DB['select data_types_id from priorities_type'] > > dataset.count > dataset.map(:data_types_id) > end > > I am getting the error mentioned below > > "async_exec': PG::CantChangeRuntimeParam: ERROR: parameter > "standard_conforming_strings" cannot be changed > (Sequel::DatabaseConnectionError) > > from > /Library/Ruby/Gems/2.0.0/gems/sequel-4.33.0/lib/sequel/adapters/postgres.rb:186:in > > `block in execute_query' >
Add :force_standard_strings=>false to your database options. I'm not sure why you are getting that error message, though, must be something different in your PostgreSQL configuration. 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.
