pgsql-general since 2023-05-19 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 17 18 19 20 21 22 23 24 25 26 27 29 30 31

May 19, 2023

Thread Author Time
Re: PostgreSQL 13 - Logical Replication - ERROR: could not receive data from WAL stream: SSL SYSCALL error: EOF detected Kyotaro Horiguchi 04:02
a simple-minded question about updating Martin Mueller 04:08
Re: a simple-minded question about updating Adrian Klaver 04:20
Records, Types, and Arrays Raymond Brinzer 05:07
Re: Records, Types, and Arrays David G. Johnston 05:42
Re: Records, Types, and Arrays Raymond Brinzer 06:16
Re: pg_stats.avg_width Maciek Sakrejda 06:33
Re: Records, Types, and Arrays Raymond Brinzer 06:48
Re: Records, Types, and Arrays David G. Johnston 06:58
Re: Records, Types, and Arrays Raymond Brinzer 07:00
Re: Records, Types, and Arrays Pavel Stehule 07:40
Re: Records, Types, and Arrays Raymond Brinzer 07:46
Re: PostgreSQL 13 - Logical Replication - ERROR: could not receive data from WAL stream: SSL SYSCALL error: EOF detected FOUTE K. Jaurès 09:04
Re: Is there a good way to handle sum types (or tagged unions) in PostgreSQL? Dominique Devienne 10:44
How to connect with PostgreSQL Database with SSL using Certificates and Key from client Eclipse in Java sujay kadam 11:47
Re: Records, Types, and Arrays David G. Johnston 12:23
Re: a simple-minded question about updating Martin Mueller 14:25
Re: a simple-minded question about updating Adrian Klaver 14:42
Re: Is there a good way to handle sum types (or tagged unions) in PostgreSQL? Victor Nordam Suadicani 14:55
Trying to understand a failed upgrade in AWS RDS Mike Lissner 15:17
Re: Trying to understand a failed upgrade in AWS RDS Mike Lissner 16:49
Re: Adding SHOW CREATE TABLE Andrew Dunstan 17:08
Re: Is there a good way to handle sum types (or tagged unions) in PostgreSQL? Peter J. Holzer 19:52
Re: Modeling combinations (options and dependencies) Peter J. Holzer 20:25
Re: Unexpected cross-database vacuum impact with hot_standby_feedback=on Laurenz Albe 20:50
Re: Trying to understand a failed upgrade in AWS RDS Elterman, Michael 20:55
Re: Adding SHOW CREATE TABLE Corey Huinker 20:57
Re: Adding SHOW CREATE TABLE Laurenz Albe 21:06
Re: Adding SHOW CREATE TABLE Ziga 21:31
Re: Trying to understand a failed upgrade in AWS RDS Mike Lissner 21:56

May 20, 2023

Thread Author Time
Profiling a function call Tiffany Thang 04:36
Re: Trying to understand a failed upgrade in AWS RDS Julien Rouhaud 04:57
DBeaver postgres localhost access Pedro Gonçalves 14:09
CTE, lateral or jsonb_object_agg ? Marcos Pegoraro 14:43
Re: Adding SHOW CREATE TABLE Stephen Frost 17:26
Re: Adding SHOW CREATE TABLE David G. Johnston 17:31
Re: Adding SHOW CREATE TABLE Tom Lane 18:19
Re: Adding SHOW CREATE TABLE Stephen Frost 18:33

May 21, 2023

Thread Author Time
Re: Adding SHOW CREATE TABLE Kirk Wolak 05:58
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Marc Millas 11:13
Re: Profiling a function call Jan Wieck 11:27
Re: Profiling a function call Pavel Stehule 11:42
Re: Trying to understand a failed upgrade in AWS RDS Mike Lissner 14:56
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Theodore M Rolle, Jr. 17:15
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Marc Millas 19:10
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Thomas Kellerer 19:46
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Ron 20:01
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Theodore M Rolle, Jr. 21:00
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Marc Millas 21:38

May 22, 2023

Thread Author Time
Re: Adding SHOW CREATE TABLE Kirk Wolak 05:19
Re: Support logical replication of DDLs 📎 shveta malik 05:56
Re: Profiling a function call Tiffany Thang 06:14
Re: CTE, lateral or jsonb_object_agg ? Dominique Devienne 07:01
Re: DBeaver postgres localhost access Ron 07:08
Re: Adding SHOW CREATE TABLE Pavel Stehule 09:24
Re: Unexpected cross-database vacuum impact with hot_standby_feedback=on Owen Stephens 11:36
Re: Adding SHOW CREATE TABLE Andrew Dunstan 11:52
Fwd: PGCon remote attendance Joseph Hammerman 13:46
Re: Database size will be Huge difference while Restoring Adrian Klaver 15:26
Re: DBeaver postgres localhost access Adrian Klaver 15:44
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Tony Xu 18:02
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Christophe Pettus 18:16
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Tony Xu 19:22
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Ron 19:38
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Thorsten Glaser 19:53
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Adrian Klaver 20:06
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Christophe Pettus 20:08
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Ron 20:37
Re: CTE, lateral or jsonb_object_agg ? Merlin Moncure 22:56
15 pg_upgrade with -j Jeff Ross 23:20
Re: 15 pg_upgrade with -j Adrian Klaver 23:24
Re: 15 pg_upgrade with -j Jeff Ross 23:29
Re: 15 pg_upgrade with -j Tom Lane 23:42
Re: 15 pg_upgrade with -j Adrian Klaver 23:43

May 23, 2023

Thread Author Time
Re: PGCon remote attendance Tatsuo Ishii 00:57
Re: 15 pg_upgrade with -j Ron 02:10
How to speed up product code and subcode match Andrus 06:53
Re: Would PostgreSQL 16 native transparent data encryption support database level encryption? Stephen Frost 12:46
Re: How to speed up product code and subcode match Andrus 13:38
Re: How to speed up product code and subcode match Tom Lane 14:00
Re: How to speed up product code and subcode match Andrus 14:26
Re: 15 pg_upgrade with -j Jeff Ross 14:38
Re: 15 pg_upgrade with -j Jeff Ross 14:43
Re: How to speed up product code and subcode match Andrus 14:49
Re: Trying to understand a failed upgrade in AWS RDS Alan Hodgson 15:02
Questions on PostgreSQL 13.4 Installer for Windows Joel Rabinovitch 16:35
Re: 15 pg_upgrade with -j Peter J. Holzer 17:19
Re: 15 pg_upgrade with -j Ron 18:17
Re: 15 pg_upgrade with -j Christoph Moench-Tegeder 18:58
Re: 15 pg_upgrade with -j Peter J. Holzer 20:33
Re: 15 pg_upgrade with -j Ron 22:08

May 24, 2023

Thread Author Time
Re: Support logical replication of DDLs vignesh C 05:38
confused by int2vector typdelim jian he 07:56
Re: confused by int2vector typdelim Tom Lane 14:09
Re: 15 pg_upgrade with -j Alvaro Herrera 17:34
Question regarding specifics of GIN and pg_trgm performance and potential use of show_trgm to improve it Pavel Horal 20:28
Having issue with SSL. Randy Needham 21:02

May 25, 2023

Thread Author Time
Maintaining accents with "COPY" ? Laura Smith 07:14
Re: Maintaining accents with "COPY" ? Erik Wienhold 07:48
Re: Maintaining accents with "COPY" ? Laura Smith 10:08
Re: Maintaining accents with "COPY" ? Peter J. Holzer 11:26
Re: DB migration : Sybase to Postgres Sengottaiyan T 11:30
Re: Question regarding specifics of GIN and pg_trgm performance and potential use of show_trgm to improve it Tomas Vondra 12:00
Re: Maintaining accents with "COPY" ? Erik Wienhold 12:23
Re: Maintaining accents with "COPY" ? Erik Wienhold 12:37
CREATE TEMPORARY TABLE LIKE Jim Vanns 13:06
Re: DB migration : Sybase to Postgres Ron 13:10
Re: CREATE TEMPORARY TABLE LIKE Jim Vanns 13:19
Re: Adding SHOW CREATE TABLE Jelte Fennema 13:23
Re: CREATE TEMPORARY TABLE LIKE Erik Wienhold 13:24
Re: Having issue with SSL. Randy Needham 20:01
PostgreSQL GSSAPI Windows AD Jean-Philippe Chenel 21:50

May 26, 2023

Thread Author Time
Re: DB migration : Sybase to Postgres Sengottaiyan T 04:16
Re: DB migration : Sybase to Postgres Ron 04:22
Re: Having issue with SSL. Peter J. Holzer 10:17
Re: DB migration : Sybase to Postgres Marcos Pegoraro 10:39
Re: Adding SHOW CREATE TABLE Andrew Dunstan 12:33
Re: DB migration : Sybase to Postgres Peter J. Holzer 13:38
Re: DB migration : Sybase to Postgres Ron 14:03
Re: PostgreSQL GSSAPI Windows AD Jean-Philippe Chenel 18:35
Suggestions on pg_statviz Extension Rajiv Harlalka 20:20
Re: PostgreSQL GSSAPI Windows AD Tumasgiu Rossini 20:40
Query to find RDS endpoint Atul Kumar 21:46

May 27, 2023

Thread Author Time
explicit-locking.html "key values" reference jian he 03:02
Re: explicit-locking.html "key values" reference David G. Johnston 03:20

May 29, 2023

Thread Author Time
A question about generate_series 文一 01:24
Re: A question about generate_series David G. Johnston 01:29
Re: A question about generate_series Tom Lane 01:30
Re: A question about generate_series Wen Yi 01:32
How to make the generate_series to generate the letter series? Wen Yi 03:39
Re: How to make the generate_series to generate the letter series? Ian Lawrence Barwick 03:51
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 06:15
SSPI authentication failed for user "xxx" Albert Praveen 06:18
Re: Support logical replication of DDLs 📎 vignesh C 12:46
RE: FW: Error! Arquimedes Aguirre 16:45
Re: FW: Error! Adrian Klaver 17:12
RE: FW: Error! Arquimedes Aguirre 17:30
Re: FW: Error! Adrian Klaver 17:34

May 30, 2023

Thread Author Time
Where I can find the achieve of the 'generate_series' ? Wen Yi 00:34
Re: Where I can find the achieve of the 'generate_series' ? Adrian Klaver 00:48
Re: Where I can find the achieve of the 'generate_series' ? jian he 00:59
Re: Support logical replication of DDLs shveta malik 02:53
Re: Where I can find the achieve of the 'generate_series' ? Laurenz Albe 07:24
Re: Support logical replication of DDLs 📎 vignesh C 11:19
syntax pb Marc Millas 13:45
Question - Does PostgreSQL have an Evaluation Assurance Level? Mayer, Nicholas J 13:48
Re: syntax pb David G. Johnston 13:51
Re: syntax pb Ray O'Donnell 13:51
Re: syntax pb Adrian Klaver 14:38
Re: syntax pb Adrian Klaver 15:10
Re: syntax pb Marc Millas 15:53
Re: syntax pb hubert depesz lubaczewski 15:57
File-Access functions by default not executable by predefined role "pg_read_server_files" Carsten Klein 17:04
Re: syntax pb David G. Johnston 17:11
Re: syntax pb Tom Lane 17:31
Re: syntax pb Adrian Klaver 17:57
Re: syntax pb Adrian Klaver 17:59
Re: syntax pb Marc Millas 18:28
Re: syntax pb Marc Millas 18:31
Re: syntax pb Marc Millas 18:33
event trigger should provide more details Lian Jiang 20:23
Pg 16: will pg_dump & pg_restore be faster? Ron 20:54
Re: Pg 16: will pg_dump & pg_restore be faster? David Rowley 21:14
Re: event trigger should provide more details Erik Wienhold 21:42
Re: event trigger should provide more details Lian Jiang 22:28
Re: event trigger should provide more details Erik Wienhold 23:03
Re: Having issue with SSL. Randy Needham 23:17

May 31, 2023

Thread Author Time
Re: How to make the generate_series to generate the letter series? Bruce Momjian 01:04
Re: Pg 16: will pg_dump & pg_restore be faster? Bruce Momjian 01:13
Re: Pg 16: will pg_dump & pg_restore be faster? David Rowley 02:05
Re: Pg 16: will pg_dump & pg_restore be faster? Bruce Momjian 02:11
Re: Pg 16: will pg_dump & pg_restore be faster? David Rowley 02:18
Re: Pg 16: will pg_dump & pg_restore be faster? Bruce Momjian 02:28
speed up full table scan using psql Lian Jiang 04:25
Re: speed up full table scan using psql Rob Sargent 04:36
Re: speed up full table scan using psql David Rowley 05:16
Re: speed up full table scan using psql Lian Jiang 05:52
Is there a bug in psql? (SELECT ''';) Wen Yi 07:17
AW: Is there a bug in psql? (SELECT ''';) Marco Lechner 07:23
RE: Support logical replication of DDLs Wei Wang (Fujitsu) 09:02
Re: Support logical replication of DDLs 📎 shveta malik 09:40
Help needed to understand query planner regression with incremental sort 📎 Henrik Peinar (nodeSWAT.com) 10:46
Re: Pg 16: will pg_dump & pg_restore be faster? Bruce Momjian 11:00
Re: Is there a bug in psql? (SELECT ''';) hubert depesz lubaczewski 13:17
Hash Index on Partitioned Table [email protected] 13:44
Re: Pg 16: will pg_dump & pg_restore be faster? Andres Freund 13:45
Re: Hash Index on Partitioned Table Tom Lane 14:07
Re: Is there a bug in psql? (SELECT ''';) Adrian Klaver 15:11
Re: speed up full table scan using psql Adrian Klaver 15:14
Re: Help needed to understand query planner regression with incremental sort Tom Lane 15:31
Re: Hash Index on Partitioned Table [email protected] 17:53
Re: Question - Does PostgreSQL have an Evaluation Assurance Level? Laurenz Albe 19:08
RE: EXTERNAL: Re: Question - Does PostgreSQL have an Evaluation Assurance Level? Mayer, Nicholas J 19:51
Re: EXTERNAL: Re: Question - Does PostgreSQL have an Evaluation Assurance Level? Laurenz Albe 20:30
RE: EXTERNAL: Re: Question - Does PostgreSQL have an Evaluation Assurance Level? Mayer, Nicholas J 20:41
Re: Help needed to understand query planner regression with incremental sort Henrik Peinar (nodeSWAT.com) 20:45
Re: speed up full table scan using psql Lian Jiang 20:57
Re: speed up full table scan using psql Adrian Klaver 21:43
Re: speed up full table scan using psql Adrian Klaver 21:50
Re: speed up full table scan using psql Thorsten Glaser 22:01

Browse Archives

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