PostgreSQL is an open source object-relational database system that has the features of traditional proprietary database systems with enhancements to be found in next-generation DBMS systems. PostgreSQL is free and the complete source code is available. This tag should be used for questions about ...
1
vote
1answer
28 views
VBA Heroku integration?
I am wondering what might be involved in connecting an Excel VBA application to the hosted database behind a Heroku Ruby on Rails application. Is this possible? My application cannot accomplish all of ...
1
vote
0answers
24 views
How to merge two database copies (postgresql)
I have two versions of the same database. One is current and the other one has been restored from a backup. Now I need to merge them to basically move the data from the backup into the current ...
0
votes
0answers
18 views
How to get Postgresql 9.1.3-1 to work on Aptana 3.1?
I've downloaded Mac OS X lion, Updated Xcode to 4.1, Currently have Ruby 1.9.2 and rails 3.1.8. Currenlty using Aptana 3.0 and i'm trying to do rake db migrate but it's not generating database ...
0
votes
1answer
117 views
Rails: rake db:create:all fails to connect to PostgreSQL database
I am trying to create a Rails app that uses PostgreSQL. Here is a description of what I did.
PostgreSQL setup:
I installed PostgreSQL 9.1.3 via the ppa:pitti/postgresql maintained by Martin Pitt. ...
4
votes
1answer
48 views
Use “database users” to authenticate in Ruby on Rails
I have a PostgreSQL database that I access from various locations, and would like to add an interface with Ruby on Rails 3. For authentication I need to login users with the same credentials used to ...
1
vote
0answers
79 views
rails 3 dumping PostgreSQL database into schema.rb ignores primary keys
rake db:schema:dump
Changes:
create_table "accounts", :force => true do |t|
...some columns...
end
Into:
create_table "accounts", :id => false, :force => true do |t|
t.integer ...
2
votes
1answer
78 views
ActiveRecord column does not exist
I have a Rails app using a Postgres database with a table called geolite_blocks. If I call ActiveRecord like this:
GeoliteBlock.find_by_startIpNum 2776360991
The query works perfectly. However, if ...
0
votes
1answer
78 views
Saving time in Ruby on Rails to a Postgres database
I have been having an issue getting the right time to be saved in my database. If I do SELECT NOW() in postgres I will get the right time in EDT. When I do a Time.now in the ruby console I get the ...
0
votes
2answers
423 views
rspec returns “PG::Error: ERROR: relation ”table_name“ does not exist”
Environment is REE(2011.12) on rvm, rspec 2.8.0, rails 3.0.6, and pg 0.13.2. Using PostgreSQL 8.3.17 on CentOS 5.6. The db:migrate have work correctly. But rspec have got following error.
1) ...
0
votes
2answers
72 views
Insert or update postgresql en mass
I have 16000 items in a ruby hash. (downloaded as XML and converted to hash)
I need to push these into the database.
Once a week some of them change, but I can't tell which ones.
What I've seen ...
0
votes
2answers
68 views
Postgres: creating a username
I'm trying to get started with Postgres on Rails apps on Mac. I made a new rails app called "shawsome" and in the database.yml file it created this
development:
adapter: postgresql
encoding: ...
0
votes
3answers
243 views
Rails: Sqlite with PG gem
I installed postgres on my Mac and tried it for the first time with Rails. I included gem "pg" and removed the sqlite3 gem (after all, why would you need the latter if using the former). However, when ...
3
votes
2answers
209 views
Heroku db:push fails with segfault
I am installing a new Heroku app for Rails 3.1, Ruby 1.9.2. The problem is in doing 'heroku db:push' to populate the database (which has been duly schematized--the only problem now is getting it some ...
0
votes
0answers
150 views
OmniAuth ActiveRecord error when pushing to Heroku
I'm having a strange situation occuring where I'm able to read and save information from a Facebook response via Omniauth when running locally, but when I push the exact code to Heroku the error below ...
2
votes
2answers
164 views
Postgres accent insensitive LIKE search in rails 3.1 on heroku
How can i modify a where/like condition on a search query in Rails:
find(:all, :conditions => ["lower(name) LIKE ?", "%#{search.downcase}%"])
so that the results are matched irrespective of ...
