Questions tagged [postgresql-8.1]

PostgreSQL Version 8.1. This is a legacy PostgreSQL version, that is End of Life since November 2010.

Filter by
Sorted by
Tagged with
0
votes
1answer
255 views

How can I obtain continuous results with a PostgreSQL query?

I am using PostgreSQL version 8.1. I have a table of dates and tasks. The tasks have start times and end times in the table. The query below does not work as expected. SELECT sites.abbrev, (...
3
votes
1answer
816 views

Converting standard_conforming_strings from off to on when importing Postgres dump

I've got a Postgres 8.1 instance which has standard_conforming_strings set to off (== handles slashes as escape characters). Recent Postgres versions have this setting on by default (for good reasons)....
3
votes
0answers
118 views

Access points of geometric path data in PostgreSQL 8.1

Summary: I would like to perform basic operations on the points of geometric path data contained in a PostgreSQL 8.1 server which I do not have administrative access to. In particular I would like to ...
2
votes
0answers
995 views

Data Corruption - ERROR: could not open segment 2 of relation

I am getting the below error for a production database. I am new to PostgreSQL databases. I need help to get this fixed. 2015-10-28 10:25:04,154 [monitor-thread-pool1-thread-6] ERROR [org.hibernate....