pgsql-general since 2023-05-22 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)

Browse Archives

Prev | Next

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

June 1, 2023

Thread Author Time
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 02:12
Re: speed up full table scan using psql Adrian Klaver 04:16
Re: speed up full table scan using psql Lian Jiang 05:51
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 07:39
Dynamic creation of list partitions in highly concurrent write environment Jim Vanns 10:14
Re: Hash Index on Partitioned Table Marc Millas 10:42
Re: Dynamic creation of list partitions in highly concurrent write environment Tom Lane 13:32
Re: Dynamic creation of list partitions in highly concurrent write environment Jim Vanns 13:45
Re: speed up full table scan using psql Adrian Klaver 15:03
Re: Support logical replication of DDLs 📎 vignesh C 15:42
Re: Adding SHOW CREATE TABLE Kirk Wolak 16:57
Re: Adding SHOW CREATE TABLE Andrew Dunstan 19:13
Re: Adding SHOW CREATE TABLE Kirk Wolak 20:39
Re: Adding SHOW CREATE TABLE Andrew Dunstan 20:46

June 2, 2023

Thread Author Time
[Beginner Question]A question about yacc & lex Wen Yi 00:47
Re: [Beginner Question]A question about yacc & lex Tom Lane 12:07
Re: Pg 16: will pg_dump & pg_restore be faster? Jonathan S. Katz 12:14
Interconnected views Oliver Kohll 13:36
Re: Adding SHOW CREATE TABLE Kirk Wolak 14:57
Re: Interconnected views Chris Travers 17:58
custom background worker task for \copy? Joe Carlson 18:36
Re: Interconnected views Guillermo González de Agüero 18:46

June 3, 2023

Thread Author Time
pg_upgrade and schema complexity... Ron 00:44
Re: pg_upgrade and schema complexity... Adrian Klaver 00:58
Re: pg_upgrade and schema complexity... Ron 01:06
Re: pg_upgrade and schema complexity... Christophe Pettus 01:08
Re: pg_upgrade and schema complexity... Adrian Klaver 02:22
Re: custom background worker task for \copy? Laurenz Albe 04:41
How to remove user specific grant and revoke Andrus 07:16
No Greek stop words in FTS ? Florents Tselai 08:24
Number of dashes in the expanded view of psql 📎 Rajiv Harlalka 10:12
Re: How to remove user specific grant and revoke Erik Wienhold 12:46
Re: How to remove user specific grant and revoke Erik Wienhold 13:07
Re: pg_upgrade and schema complexity... Ron 13:51
Re: custom background worker task for \copy? Joe Carlson 14:46
Re: Number of dashes in the expanded view of psql Adrian Klaver 15:05
Re: How to remove user specific grant and revoke Andrus 16:14
Re: How to remove user specific grant and revoke Erik Wienhold 16:38
Re: How to remove user specific grant and revoke Andrus 20:33
Re: How to remove user specific grant and revoke Erik Wienhold 20:57
Re: How to remove user specific grant and revoke Andrus 21:34
Re: How to remove user specific grant and revoke Andrus 22:08

June 4, 2023

Thread Author Time
Re: How to remove user specific grant and revoke Erik Wienhold 00:36
Re: How to remove user specific grant and revoke Erik Wienhold 00:36
Connection error to new pg15 instance Steve Baldwin 01:11
Can't send mail to `[email protected]` Wen Yi 01:46
Re: Can't send mail to `[email protected]` Adrian Klaver 03:11
Re: Can't send mail to `[email protected]` Wen Yi 03:29
Re: Interconnected views Kirk Wolak 03:40

Browse Archives

Prev | Next