Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [postgresql-14]

Use this tag if your question is about PostgreSQL version 14 specific feature or behaviour. Please also add the generic [tag:postgres] tag.

Released on 2021-09-30. See https://www.postgresql.org/docs/release/14.0/ for the new features and enhancements introduced in PostgreSQL 14.

96 questions
1
vote
1 answer

Moving records from one table to another - a few records at a time

I have been using this query (successfully) to move records from one table to another in a Postgres database. WITH moved_rows AS ( DELETE FROM tableB RETURNING * ) INSERT INTO tableA SELECT * FROM moved_rows; For relatively small…
ConanTheGerbil
  • 1,155
  • 4
  • 26
  • 43
0
votes
1 answer

Index row size 2976 exceeds in postgresql

We have seen some of the indexes are getting failing with below error. ERROR: index row size 2976 exceeds byte version 4 maximum 2704 for index "idx1" HINT: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an…
Ram
  • 149
  • 2
  • 6
0
votes
0 answers

i want to have a streaming replication with delay 10 minutes behind the primary

I have set up a postgreSQL14 streaming replication. I set recovery_min_apply_delay=5min . every thing is ok. I have tested scenarious in which i delete some records from primary and i can recover them from standby. but in case of dropping or…
Mostafa
  • 1
0
votes
0 answers

Postgres 14 upsert column where nulls are unique

I have a table with a column where only 1 null is allowed (nulls should be considered unique). I can a create partial index on this column to enforce this rule. However I can't find a way to use that index in an ON CONFLICT clause. How can I create…
Jake
  • 101
  • 1
0
votes
1 answer

Convert byte to certain unit

What's the function to convert byte value to certain unit in PostgreSQL-14? for example: Byte Convert Converted Value Unit Value ----- ---- ----- 1 MB 0.000001 3000000 GB 0.0029296875
DevDon
  • 33
  • 1
  • 4
-1
votes
1 answer

Getting error converted oracle index to postgresql

we are in the process of migrating oracle to postgresql. during the process we are getting error for the below index. Oracle Index: CREATE INDEX idx1 ON table1 (column1||'-A1' ASC) ; By using schema tool the above index automatically converted into…
Ram
  • 149
  • 2
  • 6