Jeremy, Thanks for the suggestion. By adding the line ':force_standard_strings=>false' to my database connection string I got the database connected successfully . BTW curious to know how this 'force_standard_strings' work.
On Wednesday, April 6, 2016 at 2:11:08 PM UTC-7, Jeremy Evans wrote: > > On Wednesday, April 6, 2016 at 1:46:26 PM UTC-7, [email protected] > <javascript:> 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.
