Use this tag to indicate that your question is about PostgreSQL version 14. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-14]
227 questions
0
votes
1 answer
Postgres timezone_minute function with explicit type casts
I have two columns, date and time, both strings. I can concatenate them to get a column timestamp.
I need to use the timezone_minute() function†. I have tried various formats for the parameter, but have repeatedly faced the error
Query 1 ERROR:…
Ben Swinburne
- 25,669
- 10
- 69
- 108
0
votes
1 answer
How to get array/object number value in postgreSQL?
Is it possible to get array/object number values.
I have a table called tableA:
create table "tableA" (
"_id" serial,
"userId" integer,
"dependentData" jsonb);
INSERT INTO "tableA"
("_id", "userId", "dependentData")
VALUES('55555', '1191',…
sahil
- 109
- 8
0
votes
1 answer
Split multi-bracket data (JSON arrays) into rows preserving associations
I need to split data from bracket to row format.
If there is data in multi bracket, it does not update properly using below query.
Here's an example:
create table test (
id integer,
questionid character varying (255),
questionanswer character…
sahil
- 109
- 8
0
votes
0 answers
PostgreSQL to_tsvector generated column with table column for configuration name
I want to use stored generated column to create a separate tsvector column to hold the output of to_tsvector. The config name for the ts_vector is stored in the separate column language_field. Similarly to sql for creating ts_vector index I thought…
Anna
- 523
- 3
- 8
0
votes
1 answer
Sum the duration of an member in nested json array in posgres
need an help
I need to sum the duration of the days for an particular id in an nested jason through postgres query
--Sample data
[{
"id": 55,
"r_id": 2,
"friday": null,
"monday": {
"dia_id": "wsd",
"book_on": "12:00",
…
nikhil raj
- 55
- 1
- 10
0
votes
0 answers
How to generate dates in Postgresql based on a start_date and day of week
I'm trying to generate dates that comes after a certain start_date with the interval of a variable day/s of week.
If the start_date is 2023-01-01 and the days of the week are [2,3,5] or ['tue','thu','sat'], then it should generate the…
Zed
- 343
- 1
- 2
- 6
0
votes
0 answers
Invalid Value for Parameter 'recovery_target_time' in Postgres Database
Wishing you all a Happy and Prosperous New Year!
I am getting below error while restoring postgres database to a specific target time (PITR):
Invalid value for parameter recovery_target_time in file postgresql.conf
And database is not getting…
neil
- 1
- 2
0
votes
1 answer
I'm installing the plpython3u postgres extension inside of a container. In psql, the extension exists but also doesn't exist. Postgresql 14
I am trying to transfer cloud data into a Postgres database from within a Docker container. I built the container using docker-compose with the following Dockerfile snippet:
FROM postgres:14
...
RUN apt-get update \
&& pip3 install awscli
RUN…
Ryan Mazon
- 11
- 2
0
votes
0 answers
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed:
NOTE: I have a MacOS Monterey M1 chip.
After I put in the command line - psql postgres - I get the response state below.
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: Connection refused
Is the server running locally…
0
votes
1 answer
PostgreSQL> column integer[] value check from another table(id)
I want to build an application which use postgresql.
It should be a simple question but I still cannot find the answer quickly enough ; maybe would you help me to do this?
I have a table of ingredients.
id PK, name VARCHAR
I want to create a table…
0
votes
1 answer
CREATE INDEX CONCURRENTLY is executed but the CONCURRENTLY option lost after creation?
In my Postgres 14.3 database on AWS RDS, I want to create an index without blocking other database operations. So I want to use the CONCURRENTLY option and I executed the following statement successfully.
CREATE INDEX CONCURRENTLY idx_test
ON…
Micha
- 3
- 2
0
votes
0 answers
How to find which files takes storage space on my RDS Postgresql instance?
We are working on a RDS Postgresql 14.4 instance and lately we discovered that our storage space was being bloated. We went from 46Gb total size on a freshly migrated database to 81Gb in the course of a week.
We found this article :…
kgrosjean
- 1
- 1
0
votes
0 answers
Cannot upgrade extension postgres_fdw, due to: has no update path from version "1.0" to version "1.1"
I am trying to upgrade My postgres DBs from postgres 10 to 14, after looking at the extension version here https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-14x I need to upgrade…
amatisans
- 13
- 1
- 6
0
votes
0 answers
Postgres - error after execution many times the same query
I have a table fepu00 and trigger on it.
The part of code causing tha problem looks like follows:
if (old_record.potime = NEW.putime --new AP (read in statement above)
or old_record.pupisb::NUMERIC != NEW.pupisb::NUMERIC) then
…
agad
- 2,192
- 1
- 20
- 32
0
votes
1 answer
Postgres Grant CRUD on DATABASE to USER
I have an application which uses a postgres database. I have a superadmin user. Now I need two more users: One "application-user" with CRUD-privileges and one with ALTER and CREATE-privileges (to apply migrations). These are all users I need,…
Joshit
- 1,238
- 16
- 38