Tagged Questions

3
votes
0answers
38 views

PG::Error: ERROR: relation “users” does not exist on Heroku

I'm experiencing a very odd error, only intermittently. I just completed an upgrade from Rails 3.0 to Rails 3.2. The 3.0 app has been running on Heroku's Bamboo stack, and concurrent to the upgrade, ...
2
votes
0answers
15 views

Rails test database getting wrong column type on geographic columns

We have a rails app that uses postgis and activerecord-postgis-adapter for geographic information search. However, it doesn't work right in the test database. In development and production database, ...
1
vote
0answers
29 views

Rails item feed of distinct items shared by users followed by the current user

So I'm trying to make a feed of items in which the items are distinct, and each item can be shared by many users. My data model is: User: has_many :postings, has_many :products, :through => ...
1
vote
0answers
32 views

Why does Rails change the time returned from a Postgres function to UTC?

Can anyone explain this? It is as if Rails is overriding Postgres and telling it to work in UTC when I want it to work in my local timezonw? I have a Postgres function which returns the local time as ...
0
votes
0answers
13 views

rails/postgresql: daily voting, results for time periods

Given there's a model named 'Topic' and a model named 'User'. There's a static model 'Statement' that has a predefined set of records. User is able to create Topics and set variable number of ...
0
votes
0answers
20 views

Text array column in Postgresql throwing type cast error after deploying to Heroku

I am developing a simple blog site app using Rails 4, and am running into a database issue on the production side. The Post model for my app has a :tags column, in which I have been using PostgreSQL's ...
0
votes
0answers
9 views

trigram search returning <PgSearch::ScopeOptions::DisableEagerLoading:0x3fce0aef3130>

In my NewContact model, I have the following: pg_search_scope :contact_from_search, :against => [:first_name, :last_name, :email], :using => { ...
0
votes
0answers
24 views

PG::Error EOF detected on Heroku Cedar, rails 3.2.11

Having experienced a few periods of downtime, we've recently upgraded to a production environment in Heroku (Crane database plus 2 x web dynos) however we've seen no improvement. In fact reliability ...
0
votes
0answers
26 views

Rails + PostgreSQL: How Do I save TimeStamp Values?

I'm building an API on Rails w/ Postgres, and users will be sending GET, POST & PUT requests of timestamps. I will not be handling timezones. It's up to the users to submit in UTC. So, what ...
0
votes
0answers
20 views

Datamapper:Heroku (Sinatra) DataObjects::SyntaxError - ERROR: relation “jobs” does not exist

I am writing a Sinatra DB based app with Datamapper and deploy to heroku. This is the model: class Job include DataMapper::Resource property :id, Serial, :key => true property :user_id, ...
0
votes
0answers
17 views

activerecord uncached method not working for postgresql

I have a rails app that uses postgresql and I want to temporarily disable query caching for the purpose of testing my query times. The following solution works for sqlite database, but i have been ...
0
votes
0answers
60 views

rails g scaffold! uninitialized constant in development environment

I got my ror development environment setup on ubuntu 10.04, using postgresql database. I was doing a test to generate a scaffold when I got: <module:AppName>: uninitialized constant ...
0
votes
0answers
24 views

MYSQL migrating to Postgres issues- cache type wrong

I am trying to convert my MYSQL db to postgres for Heroku. I am getting this error. query': Query cache is disabled; restart the server with query_cache_type=1 to enable it (Mysql::Error) When I ...
0
votes
0answers
15 views

Heroku: Database serialized field bug after deploy

I think everything is properly configured for a database serialized field to work as expected. It's working indeed, in local development environment. In Heroku production though, reading the ...
0
votes
0answers
22 views

Rails apartment switch schema per session

I have an application, where every user has to have his own schema in postgres database. Now I use apartment gem, but it allows just to switch schema globally per whole application, not per every ...

1 2 3 4 5
15 30 50 per page