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.
3
votes
0answers
48 views
numeric field overflow - which field exactly?
In case of an error:
PG::Error: ERROR: numeric field overflow
DETAIL: A field with precision 2, scale 2 must round to an absolute value less than 1
How do I configure postgres or ...
3
votes
0answers
77 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
35 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
134 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
81 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
50 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
111 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
97 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
Saving file to database in vaadin
Hello I am trying to save a file into my database using vaadin. I have a web application which allows the user to upload a file, so far the file uploads to my filesystem. Here is my code for the ...
1
vote
0answers
7 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
vote
0answers
32 views
Structure similiar to MYSQL_ROW of MySQL in PostgreSQL?
I recently downloaded a source package from a website which mentioned that its compatible with PostgreSQL and MySQL database.
I tried compilation on Linux Debian machine using MySQL and it works ...
1
vote
0answers
24 views
Redmine on heroku rake error
I am trying to deploy redmine on heroku. While trying to rake db:migrate I get following error:
[desktop:~/redmine-2.3]$heroku run rake db:migrate
Running `rake db:migrate` ...
1
vote
0answers
25 views
gevent and posgres: Asynchronous connection failed
I'm using gevent to handle API I/O on a Django-based web system.
I've monkey-patched using:
import gevent.monkey; gevent.monkey.patch_socket()
I've patched psychopg using:
import psycogreen; ...
1
vote
0answers
28 views
standard file format(s) to represent database schemas
Is there any standard or at least very common file format to serialize the schema of a database? It seems that every db schema tool comes with its own file format for this to list tables, their ...
1
vote
0answers
15 views
How to handle user timezones preference with Django PostgreSQL?
I am new to Django timezones. I need my users to select their timezone from a list so I can store it in PostgreSQL database. My questions are:
What is the best way to generate a list of timezones ...
Related Tags
ruby-on-rails × 84sql × 78
database × 45
java × 38
heroku × 36php × 33
python × 31
postgis × 26
django × 26
hibernate × 26
postgresql-9.1 × 24
ruby-on-rails-3 × 23
ruby × 19
mysql × 18
postgresql-9.2 × 15
jdbc × 11
spring × 11
stored-procedures × 9
pgadmin × 9
triggers × 9
postgresql-8.4 × 9
osx × 8
node.js × 8
jpa × 8
database-design × 7
