PostgreSQL 9.6 is a version of the PostgreSQL free and open-source RDBMS released on September 26, 2016. It features parallel query support and improvements in foreign data wrapper (FDW) and vacuuming of large tables. The last PostgreSQL 9.6 update is 9.6.24 and this version reached its end of support on November 11, 2021.
Questions tagged [postgres-9.6]
97 questions
16
votes
1 answer
How to alter the path for Postgres looking for extensions?
I installed Postgres on a Windows machine, downloaded the binary installer for PostGIS and installed it. I only have one version of Postgres, so there is no messing up possible.
Installing PostGIS using the binary installer is straight forward and…
TomGeo
- 1,213
- 2
- 12
- 24
10
votes
1 answer
Can Postgres silently ignore column constraint conflicts?
I have a Postgres 9.6 table with certain columns that must be unique. If I try to insert a duplicate row, I want Postgres to simply ignore the insert and continue, instead of failing or aborting. If the insert is wrapped in a transaction, it…
Barry Fruitman
- 12,316
- 13
- 72
- 135
7
votes
1 answer
Start and Stop pgAdmin4 correctly on Ubuntu 16.04
I'm working on a project that involves the creation of a dashboard (SpringBoot + angular.js webapp) for the interrogation of Zabbix. For the purpose of testing I installed Ubuntu 16.04 LTS (VirtualBox), PostgreSQL 9.6 in which I imported by command…
CoderJammer
- 599
- 3
- 8
- 27
7
votes
4 answers
Can't execute pgAdmin4
I installed Postgres9.6 ver And pgAdmin4 was installed together.
But It is return message "The application server could not be contacted" When i execute pgadmin.
I tried to download and install pgAdmin4 from web.
But have not changed anything.
I…
Gs.
- 540
- 1
- 3
- 21
6
votes
1 answer
Creating array of JSON objects from multiple columns
I have the following dataset here
id
key
category
avg_time_1
avg_time_2
1
1
10
10
20
2
1
20
30
40
3
2
10
10
50
4
2
20
60
70
Sqlfiddle.
I want to create a query that the result will be as…
Yuval Kaufman
- 585
- 1
- 5
- 17
6
votes
1 answer
Call of statically link function crash everytimes on windows 8/10 but not 7
The issue :
I have build https://github.com/reorg/pg_repack project whose generate a binary. This binary is linked with postgres 9.6 redistributable (I use those delievered by EntrepriseDb).
All works fine on windows 7. I have no issue during the…
Edeen
- 229
- 2
- 10
5
votes
4 answers
How to CREATE FUNCTION IF NOT EXISTS?
Is there are an easy way to do CREATE FUNCTION IF NOT EXISTS?
I have multiple schemas and I am preparing a script that will create missing objects in the target schema. The plan is to run a script to check if the object exists, do nothing if it…
Andrey
- 1,629
- 13
- 37
- 65
5
votes
1 answer
Postgres encode() function doesn't work with a function as an argument
I'm trying to use Postgresql encode() function and put some other functions as it's arguments. I get errors, and I can't understand why.
I am using Postgres 9.6.14 on Windows.
This works fine and returns 698d51a19d8a121ce581499d7b701668
select…
Aram Hovhannisyan
- 881
- 8
- 9
5
votes
4 answers
psql: symbol lookup error: psql: undefined symbol: PQsetErrorContextVisibility
I switched my postgres version from 9.2.24 to 9.6 because I need jsonb compatibility along with other recent features. I am running a vm on centos 7.
I decided to wipe all existing instances of postgres (which are almost empty since it is staging)…
Brandon
- 1,447
- 2
- 21
- 41
4
votes
2 answers
Postgres_FDW not pushing down WHERE criteria
I'm working with two PostgreSQL 9.6 databases and am trying to query one of the DB's from the other using postgres_fdw (one is a production backup DB that has the data and the other is a db for doing various analyses).
I've come across some odd…
Sven the Mediocre
- 125
- 1
- 9
4
votes
1 answer
How does Postgresql round half-microseconds in timestamps?
I was under the impression that PostgreSQL rounded half-microseconds in timestamps to the nearest even microsecond. E.g.:
> select '2000-01-01T00:00:00.0000585Z'::timestamptz;
timestamptz
-------------------------------
…
ifotneak
- 41
- 2
3
votes
3 answers
Postgres - Repeating an element N times as array
For example, where the element is 'hi', and where N is 3, I need a PostgreSQL snippet I can use in a SELECT query that returns the following array:
['hi', 'hi', 'hi']
eye_mew
- 8,855
- 7
- 30
- 50
3
votes
0 answers
Inserting a uuid from JSONB results in `error: invalid input syntax for uuid: `
I am trying to insert a series of values from an array of jsonb into postgres. However, I get the error error: invalid input syntax for uuid:.
My data looks like so
[
{
code: "dwfwradsa",
purpose: "description",
id: uuid (real uuid,…
Brandon
- 1,447
- 2
- 21
- 41
3
votes
1 answer
Full-Text Search producing no results
I have the following View:
CREATE VIEW public.profiles_search AS
SELECT
profiles.id,
profiles.bio,
profiles.title,
(
setweight(to_tsvector(profiles.search_language::regconfig, profiles.title::text),…
Darrell Brogdon
- 6,843
- 9
- 47
- 62
3
votes
1 answer
Migrate Postgres 9.6 Inherited Tables to TimeScaleDB
We have a time series table which is partitionied with inheritance. We now want to migrate this to TimeScaleDB within the same database. Documentation says to either use pg_dump/COPY or CREATE with LIKE. We could neither get to work with inherited…
KingOfCoders
- 2,253
- 2
- 23
- 34