pgsql-general since 2023-04-14 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 28 29

April 14, 2023

Thread Author Time
Re: "PANIC: could not open critical system index 2662" - twice Laurenz Albe 02:55
Re: "PANIC: could not open critical system index 2662" - twice Thorsten Glaser 04:00
Re: Support logical replication of DDLs vignesh C 07:36
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 07:38
Re: "PANIC: could not open critical system index 2662" - twice Alban Hertroys 08:42
cursor with hold must be save to disk? 黄宁 11:04
SIze 0 in pg_stat_file, pg_stat_progress_copy Marc Millas 14:26
Re: cursor with hold must be save to disk? Adrian Klaver 15:11
Re: cursor with hold must be save to disk? Laurenz Albe 15:30
Re: [Extern] Re: Is a logical replication crash recovery safe? GF 16:03
Re: SIze 0 in pg_stat_file, pg_stat_progress_copy Marc Millas 16:09
Re: JSON / ASP.NET AJAX Dates support in PostgreSQL Peter J. Holzer 16:31
Re: Guidance on INSERT RETURNING order Peter J. Holzer 16:40
Re: JSON / ASP.NET AJAX Dates support in PostgreSQL Adrian Klaver 17:44
Re: Guidance on INSERT RETURNING order John Howroyd 18:41
Re: Guidance on INSERT RETURNING order David G. Johnston 18:50
Re: Guidance on INSERT RETURNING order Federico 19:46
Re: Guidance on INSERT RETURNING order John Howroyd 21:44
Re: Guidance on INSERT RETURNING order David G. Johnston 22:14
Re: Guidance on INSERT RETURNING order David G. Johnston 22:22
Re: Guidance on INSERT RETURNING order Karsten Hilbert 22:44
Re: Guidance on INSERT RETURNING order Adrian Klaver 22:46

April 15, 2023

Thread Author Time
Re: Support logical replication of DDLs vignesh C 01:08
Re: Guidance on INSERT RETURNING order Tom Lane 03:17
Re: Guidance on INSERT RETURNING order David G. Johnston 03:39
Re: Guidance on INSERT RETURNING order Federico 06:54
Should I add a new schema for my application? Alexander Farber 10:06
Re: JSON / ASP.NET AJAX Dates support in PostgreSQL Peter J. Holzer 10:46
Re: Guidance on INSERT RETURNING order Tom Lane 13:40
Re: Guidance on INSERT RETURNING order Federico 14:08
RE: FW: Error! Arquimedes Aguirre 14:39
Re: JSON / ASP.NET AJAX Dates support in PostgreSQL Adrian Klaver 16:12
Re: JSON / ASP.NET AJAX Dates support in PostgreSQL Peter J. Holzer 16:34
Re: Guidance on INSERT RETURNING order Mike Bayer 16:39
Re: FW: Error! Adrian Klaver 16:41
Logical replication failed with SSL SYSCALL error shaurya jain 21:10
Re: cursors with prepared statements Bryn Llewellyn 21:15
Re: cursors with prepared statements David G. Johnston 21:40
RE: FW: Error! Arquimedes Aguirre 22:28
Re: cursors with prepared statements Bryn Llewellyn 22:37
Re: FW: Error! Adrian Klaver 22:56
RE: FW: Error! 📎 Arquimedes Aguirre 23:56

April 16, 2023

Thread Author Time
Re: FW: Error! Adrian Klaver 04:24
Call a Normal function inside a Trigger Function FOUTE K. Jaurès 14:18
Suppress logging of "pg_hba.conf rejects connection for host" ertan.kucukoglu 15:02
Re: Call a Normal function inside a Trigger Function Erik Wienhold 15:05
Re: Suppress logging of "pg_hba.conf rejects connection for host" Erik Wienhold 15:51
Re: Call a Normal function inside a Trigger Function Pavel Stehule 16:07
PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements Bryn Llewellyn 18:02
Re: PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements Adrian Klaver 18:39
Re: Call a Normal function inside a Trigger Function FOUTE K. Jaurès 18:47
Re: Call a Normal function inside a Trigger Function Adrian Klaver 19:13
Re: Call a Normal function inside a Trigger Function Pavel Stehule 19:13
Re: Call a Normal function inside a Trigger Function FOUTE K. Jaurès 19:22
Re: PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements Bryn Llewellyn 21:41

April 17, 2023

Thread Author Time
Re: cursor with hold must be save to disk? 黄宁 02:25
Re: Support logical replication of DDLs Peter Smith 08:14
Re: Support logical replication of DDLs vignesh C 10:31
RE: Support logical replication of DDLs 📎 Zhijie Hou (Fujitsu) 12:02
RE: Support logical replication of DDLs Zhijie Hou (Fujitsu) 12:02
Re: Support logical replication of DDLs Peter Smith 12:16
Re: Suppress logging of "pg_hba.conf rejects connection for host" Ron 13:11
Question on SSI - Serializable Snapshot Isolation Siddharth Jain 15:37
Re: Should I add a new schema for my application? Laurenz Albe 15:38
Re: Guidance on INSERT RETURNING order John Howroyd 17:48
Re: Guidance on INSERT RETURNING order John Howroyd 18:03
Re: Question on SSI - Serializable Snapshot Isolation Tom Lane 21:39
Re: Guidance on INSERT RETURNING order Federico 22:58

April 18, 2023

Thread Author Time
Fwd: Request for information about Postgres version 15.2 stability gayathri ramesh 06:54
Request for information about postgres version 15.2 stability gayathri ramesh 06:56
Logical Replication Sync Validation Robert Sjöblom 08:20
Re: Logical Replication Sync Validation Christophe Pettus 08:29
Re: Guidance on INSERT RETURNING order John Howroyd 09:52
Re: Logical Replication Sync Validation Christophe Pettus 10:48
Re: Request for information about postgres version 15.2 stability Adrian Klaver 14:30
Re: Question on SSI - Serializable Snapshot Isolation Siddharth Jain 15:24
Re: Request for information about postgres version 15.2 stability Laurenz Albe 16:04
Postgres as a LRU cache? David Tinker 16:04
Re: Logical Replication Sync Validation Laurenz Albe 16:07
Re: Request for information about postgres version 15.2 stability Tom Lane 16:35

April 19, 2023

Thread Author Time
ETCD for Patroni configuration error Inzamam Shafiq 06:44
Re: Request for information about postgres version 15.2 stability Stéphane Dunand 07:06
Re: Guidance on INSERT RETURNING order Federico 07:29
Re: Support logical replication of DDLs Peter Smith 08:27
COPY RETURNING? Dominique Devienne 09:55
Re: Logical replication failed with SSL SYSCALL error shaurya jain 11:56
Re: [PATCH] Introduce array_shuffle() and array_sample() Salek Talangi 12:04
psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist gzh 13:24
RE: Support logical replication of DDLs 📎 Zhijie Hou (Fujitsu) 13:55
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist Erik Wienhold 14:51
Joins of data-modifying CTE with the target table Alex Bolenok 15:37
Re: COPY RETURNING? Adrian Klaver 15:41
Re: Joins of data-modifying CTE with the target table Tom Lane 15:46
Re: Joins of data-modifying CTE with the target table Adrian Klaver 15:52
Re: Joins of data-modifying CTE with the target table Alex Bolenok 16:09
Re: Joins of data-modifying CTE with the target table Adrian Klaver 16:42
Re: Joins of data-modifying CTE with the target table Tom Lane 16:53
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist gzh 17:02
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist Tom Lane 17:18
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist Adrian Klaver 17:23
What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." Bryn Llewellyn 18:19
Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." Jeremy Smith 19:00
Question about accessing partitions whose name includes the schema name and a period - is this correct? Jay Stanley 21:12
Re: Question about accessing partitions whose name includes the schema name and a period - is this correct? Tom Lane 21:42
Re: Question about accessing partitions whose name includes the schema name and a period - is this correct? Jay Stanley 22:50
Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." Bryn Llewellyn 23:53

April 20, 2023

Thread Author Time
Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." Adrian Klaver 00:09
Re: Question about accessing partitions whose name includes the schema name and a period - is this correct? Erik Wienhold 01:18
How does pg index page optimize dead tuples? [email protected] 01:41
RE: Support logical replication of DDLs 📎 Zhijie Hou (Fujitsu) 01:49
Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." Bryn Llewellyn 03:10
Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." David G. Johnston 03:24
Re: Support logical replication of DDLs shveta malik 03:41
Re: Question about accessing partitions whose name includes the schema name and a period - is this correct? Tom Lane 04:03
Re: Logical replication failed with SSL SYSCALL error vignesh C 06:19
Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." Laurenz Albe 07:11
Re: Support logical replication of DDLs shveta malik 08:58
Re: Support logical replication of DDLs Amit Kapila 10:10
Re: Support logical replication of DDLs shveta malik 12:39
Re: What happened to the tip "It is good practice to create a role that has the CREATEDB and CREATEROLE privileges..." Bryn Llewellyn 16:17
missing something about json syntax Marc Millas 16:35
Re: missing something about json syntax Erik Wienhold 17:47
Re: missing something about json syntax Marc Millas 19:53
Re: missing something about json syntax Tom Lane 20:41

April 21, 2023

Thread Author Time
Re: Support logical replication of DDLs Peter Smith 00:26
Why does the planner reduce the planned rows when filtering single values in an array Isaiah Langford 02:41
vacuum TOAST tables senor 04:37
Re: Support logical replication of DDLs Amit Kapila 05:57
Re: vacuum TOAST tables Laurenz Albe 06:39
Unexpectedly huge memory usage (over 180x of work_mem) during hash join... confirmed by TopMemoryContext results (postgresql 13.10) Maxim Boguk 09:13
Re: Support logical replication of DDLs Amit Kapila 09:16
Re: missing something about json syntax Marc Millas 10:22
HOT update: why must ALL indexes should be update? Daniel Wu 14:06
Re: HOT update: why must ALL indexes should be update? Tom Lane 14:19
Re: Why does the planner reduce the planned rows when filtering single values in an array Tom Lane 14:43
Re: vacuum TOAST tables senor 21:55
Re: Why does the planner reduce the planned rows when filtering single values in an array Isaiah Langford 23:02

April 22, 2023

Thread Author Time
Where to find the Makefile.global? Wen Yi 03:08
Re: Where to find the Makefile.global? Tom Lane 03:11
RE: FW: Error! 📎 Arquimedes Aguirre 14:31
Re: FW: Error! Adrian Klaver 16:04
Re: How to verify postrgresql download on windows? Ali M. 17:14
Re: How to verify postrgresql download on windows? Matthias Apitz 17:58
SCROLLABLE/UPDATABLE cursor question Garfield Lewis 18:05
Re: SCROLLABLE/UPDATABLE cursor question Tom Lane 19:02

April 23, 2023

Thread Author Time
Why not use the calloc to replace malloc? Wen Yi 03:44
Re: Why not use the calloc to replace malloc? Tom Lane 03:59
Re: Why not use the calloc to replace malloc? Thorsten Glaser 14:21
Re: Why not use the calloc to replace malloc? Tom Lane 15:04
Replicating / Updating Materialized views across databases Alex Magnum 15:39

April 24, 2023

Thread Author Time
alter table rename column can event trigger capture new column name jian he 02:46
Re: Support logical replication of DDLs shveta malik 02:48
Re: Logical replication failed with SSL SYSCALL error shaurya jain 02:59
Re: alter table rename column can event trigger capture new column name jian he 03:32
Re: Support logical replication of DDLs Amit Kapila 03:46
Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question Garfield Lewis 15:25
Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question Adrian Klaver 15:36
what happens if a failed transaction is not rolled back? Siddharth Jain 15:37
Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question Tom Lane 15:40
Re: what happens if a failed transaction is not rolled back? Adrian Klaver 15:43
Re: what happens if a failed transaction is not rolled back? Adrian Klaver 15:45
Re: what happens if a failed transaction is not rolled back? David G. Johnston 15:46
Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question Garfield Lewis 15:50
Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question Garfield Lewis 15:57
Re: what happens if a failed transaction is not rolled back? Luca Ferrari 16:24
Fwd: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency Max Kremer 19:50
Re: what happens if a failed transaction is not rolled back? David Wheeler 19:56
Re: what happens if a failed transaction is not rolled back? David G. Johnston 20:24
Re: what happens if a failed transaction is not rolled back? Tom Lane 21:20
RE: FW: Error! Arquimedes Aguirre 22:00
Re: FW: Error! Adrian Klaver 22:42
RE: FW: Error! Arquimedes Aguirre 23:16
Re: FW: Error! Adrian Klaver 23:34
Re: FW: Error! Erik Wienhold 23:48

April 25, 2023

Thread Author Time
Re: what happens if a failed transaction is not rolled back? Merlin Moncure 00:21
murmur3 hash binary data migration from Oracle to PostgreSQL Jagmohan Kaintura 01:21
Re: what happens if a failed transaction is not rolled back? Tom Lane 01:41
Re: what happens if a failed transaction is not rolled back? Merlin Moncure 02:06
wiki.postgres ​ Tighten trigger permission checks already resolved jian he 02:09
Re: murmur3 hash binary data migration from Oracle to PostgreSQL Erik Wienhold 02:15
Re: wiki.postgres ​ Tighten trigger permission checks already resolved Tom Lane 03:06
Re: murmur3 hash binary data migration from Oracle to PostgreSQL Jeffrey Walton 03:22
RE: Support logical replication of DDLs 📎 Zhijie Hou (Fujitsu) 03:57
Re: murmur3 hash binary data migration from Oracle to PostgreSQL Jagmohan Kaintura 10:44
Re: murmur3 hash binary data migration from Oracle to PostgreSQL Erik Wienhold 11:29
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist gzh 11:34
DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef' Matthias Apitz 12:41
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist Erik Wienhold 12:53
Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef' Ian Lawrence Barwick 12:58
Re: FW: Error! postgresql439848 14:31
Re: FW: Error! Adrian Klaver 15:02
Re: murmur3 hash binary data migration from Oracle to PostgreSQL Imre Samu 15:42
VACUUM (INDEX_CLEANUP OFF) and GIN indexes Christophe Pettus 16:17
Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes Peter Geoghegan 16:35
Re: VACUUM (INDEX_CLEANUP OFF) and GIN indexes Christophe Pettus 16:42
Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef' Peter J. Holzer 20:02

April 26, 2023

Thread Author Time
Re: FW: Error! postgresql439848 02:05
Re: Support logical replication of DDLs Masahiko Sawada 04:31
Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef' Matthias Apitz 05:32
Re: Support logical replication of DDLs Amit Kapila 05:56

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 28 29