Tagged Questions

PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X. Please mention your PostgreSQL version when asking questions about PostgreSQL.

learn more… | top users | synonyms (3)

8
votes
0answers
120 views

Two closest point on boundary of Postgis geometry

I am having a TABLE geofences which stores geometry of polygon . And I am having a point A which is inside the geometry what I have to do is that I have to find two closest point from point A which ...
6
votes
0answers
108 views

How to create ordered index with liquibase?

I am wondering if there is a generic way to create an "ordered index" with liquibase. Something that will produce these kind of SQL statement: CREATE INDEX idx_name ON my_table (m_column DESC) I ...
5
votes
0answers
595 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 ...
4
votes
0answers
135 views

node.js fibers with pg/postgres

I've been trying to figure out how to use node-fibers to make my database code less messy in node.js, but I can't get it to work. I boiled the code down to this as a minimum test case: var Future = ...
4
votes
0answers
439 views

ActiveRecord::ConnectionNotEstablished error (eager loading?)

I'm developing on OSX and deploying on Linux. My environments are: Development: OSX Lion Ruby 1.9.2p180 ActiveRecord 3.0.9 PostgreSQL 9.0 Test: Ubuntu Server 11.04 Ruby 1.9.2p290 ActiveRecord ...
4
votes
0answers
587 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 ...
3
votes
0answers
243 views

Yii framework and PostgreSQL partitioned table - 0 rows affected

PostgreSQL 9.1 Partitioned tables tbl_master tbl_slave1 (iherits master) tbl_slave2 (iherits master) Yii framework 1.1.10 Maybe someone can chare his expierience about Yii + PostgreSQL ...
3
votes
0answers
252 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
241 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
22 views

Postgres fts - conditions after fts is not working

I have a following query. While executing this query, the conditions after fts is not executing. Hibernate is ignoring this Session session = getSession(); String queryString = "select prj from ...
2
votes
0answers
43 views

“Could not locate SessionFactory in JNDI” with Hibernate in Jetty under Eclipse Juno

I've spent a few days understanding this problem, but I have not come up with a solution. The following are posts that are having similar problems: Similar Post 1, Similar Post 2, Similar Post 3. I ...
2
votes
0answers
32 views

Eager loading relation when relation is defined by finder_sql - ignores finder_sql and build default has_many query

There is class Location - i would like to to preload all direct children within a single query in Location class relation is defined like has_many :children, class_name: self, ...
2
votes
0answers
85 views

Postgres function does not exist at character 15

We have a postgres function which is defined as given below: Schema | public Name | getallocationmap_global Result data type | refcursor Argument data types | OUT v_set ...
2
votes
0answers
36 views

Transaction in non-blocking client?

We are using momoko and having following standard setup for async connection to db in tornado application: class BaseHandler(tornado.web.RequestHandler): @property def db(self): # ...
2
votes
0answers
26 views

Heroku restore snapshot XML Error

I am getting an XML error when I try and access the Heroku Postgres backup snapshot. I cant download it from the website and it will not restore! Is anyone else seeing this error downloading or ...

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