Questions tagged [postgres-10]
50 questions
0
votes
1 answer
set returning functions are not allowed in CASE, in Postgres 10.6
sql is not my strong point
upgrading from postgres 9.6 to 10.6 and I get an error from this query:
SELECT id, (CASE WHEN jsonb_typeof(content->'user')='array' THEN jsonb_array_elements(content -> 'user')
ELSE content::jsonb->'user' END) As…
Brunaldo
- 324
- 3
- 11
0
votes
1 answer
Weird error: relation does not exist
I am running a DDL statement like this in Postgres 11
ALTER SEQUENCE kwt.VisitReport_seq OWNED BY kwt.VisitReport;
I am running it as DBADMIN.
Yet I get some weird error:
SQL Error [42P01]: ERROR: relation "kwt" does not exist
ERROR:…
peter.petrov
- 38,363
- 16
- 94
- 159
0
votes
1 answer
JSONB search if values exist: from another table
I have 2 tables:
info.parts
info.complete
In the info.parts I have a uuid column that is mapped to the info.complete table which is contained in a JSONB column. So
info.part
part.uuid |id |INFO |…
Geoffrey Jennings
- 27
- 4
0
votes
0 answers
Error: Package: pgdg-redhat-repo-42.0-6.noarch (/pgdg-redhat10-10-2.noarch) - Requires: /etc/redhat-release
This is a DockerFile. Facing issue on Mac.
Error: Package: pgdg-redhat-repo-42.0-6.noarch (/pgdg-redhat10-10-2.noarch)
Requires: /etc/redhat-release
You could try using --skip-broken to work around the problem
You could try running: rpm…
momwhocode
- 129
- 9
0
votes
0 answers
Is there any installler available for Time Scale DB be installed open-SUSE/SLES?
Is there any postgres and Time Scale DB installer available for the open-SUSE/SLES-15.
There are some ways available to install postgres using source and then TSDB also but is there an installer available to do so?
0
votes
1 answer
Bonita BPM stop working or not response and Disk Queque Length
Currently identified situation.
When there was an attempt to create the “internal correspondence” process at the same time, the Bitronix logs prescribed a timeout, but in fact Postgres worked, and the monitoring increased the length of the disk…
Adil Kangerey
- 11
- 2
0
votes
1 answer
Postgres on SAN
I have two postgres nodes with a shared storage (only for data, not for config), works simply by stopping postgres on one side and starting it on the other. Pacemaker (PAF) handles stop/start between the nodes.
Questions:
What type of PostgreSQL…
Andy Thompson
- 284
- 1
- 3
- 21
0
votes
1 answer
PostgreSQL: get advisory lock unless more than n transactions are waiting for it
I've a resource that gets acquired from distributed clients. This resource is protected by a transaction level lock:
SELECT pg_advisory_xact_lock(123456)
I know I can use pg_try_advisory_xact_lock if I don't want to wait for it to be free. If I…
Alechko
- 1,406
- 1
- 13
- 27
0
votes
1 answer
How to find stolon version
Hi I am new to infra related work.
I am asked to copy 0.14.0 version of stolon binary files like stolonctl, stolon-keeper, stolon-proxy and stolon-sentinal to our postgresHa docker-container.
I created a new container using the files in git hub…
beginner
- 59
- 5
0
votes
0 answers
Postgres replication ERROR reorderbuffer spill
I have setup postgres logical replication that work well for short time.
now i see that the replication status is: 'catchup',
and the following error in mater log:
"ERROR: could not read from reorderbuffer spill file: Not enough space"
on the…
kabanus
- 1
- 3
0
votes
1 answer
Can't create schema in postgres
I'm trying to create schema with query:
CREATE SCHEMA IF NOT EXISTS hdb_catalog
but following error occurred:
2019-09-10 13:47:37.025 UTC [129] ERROR: duplicate key value violates unique constraint "pg_namespace_nspname_index"
2019-09-10…
user12046307
0
votes
0 answers
Knex migrations to two separate databases with postgres 10 logical replication
I am currently using knex migrations to manage postgres schema changes. I have a source db and a target db with logical replication enabled using posgres 10.7. I am trying to figure out the best way to keep the schemas identical otherwise…
acob801
- 1
0
votes
1 answer
How to write select statement with a condition of case-insensitive from a select query output
I'm getting data like this
Doha
doha
Dubai
Abu Dhabi
Abu dhabi
from the query select distinct(trim(name)) as loc from locations order by trim(name)
Now I want to remove duplicates using lower() or upper() and select the first record .
If I use…
Vanjith
- 520
- 4
- 23
0
votes
1 answer
Postgres Replication on Inherited Table
I try to create a logical replication on a inherited table with Postgres 10. But if I create the subscription I get a error that the relation does not exist. Does anyone got a idea why this happen? The other way to inherited on a replicated table…
Martin Feige
- 31
- 3
0
votes
1 answer
Setup role so that role is owner of sequence or table role made
I want to allow a users assigned to a role to delete their own content in postgres but not content made by admins. I am new to database management and thought that the below would work but doesn't.
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO…
mapping dom
- 1,737
- 4
- 27
- 50