pgsql-general since 2023-04-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)
Advanced Search

Browse Archives

Prev | Next

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
Re: Support logical replication of DDLs Masahiko Sawada 06:31
Re: Support logical replication of DDLs Masahiko Sawada 06:31
Re: Support logical replication of DDLs Amit Kapila 08:56
Re: Support logical replication of DDLs vignesh C 09:33
RE: Support logical replication of DDLs Zhijie Hou (Fujitsu) 11:31

April 27, 2023

Thread Author Time
PostgreSQL in-transit compression for a client connection Tushar Takate 09:18
Re: PostgreSQL in-transit compression for a client connection Daniel Gustafsson 09:22
Re: PostgreSQL in-transit compression for a client connection Laurenz Albe 09:24
Re: PostgreSQL in-transit compression for a client connection Dominique Devienne 09:44
Re: PostgreSQL in-transit compression for a client connection Laurenz Albe 09:55
Re:Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist gzh 11:20
Differential Backups in Windows server Rajmohan Masa 11:24
Re: Differential Backups in Windows server 📎 Ravi Krishna 12:39
Re: Differential Backups in Windows server Erik Wienhold 12:59
Re: Re:Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist Erik Wienhold 13:20
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist Tom Lane 14:11
Postgres query doesn't accept double quote around schema name in query statement Michael Xu 19:40
Re: Postgres query doesn't accept double quote around schema name in query statement Christophe Pettus 19:44
Re: Postgres query doesn't accept double quote around schema name in query statement Tom Lane 19:45
Re: Postgres query doesn't accept double quote around schema name in query statement Adrian Klaver 19:46
Re: Postgres query doesn't accept double quote around schema name in query statement Rob Sargent 21:02

April 28, 2023

Thread Author Time
Re: psql:t_mstr.sql:994: ERROR: function to_char(numeric) does not exist gzh 03:43
Re: Postgres query doesn't accept double quote around schema name in query statement Adrian Klaver 04:27
pg_class char type should be "char"? jian he 04:34
Re: PostgreSQL in-transit compression for a client connection Magnus Hagander 07:02
Re: PostgreSQL in-transit compression for a client connection Dominique Devienne 11:33
Re: Support logical replication of DDLs Amit Kapila 11:41
Re: HOT update: why must ALL indexes should be update? Bruce Momjian 20:08

April 29, 2023

Thread Author Time
Multiple Postgrest Verisons how to set one version as default. Gautham Raj 12:28
Re: Multiple Postgrest Verisons how to set one version as default. Ron 14:05
Re: Multiple Postgrest Verisons how to set one version as default. Adrian Klaver 14:42

May 1, 2023

Thread Author Time
Compiling postgres for windows with src/tools/msvc.build.bat Celso Lorenzetti 22:47

May 2, 2023

Thread Author Time
RE: Support logical replication of DDLs 📎 Zhijie Hou (Fujitsu) 02:23
Re: Support logical replication of DDLs shveta malik 03:00
Re: Compiling postgres for windows with src/tools/msvc.build.bat Magnus Hagander 08:10
libpq and multi-threading Michael J. Baars 09:38
Regarding SSL Enablement in PostgreSQL Database on different port sujay kadam 09:43
Re: Regarding SSL Enablement in PostgreSQL Database on different port Magnus Hagander 10:13
Re: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency Magnus Hagander 10:15
Re: libpq and multi-threading Laurenz Albe 13:49
Re: libpq and multi-threading Michael J. Baars 15:43
Re: libpq and multi-threading David G. Johnston 15:57
Re: libpq and multi-threading Michael J. Baars 16:09
Re: libpq and multi-threading Peter J. Holzer 17:57
Re: Regarding SSL Enablement in PostgreSQL Database on different port Tomas Pospisek 19:15
Re: Regarding SSL Enablement in PostgreSQL Database on different port Rob Sargent 19:25
Re: Regarding SSL Enablement in PostgreSQL Database on different port Christophe Pettus 19:26
RHEL repo package crc mismatches Evan Rempel 19:38

May 3, 2023

Thread Author Time
Can one user login in multile machine? Wen Yi 06:23
Re: RHEL repo package crc mismatches Brainmue 07:33
Re: Can one user login in multile machine? Ron 07:34
Re: Support logical replication of DDLs Alvaro Herrera 09:04
Re: libpq and multi-threading Michael J. Baars 11:11
PL/pgSQL doesn't support variables in queries? J.A. 12:25
Re: PL/pgSQL doesn't support variables in queries? hubert depesz lubaczewski 12:31
Re: libpq and multi-threading Michael Loftis 12:35
Re: PL/pgSQL doesn't support variables in queries? Erik Wienhold 12:39
Re: PL/pgSQL doesn't support variables in queries? J.A. 12:51
Re: RHEL repo package crc mismatches Devrim Gündüz 12:58
Why using a partial index is doing slightly more logical I/O than a normal index Dirschel, Steve 13:16
Re: PL/pgSQL doesn't support variables in queries? Erik Wienhold 13:26
Re: PL/pgSQL doesn't support variables in queries? Tom Lane 13:28
unknown postgres ssl error "could not accept SSL connection: Success" and timeout Sergey Cherevko 13:54
Re: PL/pgSQL doesn't support variables in queries? J.A. 14:34
Re: PL/pgSQL doesn't support variables in queries? David G. Johnston 14:40
Re: PL/pgSQL doesn't support variables in queries? Adrian Klaver 14:56
Re: libpq and multi-threading Michael J. Baars 15:23
Re: libpq and multi-threading Peter J. Holzer 15:54
Re: libpq and multi-threading Geoff Winkless 16:10
Re: unknown postgres ssl error "could not accept SSL connection: Success" and timeout Jeff Janes 16:17
Re: Can one user login in multile machine? Israel Brewster 16:43
Re: RHEL repo package crc mismatches Bruce Momjian 16:57
Re: RHEL repo package crc mismatches Brainmue 17:27
Re: Why using a partial index is doing slightly more logical I/O than a normal index Jeff Janes 17:37
RE: [EXT] Re: Why using a partial index is doing slightly more logical I/O than a normal index Dirschel, Steve 18:00
Invoking SQL function while doing CREATE OR REPLACE on it Nagendra Mahesh (namahesh) 18:17
Re: [EXT] Re: Why using a partial index is doing slightly more logical I/O than a normal index Tom Lane 19:00
Re: Invoking SQL function while doing CREATE OR REPLACE on it Erik Wienhold 21:03
Re: RHEL repo package crc mismatches Devrim Gündüz 22:23
Re: Invoking SQL function while doing CREATE OR REPLACE on it Tom Lane 23:19

May 4, 2023

Thread Author Time
Re: [EXT] Re: Why using a partial index is doing slightly more logical I/O than a normal index Jeff Janes 00:20
Re: RHEL repo package crc mismatches Evan Rempel 01:30
Re: RHEL repo package crc mismatches Brainmue 04:46
The logfile stop upgrade after a vim write lz ma 09:54
Re: The logfile stop upgrade after a vim write Erik Wienhold 10:37
Trigger questions DAVID ROTH 13:49
Re: Trigger questions Justin 14:03
Re: Trigger questions Adrian Klaver 14:30
Re: Trigger questions David G. Johnston 14:42
Re: Invoking SQL function while doing CREATE OR REPLACE on it Nagendra Mahesh (namahesh) 15:01
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 15:49
Re: "PANIC: could not open critical system index 2662" - twice Laurenz Albe 16:42
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 18:10
Re: "PANIC: could not open critical system index 2662" - twice Ron 18:16
Re: RHEL repo package crc mismatches Devrim Gündüz 18:43
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 23:15
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 23:27

May 5, 2023

Thread Author Time
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 00:02
What type of Compiler to SQL? Memory-Image (Load-and-Go) Format? Wen Yi 01:00
Re: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format? Bruce Momjian 01:16
Re: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format? Bruce Momjian 01:19
Re: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format? David G. Johnston 01:43
Re: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format? Christophe Pettus 01:51
Re: RHEL repo package crc mismatches Brainmue 04:55
connecting to localhost -> ::1 client_addr ? Luca Ferrari 07:23
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 07:50
Re: "PANIC: could not open critical system index 2662" - twice Andrew Gierth 08:38
Re: connecting to localhost -> ::1 client_addr ? Magnus Hagander 08:38
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 09:12
Re: Support logical replication of DDLs Peter Smith 10:09
customized function to Reconstructs the creating command for a role. jian he 11:03
SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java. sujay kadam 13:49
Assistance Needed: SSL Configuration in Postgres and Client Connection Setup sujay kadam 13:54
sorting problem with distinct on() Sky Lendar 13:55
Re: sorting problem with distinct on() David G. Johnston 14:16
Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java. Jeffrey Walton 14:16
Re: sorting problem with distinct on() Sky Lendar 14:25
Re: sorting problem with distinct on() Tom Lane 14:26
Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java. Adrian Klaver 15:06
Database size will be Huge difference while Restoring Rajmohan Masa 15:35
Re: Database size will be Huge difference while Restoring Adrian Klaver 16:22
Re: Database size will be Huge difference while Restoring Adrian Klaver 18:06
Re: Database size will be Huge difference while Restoring Adrian Klaver 18:12
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 23:06

May 6, 2023

Thread Author Time
Death postgres Marc Millas 01:14
Re: Death postgres Adrian Klaver 04:17
Re: Death postgres Peter J. Holzer 07:46
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 09:58
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 10:34
Re: Death postgres Marc Millas 12:19
Re: Death postgres Marc Millas 12:25
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 12:29
Re: Death postgres Ron 13:15
Re: Death postgres Marc Millas 13:49
Re: Death postgres Marc Millas 13:52
Re: Death postgres Ron 14:19
Re: Death postgres Thomas Guyot 14:48

Browse Archives

Prev | Next