pgsql-general since 2023-06-06 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30

June 6, 2023

Thread Author Time
RE: Support logical replication of DDLs 📎 Wei Wang (Fujitsu) 06:01
Drivers users by connections Hrishikesh (Richie) Rode 07:18
Re: Is there any good optimization solution to improve the query efficiency? gzh 08:33
Re: Support logical replication of DDLs vignesh C 09:12
No prompt for setting up a master password Stephanie Goulet 10:55
Re: Support logical replication of DDLs Amit Kapila 10:56
Re: Drivers users by connections Erik Wienhold 11:20
vacuum to prevent wraparound Marcos Pegoraro 14:36
Re: No prompt for setting up a master password Adrian Klaver 14:50
Re: vacuum to prevent wraparound Laurenz Albe 16:52
Fwd: No prompt for setting up a master password Stephanie Goulet 17:36
Re: Is there any good optimization solution to improve the query efficiency? Lorusso Domenico 21:13

June 7, 2023

Thread Author Time
PostgreSQL Dependency tree Lucas Possamai 01:13
Re: No prompt for setting up a master password Nikhil Mohite 04:47
How to manipulate field in New record Lorusso Domenico 12:12
Re: How to manipulate field in New record hubert depesz lubaczewski 12:58
Re: How to manipulate field in New record Adrian Klaver 13:57
Re: How to manipulate field in New record Lorusso Domenico 16:46
Native Logical Replication Initial Import Qs Don Seiler 21:12
Re: Native Logical Replication Initial Import Qs Jeremy Schneider 21:30
Re: No prompt for setting up a master password Stephanie Goulet 21:35
Re: No prompt for setting up a master password richard coleman 22:15

June 8, 2023

Thread Author Time
Re: Support logical replication of DDLs Amit Kapila 05:05
Re: Support logical replication of DDLs 📎 shveta malik 12:01
Re: Support logical replication of DDLs shveta malik 12:07
Re: Support logical replication of DDLs shveta malik 12:18

June 9, 2023

Thread Author Time
Re: Support logical replication of DDLs Masahiko Sawada 00:05
How To: A large [2D] matrix, 100,000+ rows/columns Pat Trainor 02:17
Re: Support logical replication of DDLs shveta malik 03:10
Question about where to deploy the business logics for data processing Nim Li 03:21
Re: Support logical replication of DDLs Amit Kapila 05:38
How to store query result into another table using stored procedure Rama Krishnan 05:51
How to securely isolate databases/users in a multi-tenant Postgresql? Alex Lee 06:54
Re: How To: A large [2D] matrix, 100,000+ rows/columns Alban Hertroys 06:59
Re: How to store query result into another table using stored procedure Ron 09:01
Logical replication slots stuck in catchup on a very large table Mathieu Poussin 09:05
Re: Support logical replication of DDLs Ajin Cherian 09:51
Why lex & yacc think this is a syntax error? Wen Yi 09:55
Re: How to securely isolate databases/users in a multi-tenant Postgresql? Erik Wienhold 10:32
Active Active PostgreSQL Solution Mohsin Kazmi 10:38
Re: How to store query result into another table using stored procedure Erik Wienhold 10:46
Re: Active Active PostgreSQL Solution Andreas Kretschmer 12:46
Re: Active Active PostgreSQL Solution Marcos Pegoraro 13:01
Re: Active Active PostgreSQL Solution Ben Chobot 13:04
Re: How To: A large [2D] matrix, 100,000+ rows/columns Joe Conway 13:16
Re: How To: A large [2D] matrix, 100,000+ rows/columns Wim Bertels 14:00
Re: How To: A large [2D] matrix, 100,000+ rows/columns Erik Wienhold 14:12
Re: Question about where to deploy the business logics for data processing Rob Sargent 15:06
Re: Question about where to deploy the business logics for data processing Michael Nolan 15:46
Re: Question about where to deploy the business logics for data processing Lorusso Domenico 16:34
Re: Question about where to deploy the business logics for data processing Nim Li 18:36
Re: Question about where to deploy the business logics for data processing Ron 20:38
Re: Question about where to deploy the business logics for data processing Guyren Howe 23:07
Re: Question about where to deploy the business logics for data processing Adrian Klaver 23:23

June 10, 2023

Thread Author Time
Re: Question about where to deploy the business logics for data processing Michael Nolan 00:13
Re: Active Active PostgreSQL Solution Bruce Momjian 01:22
Re: Active Active PostgreSQL Solution Marcos Pegoraro 05:18
initdb can't init the database Wen Yi 05:30
Re: initdb can't init the database Ian Lawrence Barwick 05:54
Re: initdb can't init the database Wen Yi 08:40
Re: Active Active PostgreSQL Solution Bruce Momjian 13:10
[No subject] Rajmohan Masa 16:55

June 11, 2023

Thread Author Time
What is gcda file? Wen Yi 02:03
Re: What is gcda file? David G. Johnston 02:20
Re: What is gcda file? Wen Yi 02:22

June 12, 2023

Thread Author Time
RE: Support logical replication of DDLs Wei Wang (Fujitsu) 01:47
How to trace the postgres? Wen Yi 10:37
Re: Question about where to deploy the business logics for data processing Lorusso Domenico 15:15
SOC II Type 2 report. Raj Kiran 18:57
Dynamic binding issue Lorusso Domenico 22:13
Re: Dynamic binding issue Adrian Klaver 23:31

June 13, 2023

Thread Author Time
Re: Question about where to deploy the business logics for data processing Merlin Moncure 02:49
Re: Support logical replication of DDLs Amit Kapila 05:15
Re: How to trace the postgres? Wen Yi 06:49
Reproducing incorrect order with order by in a subquery Ruslan Zakirov 07:49
Re: Support logical replication of DDLs Michael Paquier 07:50
[Beginner Question] Will the backup wal file take too much storage space? Wen Yi 08:00
"paths" between two ROLEs Dominique Devienne 08:17
pg_upgrade v15 not generating analyze_new_cluster.sh rihad 08:35
pg_upgrade v15 not generating analyze_new_cluster.sh rihad 08:35
Re: pg_upgrade v15 not generating analyze_new_cluster.sh Magnus Hagander 08:57
Re: Dynamic binding issue Lorusso Domenico 09:07
Re: pg_upgrade v15 not generating analyze_new_cluster.sh rihad 09:10
Re: Reproducing incorrect order with order by in a subquery Thomas Kellerer 10:26
Re: [Beginner Question] Will the backup wal file take too much storage space? Francisco Olarte 11:34
Re: "paths" between two ROLEs Joe Conway 12:20
Re: Support logical replication of DDLs Amit Kapila 13:19
Re: [Beginner Question] Will the backup wal file take too much storage space? Ron 14:50
Re: SOC II Type 2 report. Christophe Pettus 14:54
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 14:58
Re: Reproducing incorrect order with order by in a subquery Tom Lane 15:06
Re: "paths" between two ROLEs Dominique Devienne 15:11
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 17:55
Re: Reproducing incorrect order with order by in a subquery David G. Johnston 18:07
Exclusion constraint with negated operator? Torsten Förtsch 18:11
Helping planner to chose sequential scan when it improves performance 📎 Patrick O'Toole 19:24
Re: Exclusion constraint with negated operator? Tom Lane 20:15
Re: Support logical replication of DDLs Michael Paquier 21:56

June 14, 2023

Thread Author Time
Re: SOC II Type 2 report. raf 07:48
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 10:03
Re: Reproducing incorrect order with order by in a subquery Ron 11:47
Re: Reproducing incorrect order with order by in a subquery Karsten Hilbert 12:50
Re: Active Active PostgreSQL Solution Jan Wieck 16:13
date format Marc Millas 16:42
Re: date format Michael Nolan 17:05
Re: date format David G. Johnston 17:27
Re: date format Marc Millas 18:02
Re: date format Ron 18:14
Re: date format Marc Millas 18:23
Re: date format Marc Millas 18:24
Re: date format Adrian Klaver 18:53
Re: date format Laurenz Albe 20:44
Re: Reproducing incorrect order with order by in a subquery Ruslan Zakirov 21:58
Re: Helping planner to chose sequential scan when it improves performance Ruslan Zakirov 23:00

June 15, 2023

Thread Author Time
Re: Reproducing incorrect order with order by in a subquery Karsten Hilbert 18:15

June 16, 2023

Thread Author Time
Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 09:40
Re: Question: Multiple pg clusters on one server can be reached with the standard port. 📎 Thomas Markus 10:04
Re: Support logical replication of DDLs 📎 shveta malik 10:31
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Michael Weiller 11:52
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 11:53
Using vars in jsonbpath operator ? Markur Sens 11:54
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Laurenz Albe 12:13
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 12:35
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Laurenz Albe 12:50
Re: Using vars in jsonbpath operator ? Thomas Kellerer 13:24
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Dominique Devienne 13:25
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 14:04
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 14:49
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Laurenz Albe 15:18
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Laurenz Albe 15:19
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Laurenz Albe 15:20
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 15:34
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 15:39
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 15:41
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Michael Weiller 15:53
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 15:54
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 15:59
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 16:05
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Jeff Ross 16:16
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 16:56
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 17:09
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 17:10
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Francisco Olarte 19:53
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 20:18

June 18, 2023

Thread Author Time
Is there a way make the lex program match multiple line? Wen Yi 01:17
Re: Is there a way make the lex program match multiple line? Tom Lane 01:50
Re: Is there a way make the lex program match multiple line? Wen Yi 02:53
deb’s pg_upgradecluster(1) vs streaming replication James Cloos 06:06

June 19, 2023

Thread Author Time
Re: Support logical replication of DDLs shveta malik 03:39
timetz need more bytes than timestamptz jian he 03:52
Re: Question: Multiple pg clusters on one server can be reached with the standard port. 📎 Thomas Markus 04:06
Re: timetz need more bytes than timestamptz Junwang Zhao 05:20
[Beginner Question]How to let the lex && yacc parsing the string? Instead of the console. Wen Yi 07:28
Re: Support logical replication of DDLs Amit Kapila 09:34
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 10:04
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Peter J. Holzer 10:33
Re: Question: Multiple pg clusters on one server can be reached with the standard port. 📎 Thomas Markus 11:00
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Dominique Devienne 11:17
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Brainmue 11:30
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 12:49
OpenSSL version 3 Sebastien Flaesch 15:13
Re: OpenSSL version 3 Daniel Gustafsson 15:38
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Peter J. Holzer 17:15
Re: OpenSSL version 3 Jeffrey Walton 19:00
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 21:09

June 20, 2023

Thread Author Time
pg_service file questions JUN ZHI 06:11
Re: OpenSSL version 3 Daniel Gustafsson 06:56
Re: pg_service file questions Ron 08:27
Re: pg_service file questions Erik Wienhold 09:06
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Peter J. Holzer 14:54
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Ron 15:10
Re: Question: Multiple pg clusters on one server can be reached with the standard port. Peter J. Holzer 16:42
strange behavior of .pgpass file Atul Kumar 18:59
pb with join plan Marc Millas 19:42
Re: strange behavior of .pgpass file Adrian Klaver 20:08
Re: pb with join plan David Rowley 20:14
how to return data from insert into ... on conflict ... returning ... into Les 20:26
Re: pb with join plan Marc Millas 20:34
foreign keys on multiple parent table Lorusso Domenico 20:46
Re: foreign keys on multiple parent table David G. Johnston 20:50
Re: foreign keys on multiple parent table Les 21:01
Re: pb with join plan David Rowley 21:19
Re: pb with join plan Marc Millas 22:26
Re: strange behavior of .pgpass file Atul Kumar 22:29
Re: strange behavior of .pgpass file Adrian Klaver 22:32
Re: pb with join plan David Rowley 22:54

June 21, 2023

Thread Author Time
Re: foreign keys on multiple parent table Dominique Devienne 07:48
Re: strange behavior of .pgpass file Laurenz Albe 08:40
libpq: What can and cannot be bound? How to know? Dominique Devienne 09:00
Re: pb with join plan Tomas Vondra 10:43
Re: libpq: What can and cannot be bound? How to know? Laurenz Albe 11:52
Re: Support logical replication of DDLs 📎 Jelte Fennema 13:08
Re: libpq: What can and cannot be bound? How to know? Dominique Devienne 13:09
Re: libpq: What can and cannot be bound? How to know? David G. Johnston 14:20
Re: pb with join plan Marc Millas 14:24
Re: libpq: What can and cannot be bound? How to know? Dominique Devienne 14:51
Re: pb with join plan Marc Millas 16:10

June 22, 2023

Thread Author Time
Re: Adding SHOW CREATE TABLE Kirk Wolak 00:52
Re: Support logical replication of DDLs 📎 shveta malik 04:09
Re: Support logical replication of DDLs shveta malik 04:12

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30