PostgreSQL is a powerful, open source object-relational database system. Open source since 1996, it has a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. Standards compliance is a major focus of the development team. Postgres runs on all ...
9
votes
0answers
342 views
pypy django and postgres
I know that pypy and django play nice together, but I am less certain about pypy and postgres. I do see that alex has made a fork of pypy called pypy-postgresql. I also know that some people are using ...
7
votes
0answers
118 views
Ebean looks for wrong sequence name in Play Framework 2
I have an id:
@Column(name = "device")
@GeneratedValue(strategy = GenerationType.AUTO, generator = "device_gen")
@SequenceGenerator(name = "device_gen", sequenceName = "device_id")
@Id
public Integer ...
4
votes
0answers
314 views
Broken brew-installed postgresql on lion
I know there are a lot of lion-postgresql related questions on stack overflow already, but none seem to solve my problem.
I installed the homebrew of postgresql and everything was fine after that. ...
3
votes
0answers
154 views
How does shortest path work in pgrouting?
I'm trying to find how the implementation of shortest_path() in pgRouting works.
This is the function definition:
CREATE OR REPLACE FUNCTION shortest_path(sql text, source_id integer,target_id ...
3
votes
0answers
186 views
Strategies for “Always-Connected” Windows Client Data Architecture
Let me start by saying: this is my 1st post here, this is a bit lenghty, and I havent done Windows Forms development in years....with that in mind please excuse me if this isn't directly a programming ...
2
votes
0answers
56 views
JDBC ResultSet::RefreshRow not working with Cascading update
I'm trying to throw together a quick JDBC app using Postgres as the DB and am running into an interesting issue.
I currently have 2 tables, table1 and table2.
CREATE TABLE table1
(
a character ...
2
votes
0answers
88 views
Is there any opensource tool for converting xml schema to database schema for linux?
Is there any opensource tool which convert xml schema to database schema for linux. All I need is it should read xml schema, generate corresponding database schema and create tables with that. I tried ...
2
votes
0answers
160 views
Play find(“byEmail”, email) not working in PostgreSQL 8.3
I've got a Play! app that I've been developing using an in-memory database, and now I'm switching to PostgreSQL so that I can deploy to Heroku. I can connect to the database, and the tables get ...
2
votes
0answers
295 views
PostgreSQL installation - error loading modules
I haven't been able to re-install PostgreSQL + PostGIS properly on our virtual server.
Installing PostgreSQL the following error occurs about the end of the process:
"A non-fatal error occurred ...
2
votes
0answers
218 views
Change backend ActiveRecord database for delayed_job in rails 3
I'm working on upgrading a rails app from 2.3.11 to 3.0 (then eventually 3.1), and am changing my delayed_job gem from 2.0.4 to 2.1.4.
There's already a delayed_jobs table in my postgres database, ...
2
votes
0answers
195 views
PostGIS 2.0 Installation issues
I have been trying to install postgis 2.0 on my computer(windows 7 32 bit) in order to benefit from expanded features. However I have been unable to actually get it to install successfully. My version ...
2
votes
0answers
183 views
Displaying Mutable PostgreSQL Arrays in the NetBeans Master/Detail Sample Form using JPA 1.0
Some Background
I have a game database with a table called Games that has multiple attributes and one called Genres. The Genres attribute is defined as an integer[] in PostgreSQL. For the sake of ...
2
votes
0answers
551 views
Profile Manager Lion Server error
My Lion Server (10.7.1) worked perfectly until this tuesday. Yesterday when I went to profile manager's page, sometime it works and sometime not.
Also, if I do the enrollment of a device sometimes ...
2
votes
0answers
130 views
Inserting data into PostgreSQL table from MATLAB with JDBC throws BatchUpdateException
I am trying to write to a PostgreSQL database table from MATLAB. I have got the connection working using JDBC and created the table, but I am getting a BatchUpdateException when I try to insert a ...
2
votes
0answers
205 views
Pure-ftpd and Postgreql Auth with password salt
I've recently begun the task of setting up an PureFTP server. At work we use Postgresql 8.4. The schema essentially boils down to,
username text
password character(40)
password_salt ...
