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
0
votes
1 answer
Can PG15's merge statement delete rows that exist in the destination table but are missing in the source?
If I have two tables with identical column definitions, I could do the following:
DELETE FROM table_2 WHERE pkey NOT IN (select pkey from table_1);
There are similar statements to insert into B anything not already in it but in A, and to update any…
John O
- 4,863
- 8
- 45
- 78
0
votes
1 answer
Postgresql 15 query optimizer refuses to parallelize a query on a partitioned table
I have a table "weather" that stores weather parameters for 45 years of entire Europe area with 400 million of record partitioned by range in an Oracle database managed through 19c instance and the table has been duplicated using oracle_fdw foreign…
Tony Zucchini
- 11
- 3
0
votes
1 answer
Is there any way to see information about error in postgresql?
I'm new using PostgreSQL, I'm looking for more information about errors, for example if I run this:
select top 10 * from TABLE
I'm getting this error:
ERROR: syntax error at or near "10"
LINE 2: select top 10 * from TABLE
^
SQL…
Araceli Fernández
- 23
- 4
0
votes
0 answers
SQL query not returning expected result when selecting from a view after table insertion
I am running a SQL query that inserts a row into a table and then selects data from a view that joins the newly inserted row with other data. Here's the query I'm using:
WITH inserted AS (
INSERT INTO trips (
person_count
) VALUES (
…
niko-gardenanet
- 1
- 1
0
votes
1 answer
Postgresql server setting up on Azure VM (Windows server 2022)
I have Azure VM with PostgreSql on it, and I can't connect to it.
I opened a port for TCP in my VM networking in the Azure portal. port
I have installed PostgreSQL on my VM.
listen_addresses = '*' was already set in postgresql.conf
At the end of…
Nolan
- 1
- 3
0
votes
0 answers
How to modify/alter the order of columns in a table in postrgesql? And if it isn't possible why?
I have a table with some columns and I would like to change the order of the columns akin to the following example
SomeTable
columnId, column1, column2, column3 etc...
I have tried the following syntax:
ALTER TABLE some_table
ORDER BY id,…
Stefan Stefanov
- 3
- 3
0
votes
0 answers
PostgreSQL - partition-wise join is not used
I have problem with not using partition-wise join by PostgreSQL 15.2.
I use 2 tables range-partitioned by the same key: date_id. Partition ranges for both tables are equal, except one of them (date_dim) has much more partions.
Table DDL:
CREATE…
Shr
- 1
- 1
0
votes
0 answers
Windows Server 2022 DataCenter at Version 15 of PostgresSQL
I am new to PostgreSQL so forgive me for asking, but I see that on https://www.postgresql.org/download/windows/ Version 15 shows 2019,2016 being supported Windows Platforms. Is it safe to assume Windows Server 2022 would work or should I generally…
bFrahm
- 1
0
votes
2 answers
Query data of a table along with latest record of another table
I am working on a forum like website where I have to query list of categories along with its latest post in the given category.
These are the table schemas
create table forum_posts (
forum_post_id text not null unique,
forum_post_name text…
grindarius
- 119
- 3
- 7
0
votes
1 answer
PostgreSQL 15 + Python 3.10+ plpython3u: 'psql: server closed the connection unexepectedly.' + 'The application has lost the database connection.'
I am trying to run a python script within a trigger in mi PostgreSQL 15 database in Windows 10.
I've already tried the solution proposed in the following…
0
votes
0 answers
Master Password in PostgreSQL
One of the applications in our environment is going to be using PostgreSQL on a Windows Server. My question is regarding "Master Password" feature. For the application to work properly; will we have to enter the "Master Password" every time we…
0
votes
1 answer
Postgres-15.1 is restarting continuously on using shared_preload_libraries extension
Postgres is restarting continuously on using shared_preload_libraries extension.
https://postgresqlco.nf/doc/en/param/shared_preload_libraries/
I am running postgres-15.1 using a python-based daemon in CentOS7-32bit arch. It is working fine if we do…
Vishal Gupta
- 23
- 4
0
votes
1 answer
Necessity to grant privileges on schema public + not working after the priveleges have been granted
Under postgres user:
postgres=# GRANT ALL ON schema public TO trololo;
GRANT
postgres=# \dn+
List of schemas
Name | Owner | Access privileges | Description …
Kifsif
- 3,477
- 10
- 36
- 45
0
votes
0 answers
PostgreSQL install : Failed to load sql modules into the database cluster
I tried to install postgreSQL v15.1.1 x64 in my windows 11 but on completion I got an error
I have used administration to install and close firewall.
Then I tried use another computer with windows 10,the install progress is successful.Is there any…
0
votes
1 answer
followed-by operator not possible with tsvector constructed from jsonb due to gaps in word numbering index
Input:
select to_tsvector('simple', '["one","two","three"]'::jsonb)
returns
'one':1 'three':5 'two':3
Expected:
'one':1 'three':3 'two':2
Which words have index 2 and 4? Is this a bug? How do I use it in a valid way?
With those gaps in the index…
springy76
- 3,706
- 2
- 24
- 46