Tagged Questions
PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for many platforms including Linux, UNIX, MS Windows and Mac OS X. Please mention your PostgreSQL version when asking questions.
0
votes
0answers
2 views
How should column-level PostgresSQL encryption implemented in SQLAlchemy using pgcrypt?
For example, there is a repo for doing this in Django: https://sourcegraph.com/github.com/dcwatson/django-pgcrypto.
There is some discussion in the SQLAlchemy manual, but I am using non-byte columns: ...
0
votes
0answers
6 views
Set postgres DateStyle GUC on connect (Laravel ORM)
In postgres, I simply want to set the date format every in my application when it connects. I'm using laravel 4 and RDS. I could simply change it in the database config, but it appears that RDS ...
0
votes
1answer
11 views
Why does this PostgreSQL full-text search break on a different (RDS) server?
On several development servers, this query has returned expected records:
SELECT name, name_tsv FROM vision
WHERE name_tsv @@ plainto_tsquery('Washington Square Park');
name_tsv was originally ...
0
votes
0answers
12 views
Npgsql returning no result and PgAdmin does
I have an issue with Npgsql.dll.
The code below returns me no results.
If I take the sqlString and paste it into PgAdmin after the parameters has been added, then I get the correct result.
// ...
1
vote
0answers
9 views
Manage Connection Pooling in multi-tenant web app with Spring, Hibernate and C3P0
I'm trying to setup a multi-tenant web application, with (ideally) possibility for both Database-separated and Schema-separated approach at the same time. Although I'm going to start with Schema ...
0
votes
0answers
19 views
calculate total minutes between two timestamps across multiple records using postgresql
I have a postgresql 9.1 table with 2 timestamps that record time periods that may overlap. Example:
ID Start End
1 2014-01-19 21:14:59+00 2014-01-19 21:30:00+00
1 ...
-1
votes
0answers
19 views
Drupal 7, PDOException: SQLSTATE[25P02]
After migrate from mysql to PostgreSQL (DBTNG Migrator module) i get errors:
PDOException: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until ...
1
vote
1answer
24 views
bugzilla can't connect to postgres server [Resolved]
I just installed bugzilla-4.4.1 on version 6.4 of Scientific Linux, and I'm having problems connecting to the database (Pg version 8.4).
When I try to fetch the main page (index.cgi), I get the ...
0
votes
0answers
7 views
heroku pg:pull password authentication failed
I'm trying to run the heroku pg:pull command, but I can't seem to get the amazingly cryptic authentication process.
The command I'm running:
> heroku pg:pull app_name::RED localdb
I then get a ...
0
votes
1answer
21 views
PostgreSQL, one-to-many query, without duplicating the one?
Is there a good way to return, in a single query, a one-to-many relation, without sending duplicates of the fields for the tuple on the one side? Say you have two tables with a typical 1-to-many ...
0
votes
0answers
10 views
Jelastic restore PostgreSQL base - Postgres extensions does not exist
I try to restore my base by manual (http://docs.jelastic.com/ru/dump-postgres.), but I have some errors.
ERROR: could not open extension control file
...
0
votes
1answer
14 views
ActiveRecord::StatementInvalid in Home#index
I'm trying to open a local project in ruby using some old files (of another project) and I'm getting this error. My problem is that I don't have that table in my db.
This is the error:
...
0
votes
1answer
15 views
Postgres Fill In Empty Data When Aggregating
In Postgres I am aggregating a total amount, separating days, and then dumping that data into chart. Example query looks like this:
SELECT
EXTRACT(YEAR FROM post_created_date) as report_year, ...
0
votes
0answers
27 views
NodeJS hangs indefinitely after multiple requests
I have a nodeJS(v.0.10.23) proxy connecting to a postgres db (node-postgres module v2.1.0) which returns all sorts of json data.
Back in the day, this is how connection errors were handled:
var ...
0
votes
0answers
16 views
How to write Timestamp with Before Christ date in PostgreSQL via jdbc?
I've tried to write the date Before Christ in PostgreSQL with PreparedStatement and failed.
Are there any tricks to do this?
The field in Postgres is TIMESTAMP WITHOUT TIME ZONE.
When I tried to ...
