pg Questions
0
I am trying to connect my API to an instance of Redshift using the 'pg' library but I get the following error:
Possibly unhandled error: SET TIME ZONE is not supported
at Connection.parseE (/Users...
Granulate asked 27/1, 2015 at 19:59
3
Solved
I have RubyOnRails 4.1.4 and PostgreSQL installed on my MacOS X by:
brew install postgresql
When I'm trying to migrate this one:
CREATE EXTENSION hstore
It gives out me an error:
PG::Undefin...
Ganesa asked 10/7, 2014 at 6:31
2
Solved
I'm converting a rails app from using mysql (mysql2 gem) to postgres (pg gem).
With mysql, ActiveRecord::Base.connection.select_value calls return values typed according to the data, for example:
...
Misdate asked 24/9, 2012 at 19:4
1
Solved
First time using pg gem to access postgres database. I've connected successfully and can run queries using #exec, but now building a simple query with #exec_params does not seem to be replacing par...
1
Solved
I'm using a PostgreSQL database with hstore extension and i'm trying to make a simplest thing possible - get all the records, which vd_data (hstore) column is empty ({}).
It sounds really easy but...
Aret asked 12/5, 2014 at 8:0
1
Solved
I'm attempting to build a ruby project which uses postgres running locally. Build fails on the pg gem install. I get this error
$ gem install pg -v '0.12.2'
Building native extensions. This could ...
Knitter asked 27/3, 2014 at 14:32
2
sorry for disturb you but i have a lot of question about this error.
first this is my user_controller rspec file
require 'spec/spec_helper'
describe UserController do
it "create new user" do
p...
Mckean asked 17/7, 2012 at 19:42
2
Solved
I'm using Ruby (not Rails) and connecting a PostgreSQL database. I've been trying to get set up on Heroku, but I'm having problems starting the application. Running the application locally works fi...
Middaugh asked 8/7, 2012 at 3:28
8
Solved
After updating to OS X 10.9 Mavericks I tried to start a Rails 3 app, but the connection to the PG database was not working. Checking on PGAdmin III, the database is still there and it works fine.
...
Tarryn asked 23/10, 2013 at 10:35
4
I have looked at the postgres documentation and the synopsis below is given:
pg_resetxlog [-f] [-n] [-ooid ] [-x xid ] [-e xid_epoch ] [-m mxid ] [-O mxoff ] [-l timelineid,fileid,seg ] datadir
...
Checkmate asked 15/10, 2012 at 14:8
4
I just installed the heroku PSQL app (v1.0) and i'm having trouble being able to connect my rails apps using the gem pg "0.1.4". I already added the path PATH="/Applications/Postgres.app/Contents/M...
Komara asked 26/7, 2012 at 22:58
1
Solved
I am using the following ruby code, with the PG gem, to return a timestamp that is in Postgres "timestamp without timezone" format. Instead of returning the current value, I would like it to return...
Keener asked 13/11, 2013 at 2:59
3
Solved
Is there a way to configure the database.yml file to connect to Heroku's Postgres remotely?
I'm having trouble understanding how Heroku, Rails and PG gem work together.
It looks like during depl...
Kokanee asked 21/10, 2013 at 4:45
1
Hi
Sometimes I need to do some SQL tuning task, I usually do such tests on my test db.
After I excute a sql statments, I want to flush the buffer cache which containing SQL
statements and sql resu...
1
Solved
I've ran a simple insert command:
INSERT INTO names (name) VALUES ('john')
As a response I get a PG::Result object. I've been digging through those docs but I can't squeeze out of that object the...
Marshy asked 25/7, 2013 at 22:41
4
Solved
I have a rails app that I am trying to get running in an Amazon EC2 instance. This app has been tested properly on various Linux, OS X and Windows systems.
On the EC2 server, I have built Postgres...
Colorimeter asked 14/6, 2011 at 23:31
1
I'm using the pg:transfer utility recommended by Heroku to push and pull databases. For example:
heroku pg:transfer -f postgres://username:password@localhost/database-name -t postgres://user-name:...
Giselagiselbert asked 1/5, 2013 at 2:8
1
Solved
Running
gem install pg -v '0.15.1'
giving errors:
Building native extensions. This could take a while... ERROR: Error
installing pg: ERROR: Failed to build gem native extension.
/home/aska...
Sarmiento asked 28/5, 2013 at 9:6
1
Solved
I'm working on building the twitter clone app in Hartl's Rails Tutorial. I cloned my git repo (https://github.com/stewartmccoy/rails_tutorial) and put code on to my personal computer, which had pre...
Garbe asked 4/4, 2013 at 4:52
2
Solved
Database noob alert:
I am trying to insert into a postgres table.
The field that I would like to insert in is called make_date.
The field type is timestamp without time zone NOT NULL,
How do I in...
Crank asked 20/3, 2013 at 17:40
1
I have the issue described in:
Repairing Postgresql after upgrading to OSX 10.7 Lion
but didn't get it solved.
The Postgres application generating the error is at /usr/bin/psql,
but the correct on...
Boodle asked 27/2, 2012 at 13:54
1
This is an extremely strange one. Im trying to do a simple rake db:test:clone or create and no matter what I do, from clearing the gemset to trying all sorts of database.yml configs, Im getting the...
Adaurd asked 11/10, 2012 at 20:25
1
Solved
I have an importer which takes a list of emails and saves them into a postgres database. Here is a snippet of code within a tableless importer class:
query_temporary_table = "CREATE TEMPORARY TABL...
Hovis asked 25/9, 2012 at 23:37
1
Solved
My database is on a different server to the application. When I run "bundle" I get the following error:
No pg_config... trying anyway. If building fails, please try again
with --with-pg-config=...
Maiamaiah asked 21/9, 2012 at 0:43
1
Solved
I have updated my bundler which contains pg gem and I got the error
An error occured while installing pg (0.14.0), and Bundler cannot continue.
Make sure that `gem install pg -v '0.14.0'` succeeds...
Angell asked 23/6, 2012 at 19:14
© 2022 - 2024 — McMap. All rights reserved.