Tagged Questions

0
votes
2answers
36 views

PostGIS spatial reference ID (SRID) for regular cartesian coordinate system?

I would like to store a polygon as a set of 2D points represented as x, y coordinates of a Cartesian coordinate system. Which spatial reference can I use? Looking at my spatial_ref_sys table, all the ...
0
votes
1answer
13 views

Postgres: How can I join with an OR statement?

Given two tables: CREATE TABLE table1(id INT4, "name" TEXT); CREATE TABLE table2(table1_id INT4, name1 TEXT, name2 TEXT, name3 TEXT); INSERT INTO table1 (id, "name") VALUES (1, 'Jimmy'), (2, ...
0
votes
1answer
24 views

Postgre SQL incorrect syntaxt near If

I'm trying to create function but it's having error at If statement don't know what's the problem with it. CREATE FUNCTION uspgetcountrylistwithpagenumber(IN "PageNumber" integer, IN "PageSize" ...
0
votes
1answer
26 views

Can I continue to use Hibernate 3.0 when migrating PostgreSQL 8.2 to 9.2?

I'm working on a project that uses Hibernate 3.0. The program was released around 2007 and is connected to a PosgreSQL 8.2 Database. As we want to relaunch the project (thousands and thousands lines ...
0
votes
1answer
32 views

PostgreSQL clever use of ST_Within

maybe my question can seem stupid, but I'd like to ask if somebody can tell me how can I improve this query: UPDATE twitter SET poi=poi.type_name FROM poi WHERE ST_Within ...
0
votes
1answer
65 views

Outputting results from multiple sql queries in postgresql

I have postgresql-9.2 installed on my local machine (running windows 7) and I am also the administrator. I am using the Query Tool of pgAdmin III to query my database. My problem is as follows: Say I ...
0
votes
1answer
74 views

call postgres function with hibernate

I wrote a PostgreSQL function with return value VOID: CREATE OR REPLACE FUNCTION queryinteriorexteriorcount() RETURNS void AS ..... The function works quite well if i call it in pgAdmin. But if i ...
1
vote
0answers
62 views

Low Postgres Cache Hit Ratio - data size or something else?

I've just upgraded my Heroku postgres database from the Kappa plan (800MB RAM, postgres 9.1) to the Ronin plan (1.7GB RAM, postgres 9.2), but performance has degraded. Following the guide here, I ...
0
votes
0answers
14 views

How to install pgAgent service on windows

I am new in postgreSQL database , I recently found that postgreSQL support SQL Job by pgAgent. I am using windows XP operating system. I searched lots about pgAgent on Google and trying to configure ...
0
votes
0answers
50 views

An error occurred while installing pg (0.15.1) ; PostgreSQL on Mac Installation Error: no pg_config, gem native extension build failure

I have OSX 10.6.8 and am trying to install PostgreSQL 9.2 on my device. I used the graphical installer available on their website, and set up the software, without using stack builder at the end to ...
0
votes
0answers
23 views

How to get value of a variable in plv8 without using plv8.elog()?

I am having an issue with getting correct output from plv8.elog(). Just to start, I'm using PostgreSQL 9.2, plv8 1.4.1 as installed by pgxn, on Ubuntu 12.10. I have a function I am building that ...
0
votes
0answers
23 views

PostgreSQL 9.2 archiving last replayed WAL after recovery

Following the PostgreSQL 9.2 official documentation, I have set up continuous archiving on my postgres.conf file: wal_level = archive archive_mode = on archive_command = 'test ! -f /.../archive/%f ...
0
votes
0answers
34 views

OpenERP - warning: failed to kill 30449: No such process

I have script that runs OpenERP server, but I seems to be not working on new server for some reason (I use same script on another server and it works fine). when I enter command such as: ...
0
votes
0answers
49 views

How to create hibernate criteria with DISTINCT in this case

I am using hibernate criteria to create postgres query: criteria.addOrder(Order.asc(property).ignoreCase()).setProjection( ...
0
votes
0answers
41 views

postgresql to mssql query conversion

can any one help me to convert the following query into mssql which is working on postgresql now query is to take the updated datetime of the report in the asc order of the date select count(*) ...