pgsql-general since 2023-05-03 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 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
Re: Death postgres Adrian Klaver 16:11
Re: Death postgres Marc Millas 17:13
Check that numeric is zero Gabriel Furstenheim Milerud 18:46
Re: Death postgres Adrian Klaver 19:46
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 21:13
Re: Check that numeric is zero Andrew Gierth 22:07
Re: "PANIC: could not open critical system index 2662" - twice Jeffrey Walton 22:22
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 22:29

May 7, 2023

Thread Author Time
Re: "PANIC: could not open critical system index 2662" - twice Tom Lane 01:21
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 10:30
Re: Death postgres Marc Millas 11:46
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 16:10
Re: Death postgres Adrian Klaver 16:36
Hung Query with No Locking Issues Michael P. McDonnell 16:53
Re: Death postgres Laurenz Albe 18:42
Re: Hung Query with No Locking Issues Tom Lane 21:25
Re: Hung Query with No Locking Issues Michael P. McDonnell 23:42

May 8, 2023

Thread Author Time
Re: Hung Query with No Locking Issues Tom Lane 01:00
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 02:17
Re: "PANIC: could not open critical system index 2662" - twice Michael Paquier 02:24
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 02:46
Re: "PANIC: could not open critical system index 2662" - twice Michael Paquier 06:20
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 09:19
Re: "PANIC: could not open critical system index 2662" - twice Alvaro Herrera 09:53
Additive backup and restore? Age Apache 10:24
Re: Support logical replication of DDLs 📎 shveta malik 10:28
Re: Support logical replication of DDLs shveta malik 10:39
Re: Support logical replication of DDLs 📎 shveta malik 11:01
Re: Additive backup and restore? Andreas Kretschmer 11:02
huge discrepancy between EXPLAIN cost and actual time (but the table has just been ANALYZED) Kent Tong 12:29
Re: Additive backup and restore? Ron 13:36
Re: huge discrepancy between EXPLAIN cost and actual time (but the table has just been ANALYZED) Ron 13:43
Re: huge discrepancy between EXPLAIN cost and actual time (but the table has just been ANALYZED) Tom Lane 13:44
Re: "PANIC: could not open critical system index 2662" - twice Dilip Kumar 13:45
ICU, locale and collation question Oscar Carlberg 14:35
Re: "PANIC: could not open critical system index 2662" - twice Tom Lane 17:02
Re: "PANIC: could not open critical system index 2662" - twice Andres Freund 19:47
Re: ICU, locale and collation question Laurenz Albe 20:07
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 20:27
Re: "PANIC: could not open critical system index 2662" - twice Andres Freund 21:04
Re: "PANIC: could not open critical system index 2662" - twice Michael Paquier 21:45
Re: "PANIC: could not open critical system index 2662" - twice Tom Lane 22:04
Re: "PANIC: could not open critical system index 2662" - twice Thomas Munro 22:39
Re: "PANIC: could not open critical system index 2662" - twice Michael Paquier 22:55

May 9, 2023

Thread Author Time
Re: "PANIC: could not open critical system index 2662" - twice Andres Freund 00:46
Re: "PANIC: could not open critical system index 2662" - twice 📎 Andres Freund 01:32
Re: "PANIC: could not open critical system index 2662" - twice Dilip Kumar 04:03
Re: ICU, locale and collation question Oscar Carlberg 06:54
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 07:40
Return rows in input array's order? Dominique Devienne 08:34
Re: Return rows in input array's order? David Wheeler 09:22
Re: Return rows in input array's order? Dominique Devienne 09:37
Re: Return rows in input array's order? negora 09:57
Re: Return rows in input array's order? David Wheeler 10:35
Re: Support logical replication of DDLs 📎 shveta malik 10:53
Re: ICU, locale and collation question Laurenz Albe 13:31
Re: ICU, locale and collation question Peter Eisentraut 15:24
Re: Return rows in input array's order? Steven Lembark 21:11

May 10, 2023

Thread Author Time
Re: "PANIC: could not open critical system index 2662" - twice Kirk Wolak 04:39
Re: Return rows in input array's order? Kirk Wolak 04:59
Re: ICU, locale and collation question Kirk Wolak 05:02
Re: ICU, locale and collation question Peter Eisentraut 05:23
Re: Return rows in input array's order? Andrew Gierth 07:49
Re: Return rows in input array's order? Dominique Devienne 10:02
Re: Return rows in input array's order? Andrew Gierth 11:08
Patroni Issue Inzamam Shafiq 12:03
Re: Return rows in input array's order? Dominique Devienne 12:03
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 13:32
Re: Death postgres Marc Millas 14:35
Re: Death postgres Laurenz Albe 16:59
Re: Death postgres Peter J. Holzer 17:23
Re: Death postgres Marc Millas 20:52
Re: Death postgres Peter J. Holzer 23:56

May 11, 2023

Thread Author Time
Materialized Views - Way to refresh automatically (Incrementaly) FOUTE K. Jaurès 10:49
Re: Materialized Views - Way to refresh automatically (Incrementaly) Thomas Boussekey 11:01
[Beginner question]How to solve multiple definition of `yylval'? Wen Yi 11:52
Re: [Beginner question]How to solve multiple definition of `yylval'? Tom Lane 13:40
Re: Death postgres Marc Millas 14:18
order by Marc Millas 14:29
gather merge Marc Millas 14:38
Re: order by Adrian Klaver 14:43
Re: order by Adam Scott 14:48
Re: order by Marc Millas 14:55
Re: order by Marc Millas 15:00
Re: order by Adrian Klaver 15:23
Re: order by Marc Millas 15:29
Re: order by Adrian Klaver 15:37
Re: gather merge Marc Millas 17:04
Re: Death postgres Marc Millas 19:27
Re: order by Ron 21:08
Re: order by Ron 21:12
Re: order by Kirk Wolak 22:42
Re: "PANIC: could not open critical system index 2662" - twice Kirk Wolak 23:00
Re: huge discrepancy between EXPLAIN cost and actual time (but the table has just been ANALYZED) Kirk Wolak 23:13

May 12, 2023

Thread Author Time
Re: Materialized Views - Way to refresh automatically (Incrementaly) FOUTE K. Jaurès 04:50
Re: Death postgres Peter J. Holzer 06:31
Re: Support logical replication of DDLs 📎 shveta malik 06:33
Window function for get the last value to extend missing rows Durumdara 11:04
Adding SHOW CREATE TABLE Nathaniel Sabanski 11:29
Re: Adding SHOW CREATE TABLE Stephen Frost 13:47
Re: Adding SHOW CREATE TABLE Nathaniel Sabanski 14:34
Re: Adding SHOW CREATE TABLE Stephen Frost 14:40
Re: Adding SHOW CREATE TABLE Thorsten Glaser 15:35
Re: Death postgres Marc Millas 15:41
Re: Adding SHOW CREATE TABLE Thomas Kellerer 15:54
PG_Cron - Error Message Connection failed FOUTE K. Jaurès 16:03
Re: PG_Cron - Error Message Connection failed Fabricio Pedroso Jorge 16:05
Re: Adding SHOW CREATE TABLE David G. Johnston 16:12
Re: PG_Cron - Error Message Connection failed FOUTE K. Jaurès 16:22
Re: PG_Cron - Error Message Connection failed Adrian Klaver 16:23
Re: PG_Cron - Error Message Connection failed FOUTE K. Jaurès 16:41

Browse Archives

Prev | Next