On Tuesday, June 2, 2015 at 9:43:53 AM UTC-7, mamesaye kane wrote:
>
> It seems like the search path is not working...
>
> I just added it to the tables in the query and removed it from the
> connection
>
> OLD_DB = Sequel.connect(:adapter=>'postgres', :host=>'localhost', :
> database=> 'newscold', :user=>'USERNAME', :password=>'PASSWORD')
>
> The query is working now
>
> nc_items = OLD_DB.fetch("select count(*) from sitecontent.items i left join
> sitecontent.item_sites iis on i.id = iis.item_id left join sites s on
> iis.site_id = s.id " )
>
>
> puts "the number of newscold items that will be migrated is
> :#{nc_items.first[:count]}"
>
>
First, which version of Sequel are you using? Second, you can post an SQL
log with the search_path option used (add :logger=>Logger.new($stdout)
option)?
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 http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
