Use this tag to indicate that your question is about PostgreSQL version 15. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-15]
112 questions
1
vote
1 answer
Get all rows where two ids appear the first time
i need help with a problem that drives me nuts.
Imagine you have the following table with just three ids.
CREATE TABLE candidates
(
row_num BIGINT,
in_id BIGINT,
out_id BIGINT
);
Fill it with some data:
INSERT INTO candidates…
Tom
- 520
- 2
- 17
1
vote
2 answers
Syntax error when using WITH...AS statement
I'm inserting data into table and I want to get last id which will be later used for another query.
Here is table structure and query sql-fiddle
I'm receiving this error
ERROR: syntax error at end of input Position: 890
What could be wrong in…
Josef
- 2,648
- 5
- 37
- 73
1
vote
1 answer
PostgreSQL User Defined Type Conversion from Oracle - CREATE TYPE AS TABLE OF
I've used ora2Pg to convert a PL/SQL procedure which uses a user-defined Oracle Object Types and corresponding Table Object Type.
The Object Types and the Stored Procedure convert successfully and both install/compile successfully in PostgreSQL…
andrewtindle
- 51
- 2
1
vote
1 answer
postgres function error on Insert operation for object identifier types : SQL Error [42725]: ERROR: more than one operator named +
Postgresql Insert statement on Objectidentifier datatype 'regoper' returns error 'SQL Error [42725]: ERROR: more than one operator named +' even though a single operator value is given
Hi, I have a created a table for all Object Identifier data…
aditya_1225
- 15
- 3
1
vote
1 answer
when does a (stored) GENERATED COLUMN get regenerated?
On any update to the row (which would be somehow dumb and I would expect a performance warning on the documentation page then) or is it smart enough of analyzing the generation expression and only regenerate the computed column when the input…
springy76
- 3,706
- 2
- 24
- 46
1
vote
2 answers
C#, PostgreSQL syntax error at end of input
I can't seem to be able to create migration with simplest sql to create PostgreSQL procedure.
Error is:
Exception data:
Severity: ERROR
SqlState: 42601
MessageText: syntax error at end of input
Position: 186
File: scan.l
Line: 1184
Routine:…
Milan
- 969
- 2
- 16
- 34
1
vote
2 answers
Postgres 15 Multi-Master Replication
For the last few days I've been trying to implement a working multi-master replication using postgresql however, unsuccessfull.
I came across multiple tools, none of which as worked.
I think I'm getting close to a solution but I'm hitting a…
João Ferreira
- 58
- 9
1
vote
2 answers
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"
After installing and opening the psql shell, it throws this error BEFORE even asking the password I had set during install:
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user…
user16776319
1
vote
0 answers
How to change default code page of Powershell or CMD console to 1251?
I'm using PostgreSQL v15 on win11, but accented character are broken in my DB.
What I've tried so far :
I switched to the "Bêta UTF8" thanks to this…
Yannize
- 11
- 3
0
votes
2 answers
Column list used by the publication does not cover the replica identity. Cannot Update Table - Logical Replication - Postgres 15
We're doing a Postgres native logical replication between two databases.
Now, we're getting an error trying to update from the publisher one of thousand tables that we have.
When we try to update the table it returns this error:
ERROR: Column list…
Tomás Hernández
- 1
- 2
0
votes
1 answer
PostgreSQL, PgAdmin launching error on macOS Ventura 13.5.1
I have a MacBook Air 2020 (macOS Ventura 13.5.1). Installed PostgreSQL, worked 5-6 days without any incidents (stable). Today launched, the initial page loads and displays an error.
Previously, when it was launched, it occupied 1 port (if I'm not…
0
votes
0 answers
Is there any way to access the tables in postgre SQL so that i don't have to use database.table_name everytime while reading a data from a table?
I use database.table_name only in Postgre SQL everytime i want to select a data from a table which is slightly annoying. Is there anyway to no use that and still run by queries without error
For ex in postgre SQL:
SELECT *
FROM…
0
votes
2 answers
SQL: how to remove duplicates when doing complex order by
Consider the following query:
SELECT u.id
FROM users u
INNER JOIN users_game_level l ON l.user_id = u.id
GROUP BY u.id
ORDER BY
CASE
WHEN l.level = 'BEGINNER' AND l.game_code = 'arcade' THEN 1
WHEN l.level = 'MEDIUM' l.game_code…
Majesty
- 2,097
- 5
- 24
- 55
0
votes
1 answer
How to install and run pg_reack on postgres with pg_reack version v1.4.8?
I recently upgraded PostgreSQL from v12.14 to v15.2. During the upgrade, I also had to update the pg_repack extension from v1.4.5 to v1.4.8. However, when I attempted to run pg_repack, I encountered the error: "pg_repack failed with error: program…
Akshay Bhadange
- 73
- 11
0
votes
1 answer
How to properly query a CIDR column in PostgreSQL so that I don't miss a match
I was previously using the >> operator for querying a CIDR column and it turns out it fails for some ipv4 values that required =. I want to be certain that I am properly querying this table so that I do not miss any matches on the table. The…
Rami
- 490
- 7
- 22