Stack Overflow
Stack Overflow

Questions tagged [pg]

'pg' is the name of an extension for Ruby that provides access to libpq, the C application programmer’s interface to the PostgreSQL RDBMS.

pg is the name of an extension for Ruby that provides access to libpq, the C application programmer’s interface to the PostgreSQL RDBMS. It provides a relatively complete mapping, including both synchronous and asynchronous query interfaces, notifications, support for the COPY command, and m17n support under Ruby 1.9.

It includes full RDoc API documentation, a copy of which can be found on the maintainer's site.

It is currently maintained and developed by Michael Granger.

854 questions
0
votes
1 answer

gem install postgre error - Mac 10.10

Hello everyone I am trying to install postgre on my macOS: Yosemite 10.10.2 First, I am doing this because I am trying to deploy my app on Heroku that doesn't support sqlite so I made the following: group :development, :test do gem 'sqlite3' …
MrHello
  • 207
  • 2
  • 7
0
votes
1 answer

PG gem on OSX Yosemite not updating

Ruby Version 2.0.0p481 Rails Version 4.1.8 PG Version 0.18.1 I am trying to follow Heroku's Getting Started with Heroku Tutorial. Everything has worked fine until I need to run the app locally and migrate the database. The command bundle exec rake…
Josiah Palmer
  • 151
  • 1
  • 17
0
votes
1 answer

Issues running paperclip on heroku using ruby on rails

I am using paperclip for some image uploading in my ruby on rails application. Everything works fine locally. When I deploy to heroku, the upload appears to work but when I look at my item it is obvious the upload has somehow failed - see…
RenegadeAndy
  • 5,440
  • 18
  • 70
  • 130
0
votes
0 answers

Using PG in ruby on rails on windows

I have a project which uses PG in ruby on rails and its all working fine. I am now trying to setup a windows development environment for the project. I have bundle install completing, however when I run rails server I get some failures I dont…
RenegadeAndy
  • 5,440
  • 18
  • 70
  • 130
0
votes
1 answer

Mina deploy doesn't install pg gem

When mina deploy runs an error occurs during migration that pg gem is not loaded.The problem is that the gem is loaded in my gem file but during the mina's bundle install pg gem doesn't get installed. Any ideas how to fix this issue? ----->…
yns
  • 5
  • 2
0
votes
1 answer

Unable to install gem pg

I know that similar questions have been asked, but none of the solutions have worked for me. I'm running Mac OS 10.10.1. I'm using RVM and Homebrew. When I run 'gem install pg' I get the following: Building native extensions. This could take a…
user3471035
  • 1
  • 1
0
votes
1 answer

What is the performance impact of doing pg:pull on a Heroku app?

I'm interested in pulling down a 15MB database from an app that is in production but am concerned about the impact it may have on end users. Is this something that can be done without fear or best scheduled at 4am?
nicholalexander
  • 55
  • 1
  • 6
0
votes
2 answers

pg gem wont install. Using Postgress.app

I am currently using the postgress.app and trying to install pg gem for a rails project. But the problem is I keep getting the following: $ gem install pg -v '0.17.1' --…
TheWebs
  • 12,470
  • 30
  • 107
  • 211
0
votes
0 answers

NodeJS + pg plugin - error: syntax error at or near »SET«

I am using nodeJS with the pg plugin: I want to insert some data into my db, however, I am receiving the error: [Function] error running query { [error: syntax error at or near »SET«] name: 'error', length: 81, severity: 'FEHLER', code:…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
0
votes
2 answers

ROR Search virtual fields

I am just adding search to my project to be able to find people by name. but on my db i have first_name and last_name but if someone searches for a full name like Joe Doe no result matches #model class Person < ActiveRecord::Base def full_name …
user4203675
0
votes
0 answers

Ruby PG Gem: could not determine data type of parameter $1

I'm trying to define a method that takes an optional argument representing a table name and passes it to a SQL statement within that method. When I run the code in my program I get an error saying "could not determine data type of parameter $1."…
Daniel Bonnell
  • 4,817
  • 9
  • 48
  • 88
0
votes
2 answers

Import data app ruby on heroku

I have been trying to import data to my ruby on rails aplication 4.2 hosted in heroku with a database in pg. I tried this tutorial and it didnt worked: http://railscasts.com/episodes/396-importing-csv-and-excel?view=asciicast Say no method import…
user2284348
  • 43
  • 5
0
votes
1 answer

Can't install prebuilt gem

I'm trying to install prebuilt binary of pg gem on windows (I don't want devkit): >ruby -v ruby 2.1.4p265 (2014-10-27 revision 48166) [x64-mingw32] >gem install pg Fetching: pg-0.17.1.gem (100%) ERROR: Error installing pg: The 'pg' native…
Marcin Wisnicki
  • 4,511
  • 4
  • 35
  • 57
0
votes
2 answers

Cannot run "rails server" because of failure to install 'pg' in gem

I am new to ruby on rails and I just downloaded a new Rails project directory that my friend sent to me. I put that directory on the Desktop and cd into it. I want to play with the code on my local host to learn from the code. But when I tried to…
Shawn Li
  • 99
  • 2
  • 13
0
votes
0 answers

Querying postgres database with rails

I'm trying to search my database based on params from a search form. I had it working perfectly fine in SQLlite, but when I migrated to postgres, several things broke. in app/views/index.html.erb I defined a form: <%= form_tag(guidelines_path,…
John Dodson
  • 27
  • 8
1 2 3
…
56 57