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.

learn more… | top users | synonyms (3)

3
votes
0answers
83 views

Raise error when date is not valid

What I'm trying to do is to raise out of range error in case of dates outside of the supported range like what typecasting does. I'm using PostgreSQL-9.1.6 on CentOS. The issue is below... ...
3
votes
0answers
44 views

Cancel Rails DB connection

I am writing an app that uses Server Side events with ActionController::Live. It is using the puma app server. A method in the Messages controller stays alive while the user is connected waiting for ...
2
votes
0answers
57 views

How to make an array sum of month from Postgresql query to Rails 3

I'm new in programming but here's the thing: I'm trying to make rails app which takes data from postgresql database and shows summary in jqPlot chart, but I am having trouble with my queries. I need ...
2
votes
0answers
152 views

SQLAlchemy ─ Mapping a Class against Multiple Tables

# ! /usr/bin/env python # -*- coding: utf-8 -*- # login_frontend.py """ Python 2.7.3 Cherrypy 3.2.2 PostgreSQL 9.1 psycopy2 2.4.5 SQLAlchemy 0.7.10 """ I'm ...
2
votes
0answers
87 views

Chef-solo installs wrong version of postgresql

My question is extremely similar to this one, I'm also trying to install PostgreSQL with chef on a Vagrant VM(ubuntu 12.04). I also use Opscode postgresql cookbook. But I don't think that marked ...
2
votes
0answers
53 views

Postgresql query exception will drop connection to database

So, I got this problem. I'm using JDBC, and every time if query get SQL exception and I/O error, the connection to pgsql database will be dropped automatically. As a result, I have to check if the ...
2
votes
0answers
116 views

Propel PostgreSQL Migration unable to find adapter

I am trying to use migrations for the first time on my in-development Propel project (so I don't have to re-insert 15MB of data), but am having some difficulties. I made the changes in my schema and ...
2
votes
0answers
100 views

Calling a stored procedure in Postgresql through F# and Npgsql

I am trying to call a stored procedure in postgresql from F# using the Npgsql type provider. Currently, I am connected to the database as follows: open System open System.Data open ...
1
vote
0answers
11 views

how to use composite data types (e.g. geomval) in SQLAlchemy?

I'm trying to replicate a nested raw PostGreSQL/PostGIS raster query using SQLAlchemy(0.8)/GeoAlchemy2(0.2.1) and can't figure how to access the components of a geomval data type. It's a compound data ...
1
vote
0answers
46 views

Compare queries on PostgreSQL and MySQL

Have a nice day! On Windows Azure On Small VM with Debian 7.1 I installed MySQL 5.5.31 and PostgreSQL 9.2.4. Insert and Select queries will make from php via pdo. Creating table: MySQL: CREATE ...
1
vote
0answers
21 views

Calculation average costing using with recursive sql (postgres 9.1)

The closest thing I got from searching this site is this : Inventory Average Cost Calculation in SQL But unfortunately it was oracle specific, using model clause. So let's begin. There are two ...
1
vote
0answers
18 views

How to create 2 node Active/Active postgresql cluster in Ubunutu

I want to create a two node postgresql cluster which runs in Active/Active mode. How can I do this in Ubuntu?
1
vote
0answers
9 views

ecpg can't find includes unless executed from the directory containing the source files

ecpg can find EXEC SQL INCLUDE header files just fine when run from the directory containing the source, but not from any other directory. Here is an illustration. Successful compile: > ecpg -o ...
1
vote
0answers
39 views

Informix to Postgres, continuous data replication algorithm

The master server is Informix, version varies from 9.40 to the latest, database is unlogged by design that can't be changed. Slave server is the latest PostgreSQL. Master and slave are separate ...
1
vote
0answers
9 views

Running Qi4j 2.0 in production?

Is there anyone using the Qi4j 2.0 framework in production? Especially with a Posgresql entitystore? I'm completely re-building a web application and I love the concept of DDD. So I decided to use ...

1 2 3 4 5 … 46
15 30 50 per page