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
2 answers

Symbol not found: _PQbackendPID with Django project

Running on MAC os 10.6.8 with postgresSQL installed, as well django - using python2.7 Also installed psycopg2 and dj-database-url using pip in my virtual env And added these two lines to my setting.py: import dj_database_url DATABASES = {'default':…
user1460961
  • 1
  • 3
0
votes
1 answer

Heroku Application Error

Application Error An error occurred in the application and your page could not be served. Please try again in a few moments. If you are the application owner, check your logs for details. $ heroku logs 2012-05-22T17:59:46+00:00 app[web.1]: => Call…
Laser
  • 5,085
  • 4
  • 34
  • 48
0
votes
1 answer

Trouble with install redmine-hudson plugin on bitnami redmine 1.4.1

everyone. I tried to install redmine-hudson plugin(1.0.8) on bitnami redmine 1.4.1. I just follow the installation guide down here. >Installing a plugin > >1. Copy your plugin directory into #{RAILS_ROOT}/vendor/plugins. If you are downloading the…
wrbae
  • 1
  • 2
0
votes
1 answer

Postgresql WHERE clause adds '' around?

This morning I switched to postgresql and now my where selects dont work anymore. What I am trying to do is super simple: shirt_ids = "1,5,6" # String generated by javascript Shirt.where("id in (?)", shirt_ids) This gives me : PG::Error: ERROR: …
Stephan1990
  • 445
  • 4
  • 19
-1
votes
1 answer

How to connect postgres database running on docker with nodeJS server using `pg` library?

I have a question regarding using the pg library to connect nodeJS with the Postgres database. I'm running PostgreSQL & PgAdmin using docker, following this tutorial. I've entered pgAdmin through http://localhost:82/, and added PostgreSQL server…
0x55b1E06FF
  • 538
  • 1
  • 9
  • 24
-1
votes
1 answer

Need to automatelist partitioning to a new table in rds postgres 12.10

Can someone guide to automate LIST partitioning to a new table in rds postgres v12.10. At runtime I can get different values of the partition key. How can U automate this
Mohit Singla
  • 15
  • 4
-1
votes
1 answer

Unable to install gem 'pg'

I am trying to bundle install a ruby-on-rails project that I cloned from bitbucket and it's getting terminated while installing pg, so I tried installing pg separately. When I run gem install pg -v '0.20.0', the following logs are shown Temporarily…
anon
-1
votes
2 answers

How to make a trigger with Rails 7 and PostgreSQL

I'm using PostgreSQL with Rails in API mode and I have a row called expired with data type Date and I want to make a trigger that identifies if the expired date is equal to the current date and change my is_expired column from false to true, but I…
Javier
  • 25
  • 7
-1
votes
1 answer

which version should i use to connect postgresql9.4.24

I attemp to use pgadmin v5, but it tips me version is not correct,Can you tel me which pgadmin version should i use to connect postgresql？thank you very much
Joy
  • 1
-1
votes
1 answer

Update database call in a map node.js pg

I have a node app and I am trying to update multiple rows in the database. I thought I could just use a map function and for each item that needs to be updated do an sql update but I am getting an error: UnhandledPromiseRejectionWarning: error:…
Kris
  • 187
  • 1
  • 2
  • 14
-1
votes
1 answer

PG Column doesn't exist for test env

I wanted to start writing tests for my application, but I get this error from PG. I have no public table and no increment_by column. Why is this error occurring?
RomanOks
  • 692
  • 3
  • 13
-1
votes
1 answer

php postgresql concat hyperlink with fields

How to concat hyperlink in php postgresql query? I tried this but confused with single and double quotes. $query = "SELECT im.id AS \"ID\", im.type AS \"TYPE\", CONCAT('Click') FROM…
mysqlrockstar
  • 2,536
  • 1
  • 19
  • 36
-1
votes
1 answer

Query works in PGAdmin but fails on the server(node \ localhost)

We are using node server and we use pg module to call to our postgres database. When making a query in pgadmin, I get the desired results, but when trying to run the same query on our server(js) it throws errors, anyone knows what can cause this and…
LittleOldMe
  • 188
  • 1
  • 10
-1
votes
1 answer

Is this pg query correct in node express.js?

I'm trying this query via pg, node, express. 'DELETE * FROM "Soggetto" WHERE Id IN "'+strID+'"' strID is a variable string with id separated by comma. Output is Error near *.
user243062
  • 15
  • 1
  • 7
-1
votes
2 answers

node express postgres - why and how to connect to database using pg module?

I am super new to node express and postgres and wondering the following: const pg=require('pg').native const client=new pg.Clirnt('postgres ...') what is const? pg is used to create a client to connect to the Postgres database-correct? If so var…
javascript2016
  • 973
  • 3
  • 17
  • 41
1 2 3
…
56
57