Top "Postgresql-9.2" questions

for PostgreSQL questions specific to version 9.2.

Postgres 9.2 - add conditional constraint check

I'm using PostgreSQL 9.2 and need to add a conditional constraint on a column. Essentially I want to make sure that …

postgresql drupal constraints postgresql-9.2
Query giving division by zero error in PostgreSQL

I am trying to run the following query which results me postgres error: division by zero select request_count, response_…

sql postgresql percentage postgresql-9.2
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 …

sql postgresql postgresql-9.2
How to append a new item into the array-type column in PostgreSQL

Im using PostgreSQL for my application, The task will be like this There are users who use my app, and …

postgresql postgresql-9.2
PostgreSQL - how should I use first_value()?

This answer to shows how to produce High/Low/Open/Close values from a ticker: Retrieve aggregates for arbitrary time …

sql postgresql postgresql-9.2 window-functions
Postgresql 9.2 installation on Ubuntu 12.04

For installing postgresql 9.2 I followed this url : http://www.ubuntugeek.com/how-to-install-postgresql-9-2-on-ubuntu-server-using-ppa.html But at the end of …

postgresql ubuntu ubuntu-12.04 postgresql-9.2
Can't log into system user postgres

I installed postgresql on mac using brew. I wasn't asked about for the password for postgresql during the installation. Now …

macos postgresql postgresql-9.2
osm2pgsql: Function AddGeometryColumn doesn't exist

I want to import OSM file into my PostgreSQL database (Windows, Postgres Version 9.2) using the tool Osm2pgsql. When I …

postgresql postgis openstreetmap postgresql-9.2
Where in the DB is the Location of a postgres tablespace stored

I am using postgres 9.2 on redhat 6 this should be simple but I can't find it anywhere. I am looking for …

postgresql postgresql-9.2 tablespace
"FATAL: the database system is shutting down" while creating connection to PostgreSQL

I am getting FATAL: the database system is shutting down errors while creating PostgreSQL JDBC connections to a PostgreSQL 9.2 server. …

postgresql jdbc postgresql-9.2