Tagged Questions

0
votes
0answers
59 views

Failed to connect to database - can't push PostgreSQL database to heroku

I created a very simple blog app with a couple of entries and all I'm trying to do is push it to heroku, but I get the following error: $ heroku db:push [[email protected]:appname/blog.git] Loaded Taps ...
1
vote
1answer
161 views

No operator matches the given name and argument type(s)

I set up my Rails 3.2.x app to use PostgreSQL HStore but I'm getting an error. It looks like the hstore extension hasn't been picked up by the environment. I already rebooted my machine, checked ...
2
votes
1answer
297 views

Not able to install pg gem on Ubuntu 12.10

I am using Ubuntu 12.10 64-bit and I have following packages installed : dpkg --get-selections | grep postgre output: postgresql postgresql-9.1 postgresql-client postgresql-client-9.1 ...
0
votes
1answer
58 views

How to store only the time in the database?

I'm using rails 3, I want to store start_time and end_time. Since rails does not support date ranges. which data type should I use to store the time without the date to later make comparisons? This ...
2
votes
3answers
535 views

Rails App Won't Start in Production Environment because of ActiveRecord

I have repeatedly tried to setup my rails app on an ec2 instance using nginx and unicorn. I have found that both nginx and unicorn are set up properly; however, on both machines my rails app does not ...
2
votes
1answer
193 views

Prepared Statements Already Exists

I am trying to use the prepared statements in ruby with pg gem. This is how my statement looks like conn.prepare("insert_values", "insert into " + objectName + "(" + headerStr + ") values (" + ...
1
vote
2answers
142 views

Escaping apostrophe in Ruby

I am trying to escape a single quote in a ruby string. I am using this string as a insert query to push data into the postgresql. The query that will be generated looks something like this:- str = ...
0
votes
2answers
130 views

Non-auto-increment rails/postgresql column

I'm trying to have a model/table with duplicate information in it. The reason for this is so that the same data can be written to the table under different users and found for each user. However, I ...
1
vote
0answers
83 views

What are the Dev Stack Choices for an API and Website for developer branching out from .Net with side project? [closed]

I'm a developer who is doing a side project that I'm tentatively scoping out as involving a data store (probably use a relational db), a restful api (probably 90% reads, 10% writes), with an ...
0
votes
1answer
133 views

Why my ruby application works locally and does not run on Heroku?

I have a Ruby 1.8.7 application that works correctly locally. To load it on Heroku, I changed the database from SQLite to PostgreSQL, install PostgreSQL 9.1.3, I changed the Gemfile replacing gem ...
1
vote
1answer
656 views

How to I insert an array into a Postgresql table using ActiveRecord?

I have active_record setup to use a Postgresql database. One of the columns is a character varying[] (basically a varchar array). Anyway, my import routine then reads a tab-delimited text file and ...