Mailing lists [pgsql-general]

1 February 2020

• 06:00   Re: ERROR: too many dynamic shared memory segments Thomas Munro
• 06:08   Re: ERROR: too many dynamic shared memory segments Thomas Munro
• 13:21   Re: Need support on tuning at the time of index creation Peter J. Holzer

2 February 2020

• 12:24   How to avoid UPDATE on same data in table ? Condor
• 16:37   Re: How to avoid UPDATE on same data in table ? Andreas Kretschmer
• 17:43   Re: How to avoid UPDATE on same data in table ? Andreas Kretschmer
• 20:18   Re: How to avoid UPDATE on same data in table ? Tom Lane
• 22:17   Re: How to avoid UPDATE on same data in table ? Andreas Kretschmer

3 February 2020

• 00:06   Re: How to avoid UPDATE on same data in table ? Adrian Klaver
• 09:47   Restrict connection from pgadmin. Pawan Sharma
• 11:27   Re: How to avoid UPDATE on same data in table ? Condor
• 11:29   Re: How to avoid UPDATE on same data in table ? Andrei Zhidenkov
• 16:09   Slow Query, many tmpfiles basti
• 19:01   Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI Steven Lembark
• 19:02   Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI Steven Lembark
• 19:24   Re: How to avoid UPDATE on same data in table ? Condor
• 19:57   Re: performance of loading CSV data with COPY is 50 times faster thanPerl::DBI Ravi Krishna
• 20:03   Re: Restrict connection from pgadmin. Adrian Klaver
• 20:13   Re: Restrict connection from pgadmin. David G. Johnston
• 20:15   Re: Restrict connection from pgadmin. Ravi Krishna
• 20:43   Re: Restrict connection from pgadmin. Adrian Klaver
• 20:58   Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI Matthias Apitz
• 21:28   Re: performance of loading CSV data with COPY is 50 times faster thanPerl::DBI bret_stern
• 21:42   Re: performance of loading CSV data with COPY is 50 times faster thanPerl::DBI Ravi Krishna
• 21:54   Re: Slow Query, many tmpfiles Tom Lane
• 22:35   Re: performance of loading CSV data with COPY is 50 times faster thanPerl::DBI Ron
• 23:20   Should I reinstall over current installation? Chris Charley
• 23:26   Re: Should I reinstall over current installation? Adrian Klaver
• 23:47   Re: Should I reinstall over current installation? Adrian Klaver
• 23:54   Re: Should I reinstall over current installation? Chris Charley

4 February 2020

• 00:01   Re: Should I reinstall over current installation? Adrian Klaver
• 00:11   Re: Should I reinstall over current installation? Chris Charley
• 00:23   Re: Should I reinstall over current installation? Adrian Klaver
• 00:43   Postgres Crashing Doug Roberts
• 00:49   Re: Postgres Crashing Adrian Klaver
• 01:28   Re: Postgres Crashing Tom Lane
• 01:34   Re: Postgres Crashing Adrian Klaver
• 02:16   Re: Should I reinstall over current installation? Chris Charley
• 02:21   Re: Postgres Crashing Tom Lane
• 02:22   Re: Should I reinstall over current installation? Adrian Klaver
• 08:55   Re: Restrict connection from pgadmin. Pawan Sharma
• 09:07   Re: Restrict connection from pgadmin. Tom Lane
• 17:20   Re: Postgres Crashing Doug Roberts
• 19:06   Re: Postgres Crashing Doug Roberts
• 19:18   Re: Postgres Crashing Adrian Klaver
• 19:27   Re: Postgres Crashing Doug Roberts
• 19:40   Re: Postgres Crashing Adrian Klaver
• 20:58   RE: Add column with default value in big table - splitting of updatescan help? Kevin Brannen
• 22:19   Re: Postgres Crashing Doug Roberts
• 22:34   Re: Postgres Crashing Tom Lane
• 23:18   Re: Should I reinstall over current installation? Chris Charley
• 23:22   Better documentation for schema changes in logical replication Mike Lissner

5 February 2020

• 00:21   Re: Postgres Crashing Doug Roberts
• 01:12   Re: Restrict connection from pgadmin. raf
• 03:36   The best way to solve a problem Nikolai Lusan
• 04:14   Re: The best way to solve a problem David G. Johnston
• 10:18   Re: The best way to solve a problem Nikolai Lusan
• 11:06   Force Commit İlyas Derse
• 11:11   Re: Force Commit Pavel Stehule
• 11:24   Restore is failing Sonam Sharma
• 11:31   Re: Restore is failing Rob Sargent
• 11:47   Re: Restore is failing Sonam Sharma
• 12:22   Re: Force Commit Andrei Zhidenkov
• 12:22   Read: The best way to solve a problem Satheesh-Gsuite
• 13:40   Re: Restore is failing Peter J. Holzer
• 13:48   Get rid of brackets around variable Raul Kaubi
• 14:10   Re: Get rid of brackets around variable Geoff Winkless
• 14:14   Unable to startup postgres: Could not read from file "pg_clog/00EC" Nick Renders
• 14:21   Declare variable from other variable Raul Kaubi
• 14:22   Re: Get rid of brackets around variable Raul Kaubi
• 14:45   Re: Should I reinstall over current installation? Moreno Andreo
• 14:51   Re: Unable to startup postgres: Could not read from file"pg_clog/00EC" Alvaro Herrera
• 15:28   Re: Declare variable from other variable Yasin Sari
• 15:29   Re: Declare variable from other variable Thomas Kellerer
• 15:42   Re: Declare variable from other variable Raul Kaubi
• 15:50   Re: Declare variable from other variable hubert depesz lubaczewski
• 17:02   Re: Declare variable from other variable Raul Kaubi
• 17:17   Error handling: Resume work after error Raul Kaubi
• 18:03   Re: Error handling: Resume work after error hubert depesz lubaczewski
• 18:22   Re: initialize and use variable in query Олег Самойлов
• 18:23   Re: Error handling: Resume work after error Raul Kaubi
• 18:43   Re: Restore is failing Adrian Klaver
• 20:15   Re: Should I reinstall over current installation? Chris Charley
• 20:30   Weird behavior with update cascade on partitioned tables when moving data between partitions Márcio Antônio Sepp
• 21:59   Re: calculating the MD5 hash of role passwords in C Stephen Frost

6 February 2020

• 05:54   POLL: Adding transaction status to default psql prompt Vik Fearing
• 06:13   Re: POLL: Adding transaction status to default psql prompt Nikolay Samokhvalov
• 06:15   RE: POLL: Adding transaction status to default psql prompt Ahmed, Nawaz (Fuji Xerox Australia)
• 06:41   Re: POLL: Adding transaction status to default psql prompt Matt Zagrabelny
• 06:49   Re: POLL: Adding transaction status to default psql prompt Ian Barwick
• 06:55   Re: POLL: Adding transaction status to default psql prompt Steve Baldwin
• 07:05   Re: POLL: Adding transaction status to default psql prompt Vik Fearing
• 07:14   Re: POLL: Adding transaction status to default psql prompt Hari Kiran
• 08:16   Re: POLL: Adding transaction status to default psql prompt Michael Paquier
• 08:17   Re: POLL: Adding transaction status to default psql prompt Christophe Pettus
• 08:18   Re: POLL: Adding transaction status to default psql prompt Adrian Klaver
• 08:22   Re: POLL: Adding transaction status to default psql prompt David G. Johnston
• 08:52   Re: POLL: Adding transaction status to default psql prompt Daevor The Devoted
• 09:11   Re: POLL: Adding transaction status to default psql prompt Laurenz Albe
• 10:20   Re: POLL: Adding transaction status to default psql prompt Guillaume Lelarge
• 12:36   Function not imported in Entity Framework Vikram Sah
• 13:21   Re: POLL: Adding transaction status to default psql prompt hubert depesz lubaczewski
• 13:33   Re: POLL: Adding transaction status to default psql prompt Daniel Westermann (DWE)
• 13:44   Re: POLL: Adding transaction status to default psql prompt Ray O'Donnell
• 15:47   Re: Unable to startup postgres: Could not read from file"pg_clog/00EC" Nick Renders
• 16:36   Re: POLL: Adding transaction status to default psql prompt Victor Yegorov
• 17:06   Re: POLL: Adding transaction status to default psql prompt Charles Clavadetscher
• 18:38   Re: Function not imported in Entity Framework Adrian Klaver
• 19:32   Re: POLL: Adding transaction status to default psql prompt Fabrízio de Royes Mello

7 February 2020

• 01:01   Re: Unable to startup postgres: Could not read from file "pg_clog/00EC" Thomas Munro
• 02:00   Re: POLL: Adding transaction status to default psql prompt Nikolay Samokhvalov
• 04:29   Re: POLL: Adding transaction status to default psql prompt Ken Tanzer
• 08:02   deallocate statement failing rob stone
• 08:15   Re: deallocate statement failing Adrian Klaver
• 08:48   Re: deallocate statement failing Tom Lane
• 09:46   Re: deallocate statement failing rob stone
• 11:35   sensible configuration of max_connections Chris Withers
• 15:49   Fwd: sensible configuration of max_connections Chris Ellis
• 16:18   Re: Fwd: sensible configuration of max_connections Chris Withers
• 16:29   Re: sensible configuration of max_connections Justin
• 16:35   Re: Fwd: sensible configuration of max_connections Steve Atkins
• 19:48   periodic refresh of pre-production stages Zwettler Markus (OIZ)
• 19:52   Re: POLL: Adding transaction status to default psql prompt Kasun Kulathunga
• 21:06   Re: sensible configuration of max_connections Michael Lewis
• 21:56   Re: Fwd: sensible configuration of max_connections Sam Gendler
• 22:14   Re: Fwd: sensible configuration of max_connections Justin
• 23:38   Re: periodic refresh of pre-production stages Adrian Klaver
• 23:40   Re: Fwd: sensible configuration of max_connections Sam Gendler

8 February 2020

• 02:06   Query returns no results until REINDEX Colin Adler
• 04:07   Re: Query returns no results until REINDEX Peter Geoghegan
• 23:09   Postgres 12.1 : UPPER() in WHERE clause restarts server Nick Renders
• 23:16   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Adrian Klaver
• 23:28   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Marc

9 February 2020

• 00:18   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Adrian Klaver
• 01:24   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Marc
• 01:40   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Christoph Moench-Tegeder
• 01:45   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Tom Lane
• 01:52   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Adrian Klaver
• 18:28   Re: Unable to startup postgres: Could not read from file"pg_clog/00EC" Marc
• 18:35   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Marc
• 23:50   Re: Query returns no results until REINDEX Colin Adler

10 February 2020

• 05:04   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Thomas Munro
• 11:03   work_mem and shared_buffers question Ayub M
• 11:50   Re: work_mem and shared_buffers question Naresh g
• 13:30   Re: work_mem and shared_buffers question Ayub M
• 13:34   Re: work_mem and shared_buffers question Naresh g

11 February 2020

• 00:59   Pre-version pg_upgrade syntax check Rich Shepard
• 01:00   Re: Pre-version pg_upgrade syntax check Rich Shepard
• 01:59   Re: Pre-version pg_upgrade syntax check Adrian Klaver
• 02:30   Re: Pre-version pg_upgrade syntax check Rich Shepard
• 02:40   Re: Pre-version pg_upgrade syntax check Rich Shepard
• 02:45   Re: Pre-version pg_upgrade syntax check Adrian Klaver
• 03:07   Re: Pre-version pg_upgrade syntax check Rich Shepard
• 03:50   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Jerry Sievers
• 03:58   Re: Pre-version pg_upgrade syntax check Adrian Klaver
• 04:51   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Thomas Munro
• 14:32   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Nick Renders
• 14:56   Re: Function not imported in Entity Framework Vikram Sah
• 16:43   Re: Pre-version pg_upgrade syntax check Rich Shepard
• 18:05   Re: PostgreSQL Installer issue George Weaver
• 18:24   Re: Pre-version pg_upgrade syntax check Rich Shepard
• 18:29   Re: Pre-version pg_upgrade syntax check [FIXED] Rich Shepard
• 19:27   Re: Function not imported in Entity Framework Adrian Klaver
• 19:31   Re: Pre-version pg_upgrade syntax check Adrian Klaver
• 19:32   JIT on Windows with Postgres 12.1 Catch All
• 19:35   Re: Function not imported in Entity Framework Vikram Sah
• 19:45   Re: Function not imported in Entity Framework Adrian Klaver
• 20:00   Re: Pre-version pg_upgrade syntax check Rich Shepard
• 20:44   Re: Pre-version pg_upgrade syntax check Adrian Klaver
• 22:32   Re: Query returns no results until REINDEX Peter Geoghegan
• 23:13   Re: Query returns no results until REINDEX Julien Rouhaud

12 February 2020

• 01:26   How to restore roles without changing postgres password Andrus
• 01:37   Re: How to restore roles without changing postgres password Justin
• 01:46   Re: How to restore roles without changing postgres password Tom Lane
• 02:04   Re: How to restore roles without changing postgres password Justin
• 04:17   Re: Function not imported in Entity Framework Vikram Sah
• 10:22   Re: POLL: Adding transaction status to default psql prompt Anthony Nowocien
• 10:31   Re: How to restore roles without changing postgres password Andrus
• 11:39   Re: JIT on Windows with Postgres 12.1 Josef Šimánek
• 12:06   Avoiding out of date statistics / planner Tim Kane
• 12:22   pg_basebackup connection closed unexpectedly... Mladen Marinović
• 13:06   Re: How to restore roles without changing postgres password Andrus
• 14:52   RE: Function not imported in Entity Framework farjad.farid
• 15:42   Help : Removal of leading spaces in all the columns of a table srikkanth
• 16:23   Re: Help : Removal of leading spaces in all the columns of a table Charles Clavadetscher
• 17:00   Re: Help : Removal of leading spaces in all the columns of a table Charles Clavadetscher
• 17:09   Re: Help : Removal of leading spaces in all the columns of a table Susan Hurst
• 17:33   Re: Help : Removal of leading spaces in all the columns of a table Rob Sargent
• 18:09   Re: pg_basebackup connection closed unexpectedly... Tom Lane
• 18:15   Re: Avoiding out of date statistics / planner Tom Lane
• 18:45   Natural sort order extension. Dmitry Igrishin
• 19:39   Re: How to restore roles without changing postgres password Adrian Klaver
• 19:55   Re: Natural sort order extension. Laurenz Albe
• 19:59   Re: How to restore roles without changing postgres password Tom Lane
• 19:59   Re: How to restore roles without changing postgres password Tom Lane
• 20:14   Re: Natural sort order extension. Dmitry Igrishin
• 20:23   Re: Avoiding out of date statistics / planner Michael Lewis
• 22:42   Re: JIT on Windows with Postgres 12.1 Andres Freund
• 22:54   Re: JIT on Windows with Postgres 12.1 Tom Lane
• 23:01   Re: JIT on Windows with Postgres 12.1 Justin
• 23:05   Re: JIT on Windows with Postgres 12.1 Andres Freund
• 23:32   Re: Avoiding out of date statistics / planner Tomas Vondra

13 February 2020

• 04:12   Re: Function not imported in Entity Framework Vikram Sah
• 06:25   Re: JIT on Windows with Postgres 12.1 Michael Paquier
• 06:32   Re: JIT on Windows with Postgres 12.1 Andres Freund
• 06:49   Re: JIT on Windows with Postgres 12.1 Michael Paquier
• 12:41   Re: pg_basebackup connection closed unexpectedly... Mladen Marinović
• 15:31   pg_upgrade —link does it remove table bloat Jason Ralph
• 16:19   Re: Avoiding out of date statistics / planner Tim Kane
• 16:34   Enabling extensions on a compiled instance of postgresql 12.1 Sterpu Victor
• 16:48   Re: Enabling extensions on a compiled instance of postgresql 12.1 Julien Rouhaud
• 17:11   Re[2]: Enabling extensions on a compiled instance of postgresql 12.1 Sterpu Victor
• 18:45   Re: pg_upgrade —link does it remove table bloat Adrian Klaver
• 21:02   Re: pg_upgrade —link does it remove table bloat Michael Lewis
• 21:04   RE: pg_upgrade —link does it remove table bloat Jason Ralph
• 21:16   Re: pg_upgrade —link does it remove table bloat Adrian Klaver
• 22:07   RE: pg_upgrade —link does it remove table bloat Jason Ralph
• 23:19   Re: pg_upgrade —link does it remove table bloat Adrian Klaver
• 23:45   RE: pg_upgrade —link does it remove table bloat Jason Ralph

14 February 2020

• 02:20   Re: pg_upgrade —link does it remove table bloat Adrian Klaver
• 06:00   RE: pg_upgrade —link does it remove table bloat Jason Ralph
• 06:54   Cannot connect to postgresql-11 from another machine after boot Jason Swails
• 08:02   Re: Cannot connect to postgresql-11 from another machine after boot Adrian Klaver
• 08:03   Re: Cannot connect to postgresql-11 from another machine after boot Adrian Klaver
• 15:39   PL/pgSQL question about EXCEPTION clause & corrupt records Nick Renders
• 17:53   Re: PL/pgSQL question about EXCEPTION clause & corrupt records Achilleas Mantzios
• 18:14   Re: PL/pgSQL question about EXCEPTION clause & corrupt records Tom Lane

15 February 2020

• 07:30   Re: PL/pgSQL question about EXCEPTION clause & corrupt records Jeremy Schneider

16 February 2020

• 16:51   Re: Cannot connect to postgresql-11 from another machine after boot Peter J. Holzer

17 February 2020

• 00:02   parsing xml with PG 9.2.4 Mario Vlahovic
• 05:16   Re: 1 Status of vertical clustered index - 2 Join using(fk_constraint) suggestion - 3 Status of pgsql's parser autonomization Imre Samu
• 12:50   Postgres error Loai Abdallatif
• 13:48   Compiling via LLVM and active LTO Sapd
• 14:32   Re: PL/pgSQL question about EXCEPTION clause & corrupt records Nick Renders
• 14:36   Re: PL/pgSQL question about EXCEPTION clause & corrupt records Nick Renders
• 17:04   Cases where alter table set type varchar(longer length) still needstable rewrite Jeremy Finzel
• 17:21   Re: Cases where alter table set type varchar(longer length) still needs table rewrite Tom Lane
• 18:01   Re: Cases where alter table set type varchar(longer length) stillneeds table rewrite Jeremy Finzel
• 18:08   Re: Cases where alter table set type varchar(longer length) stillneeds table rewrite Ron
• 18:17   Re: Cannot connect to postgresql-11 from another machine after boot Jason Swails
• 18:49   DBI && INSERT Matthias Apitz
• 19:15   Re: DBI && INSERT Gianni Ceccarelli
• 19:23   Re: PL/pgSQL question about EXCEPTION clause & corrupt records Jeremy Schneider
• 19:42   Re: Cannot connect to postgresql-11 from another machine after boot Adrian Klaver
• 19:46   Re: Cases where alter table set type varchar(longer length) stillneeds table rewrite Adrian Klaver
• 19:53   Re: Postgres error Adrian Klaver
• 19:55   Re: parsing xml with PG 9.2.4 Jimmy Angelakos
• 21:17   Re: PL/pgSQL question about EXCEPTION clause & corrupt records Jeremy Schneider
• 21:19   Re: Cases where alter table set type varchar(longer length) still needs table rewrite Tom Lane
• 21:39   Re: Cases where alter table set type varchar(longer length) stillneeds table rewrite Jeremy Finzel
• 22:21   Re: Postgres error Loai Abdallatif

18 February 2020

• 01:07   pgstattuple extension - Can pgstattuple_approx support toast tables? Jean-Marc Lessard
• 01:46   policies and extensions Marc Munro
• 06:28   Re: policies and extensions Adrian Klaver
• 06:48   Re: policies and extensions Tom Lane
• 12:46   Logical Replication ERROR reporting issue Ranjan Gajare
• 19:53   Re: policies and extensions Marc Munro
• 20:30   Re: policies and extensions Tom Lane
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:46   DB running out of memory issues after upgrade Nagaraj Raj
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 20:58   Re: DB running out of memory issues after upgrade Tomas Vondra
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:10   Re: DB running out of memory issues after upgrade Nagaraj Raj
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:38   Re: DB running out of memory issues after upgrade Merlin Moncure
• 21:40   How to handle CASE statement with PostgreSQL without need for typecasting Anthony Hall
• 21:51   Re: How to handle CASE statement with PostgreSQL without need for typecasting John W Higgins
• 22:07   Re: Is is safe to use SPI in multiple threads? Tom Mercha
• 22:39   pglogical install errors openSUSE Leap 42.1 Bellrose, Brian
• 23:06   Re: policies and extensions Stephen Frost
• 23:43   Re: How to handle CASE statement with PostgreSQL without need fortypecasting Adrian Klaver
• 23:48   Re: pglogical install errors openSUSE Leap 42.1 Adrian Klaver
• 23:54   RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Bellrose, Brian

19 February 2020

• 00:18   Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Adrian Klaver
• 00:22   RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Bellrose, Brian
• 00:41   Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Adrian Klaver
• 00:56   RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Bellrose, Brian
• 01:00   Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Adrian Klaver
• 01:07   RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Bellrose, Brian
• 01:15   Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Adrian Klaver
• 02:26   Re: policies and extensions Marc Munro
• 04:22   Re: How to handle CASE statement with PostgreSQL without need fortypecasting Kyotaro Horiguchi
• 14:33   Runtime partition pruning with hash partitioning Pavel Luzanov
• 17:07   Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Giulio Calacoci
• 17:12   RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Bellrose, Brian

20 February 2020

• 12:37   Re: ERROR: too many dynamic shared memory segments dainius.b
• 12:54   Trying to restore a PostgreSQL-9.6 database from an old complete dumpand/or a up-to-date just base directory and other rescued files al
• 17:47   Re: Trying to restore a PostgreSQL-9.6 database from an old complete dump and/or a up-to-date just base directory and other rescued files Tom Lane
• 20:24   Re: Trying to restore a PostgreSQL-9.6 database from an old completedump and/or a up-to-date just base directory and other rescued files al
• 21:24   Error “cache lookup failed for function” Albrecht Dreß
• 21:32   Re: Error “cache lookup failed for function” Tom Lane
• 21:57   Re: Error “cache lookup failed for function” Tom Lane
• 22:03   RE: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1 Bellrose, Brian
• 22:18   Re: Error “cache lookup failed for function” Michael Lewis
• 22:28   Re: Error“cache lookup failed for function” Albrecht Dreß
• 22:47   Re: Error “cache lookup failed for function” Tom Lane
• 23:17   before insert for each row trigger on upsert Ted Toth
• 23:32   Re: before insert for each row trigger on upsert Adrian Klaver
• 23:35   How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 23:41   Re: Error “cache lookup failed for function” Adrian Klaver
• 23:46   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 23:52   Re: How to fix 0xC0000005 exception in Postgres 9.0 Justin

21 February 2020

• 00:03   Re: before insert for each row trigger on upsert Ted Toth
• 00:26   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 00:27   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 00:40   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 00:43   Re: before insert for each row trigger on upsert Adrian Klaver
• 01:09   spectrogram index? Roberto Della Pasqua
• 01:11   Re: before insert for each row trigger on upsert Tom Lane
• 01:29   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 01:35   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 01:42   Re: How to fix 0xC0000005 exception in Postgres 9.0 Alvaro Herrera
• 01:47   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 01:48   Re: How to fix 0xC0000005 exception in Postgres 9.0 Ron
• 01:49   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 01:50   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 02:17   Re: How to fix 0xC0000005 exception in Postgres 9.0 Ron
• 02:20   Re: How to fix 0xC0000005 exception in Postgres 9.0 David G. Johnston
• 04:11   Re: How to fix 0xC0000005 exception in Postgres 9.0 Justin
• 08:34   Can we have multiple tablespaces with in a database. Daulat Ram
• 08:34   Can we have multiple tablespaces with in a database. Daulat Ram
• 08:46   Re: Can we have multiple tablespaces with in a database. amul sul
• 08:46   Re: Can we have multiple tablespaces with in a database. amul sul
• 08:46   Re: Can we have multiple tablespaces with in a database. David G. Johnston
• 08:46   Re: Can we have multiple tablespaces with in a database. David G. Johnston
• 09:00   Re: Can we have multiple tablespaces with in a database. Ron
• 09:01   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 09:01   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 09:18   Re: Can we have multiple tablespaces with in a database. amul sul
• 09:18   Re: Can we have multiple tablespaces with in a database. amul sul
• 09:23   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 09:23   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 09:26   Re: Can we have multiple tablespaces with in a database. amul sul
• 09:26   Re: Can we have multiple tablespaces with in a database. amul sul
• 09:27   Re: Can we have multiple tablespaces with in a database. Christophe Pettus
• 09:34   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 09:36   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 09:36   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 09:36   Re: Can we have multiple tablespaces with in a database. Christophe Pettus
• 10:17   RE: Can we have multiple tablespaces with in a database. Daulat Ram
• 13:42   How to get the name of the table taht fired a triigger? stan
• 14:16   Parallel Append Query Luís Roberto Weck
• 14:50   Re: Can we have multiple tablespaces with in a database. amul sul
• 17:27   Re: How to get the name of the table taht fired a triigger? David G. Johnston
• 19:12   Logical replication lag in seconds Klaus Darilion
• 20:01   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 20:27   Re: How to fix 0xC0000005 exception in Postgres 9.0 Justin
• 20:29   Re: How to fix 0xC0000005 exception in Postgres 9.0 Justin
• 20:55   Re: Error“cache lookup failed for function” Albrecht Dreß
• 21:24   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 21:44   Re: How to fix 0xC0000005 exception in Postgres 9.0 Justin
• 23:02   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 23:22   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 23:24   Re: Logical replication lag in seconds Michael Lewis
• 23:44   Re: Error “cache lookup failed for function” Adrian Klaver
• 23:50   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus

22 February 2020

• 00:24   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 00:56   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 01:26   Shared buffer hash table corrupted Mark Fletcher
• 01:53   Re: Shared buffer hash table corrupted Tom Lane
• 03:24   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 04:07   aws sct/dms versus ora2pg Ayub M
• 10:43   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 11:26   Reset DB stats suggestion pg_stat_reset() postggen2020 s
• 11:26   Reset DB stats suggestion pg_stat_reset() postggen2020 s
• 20:17   Re: Reset DB stats suggestion pg_stat_reset() Adrian Klaver
• 20:17   Re: Reset DB stats suggestion pg_stat_reset() Adrian Klaver
• 20:25   Replication: slave server has 3x size of production server?  Edson Richter
• 20:28   Re: Shared buffer hash table corrupted Mark Fletcher
• 20:33   Re: Replication: slave server has 3x size of production server? Adrian Klaver
• 20:34   Re: Shared buffer hash table corrupted Tom Lane
• 20:44   Re: Shared buffer hash table corrupted Mark Fletcher
• 21:05   RE: Replication: slave server has 3x size of production server? Edson Richter
• 21:34   how to find a tablespace for the table? Daulat Ram
• 21:45   Re: how to find a tablespace for the table? Adrian Klaver
• 21:50   Re: Replication: slave server has 3x size of production server? Adrian Klaver
• 22:03   RE: Replication: slave server has 3x size of production server? Edson Richter
• 22:16   Re: Replication: slave server has 3x size of production server? Adrian Klaver
• 22:23   RE: Replication: slave server has 3x size of production server? Edson Richter

23 February 2020

• 00:02   Can I trigger an action from a coalesce ? stan
• 00:05   Re: Can I trigger an action from a coalesce ? Adrian Klaver
• 00:06   Re: Can I trigger an action from a coalesce ? Christophe Pettus
• 00:10   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 00:12   Re: Replication: slave server has 3x size of production server? Adrian Klaver
• 00:33   Re: Can I trigger an action from a coalesce ? stan
• 00:46   Re: Can I trigger an action from a coalesce ? Christophe Pettus
• 01:02   Re: Can I trigger an action from a coalesce ? Tom Lane
• 01:07   Re: Can I trigger an action from a coalesce ? Christophe Pettus
• 01:25   Re: Logical replication lag in seconds Klaus Darilion
• 01:32   Re: Cannot connect to postgresql-11 from another machine after boot Peter J. Holzer
• 01:36   Re: Can I trigger an action from a coalesce ? Tom Lane
• 01:37   How to get error message details from libpq based psqlODBC driver (regression) Andrus
• 01:37   Re: Can I trigger an action from a coalesce ? Christophe Pettus
• 01:39   Re: How to fix 0xC0000005 exception in Postgres 9.0 Andrus
• 01:51   RE: Replication: slave server has 3x size of production server? Edson Richter
• 02:12   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 02:19   Re: How to get error message details from libpq based psqlODBC driver(regression) Adrian Klaver
• 02:23   Re: How to get error message details from libpq based psqlODBC driver(regression) Ron
• 02:28   Re: How to fix 0xC0000005 exception in Postgres 9.0 Ron
• 02:34   Re: Replication: slave server has 3x size of production server? Adrian Klaver
• 02:35   Re: How to fix 0xC0000005 exception in Postgres 9.0 Rob Sargent
• 02:35   Re: How to fix 0xC0000005 exception in Postgres 9.0 Stephen Frost
• 02:44   Re: How to fix 0xC0000005 exception in Postgres 9.0 Adrian Klaver
• 05:40   Re: Reset DB stats suggestion pg_stat_reset() postggen2020 s
• 05:40   Re: Reset DB stats suggestion pg_stat_reset() postggen2020 s
• 12:06   Re: How to get error message details from libpq based psqlODBC driver (regression) Andrus
• 13:19   Re: DB running out of memory issues after upgrade Peter J. Holzer
• 14:21   Re: Can I trigger an action from a coalesce ? Peter J. Holzer
• 15:55   Re: Is is safe to use SPI in multiple threads? Peter J. Holzer
• 19:04   RE: Replication: slave server has 3x size of production server? Edson Richter
• 21:19   Re: Reset DB stats suggestion pg_stat_reset() Adrian Klaver
• 21:19   Re: Reset DB stats suggestion pg_stat_reset() Adrian Klaver
• 21:34   Re: How to get error message details from libpq based psqlODBC driver(regression) Adrian Klaver
• 21:42   Re: Replication: slave server has 3x size of production server? Adrian Klaver
• 22:15   Re: How to get error message details from libpq based psqlODBC driver (regression) Andrus
• 22:25   Re: Reset DB stats suggestion pg_stat_reset() Adrian Klaver
• 22:25   Re: Reset DB stats suggestion pg_stat_reset() Adrian Klaver

24 February 2020

• 00:00   RE: Replication: slave server has 3x size of production server? Edson Richter
• 08:20   Re: Can I trigger an action from a coalesce ? sivapostgres@yahoo.com
• 11:18   Backup & Restore Dor Ben Dov
• 12:24   Re: Can I trigger an action from a coalesce ? Peter J. Holzer
• 15:48   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Nick Renders
• 18:23   backup broken bvo
• 18:24   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Tom Lane
• 18:50   Re: backup broken bvo
• 20:54   Re: Reset DB stats suggestion pg_stat_reset() Michael Lewis
• 22:50   LDAP with TLS is taking more time in Postgresql 11.5 Mani Sankar
• 22:50   LDAP with TLS is taking more time in Postgresql 11.5 Mani Sankar
• 22:54   Re: Backup & Restore Andreas Kretschmer
• 23:16   Re: Backup & Restore Stephen Frost
• 23:58   Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver
• 23:58   Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver

25 February 2020

• 04:55   Re: Backup & Restore sivapostgres@yahoo.com
• 11:01   Trigger Sonam Sharma
• 12:20   Re: LDAP with TLS is taking more time in Postgresql 11.5 Laurenz Albe
• 12:20   Re: LDAP with TLS is taking more time in Postgresql 11.5 Laurenz Albe
• 12:35   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Nick Renders
• 12:55   Re: Replication: slave server has 3x size of production server? Jehan-Guillaume de Rorthais
• 13:17   a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Stanislav Motyčka
• 13:30   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Josef Šimánek
• 13:52   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]] Fabio Ugo Venchiarutti
• 14:19   Re: aws sct/dms versus ora2pg Gilles Darold
• 14:58   Upgrade to 12.2 using same data directory Mihalidesová Jana
• 15:04   Re: Upgrade to 12.2 using same data directory Josef Šimánek
• 15:22   Re: Upgrade to 12.2 using same data directory Sushant Pawar
• 15:52   RE: Upgrade to 12.2 using same data directory Mihalidesová Jana
• 15:54   Re: Upgrade to 12.2 using same data directory Josef Šimánek
• 15:54   Re: Upgrade to 12.2 using same data directory Ray O'Donnell
• 15:55   RE: Upgrade to 12.2 using same data directory Mihalidesová Jana
• 15:59   RE: Upgrade to 12.2 using same data directory Mihalidesová Jana
• 16:13   Re: Upgrade to 12.2 using same data directory Sushant Pawar
• 16:38   Re: Upgrade to 12.2 using same data directory Paul Förster
• 16:53   Re: Backup & Restore Stephen Frost
• 17:35   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Miles Elam
• 17:35   Re: Upgrade to 12.2 using same data directory Laurenz Albe
• 17:41   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Josef Šimánek
• 17:50   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Miles Elam
• 18:41   Highly academic: local etcd & Patroni Cluster for testing on a singlehost Paul Förster
• 18:54   Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver
• 19:14   Re: Trigger Adrian Klaver
• 19:53   Re: Trigger Adrian Klaver
• 20:01   Re: Connections dropping while using Postgres backend DB with Ejabberd Justin
• 20:08   Re: Trigger Alban Hertroys
• 20:13   Re: Trigger Adrian Klaver
• 20:20   Re: Connections dropping while using Postgres backend DB with Ejabberd Michael Lewis
• 21:08   Re: LDAP with TLS is taking more time in Postgresql 11.5 Mani Sankar
• 21:18   Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver
• 21:23   Re: LDAP with TLS is taking more time in Postgresql 11.5 Mani Sankar
• 21:37   Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver
• 22:16   Re: Connections dropping while using Postgres backend DB with Ejabberd Dipanjan Ganguly
• 22:28   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Paul A Jungwirth
• 22:35   Re: Connections dropping while using Postgres backend DB with Ejabberd Justin
• 22:39   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]] Guyren Howe
• 22:46   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]] Stanislav Motycka
• 22:53   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]] Alvaro Herrera
• 22:53   Re: Connections dropping while using Postgres backend DB with Ejabberd Dipanjan Ganguly

26 February 2020

• 00:00   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1[,col2]] Paul Jungwirth
• 00:13   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Tom Lane
• 00:51   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Rob Sargent
• 03:38   Re: Highly academic: local etcd & Patroni Cluster for testing on asingle host Ian Barwick
• 04:14   Re: LDAP with TLS is taking more time in Postgresql 11.5 Thomas Munro
• 07:53   information_schema performance in Postgres 12 Eric Gillum
• 08:29   Re: a proposal for a new functionality: "SELECT * [EXCEPT col1 [,col2]] Pavel Stehule
• 08:57   Re: Backup & Restore Adrian Ho
• 09:21   Re: Backup & Restore sivapostgres@yahoo.com
• 09:25   Re: Backup & Restore Thomas Kellerer
• 10:55   Re: Highly academic: local etcd & Patroni Cluster for testing on asingle host Paul Förster
• 11:19   Re: Highly academic: local etcd & Patroni Cluster for testing on asingle host Alexander Kukushkin
• 11:27   Re: Highly academic: local etcd & Patroni Cluster for testing on asingle host Ian Barwick
• 11:38   Invoice increment Søren Frisk
• 11:40   Re: Highly academic: local etcd & Patroni Cluster for testing on asingle host Paul Förster
• 12:22   Re: Invoice increment Sándor Daku
• 12:27   Re: Invoice increment Vik Fearing
• 12:30   Re: Invoice increment Peter J. Holzer
• 13:52   Re: Invoice increment Søren Frisk
• 17:07   Re: Invoice increment Vik Fearing
• 17:11   How to install check_postgres on CentOS 8? rainer@ultra-secure.de
• 18:56   Re: information_schema performance in Postgres 12 Adrian Klaver
• 19:20   Re: information_schema performance in Postgres 12 Eric Gillum
• 19:23   Re: How to install check_postgres on CentOS 8? Paul Förster
• 19:26   Re: Highly academic: local etcd & Patroni Cluster for testing on asingle host Paul Förster
• 19:35   Re: How to install check_postgres on CentOS 8? rainer@ultra-secure.de
• 19:40   Re: information_schema performance in Postgres 12 Michael Lewis
• 19:48   How to know if initial sync of logical subscription is finished Klaus Darilion
• 21:05   Re: information_schema performance in Postgres 12 Eric Gillum
• 22:37   Re: Error“cache lookup failed for function” Albrecht Dreß

27 February 2020

• 01:19   Statistics and Index Usage Data Casey Meijer
• 02:35   Re: information_schema performance in Postgres 12 Tom Lane
• 10:41   Re: Need to find the no. of connections for a database sivapostgres@yahoo.com
• 13:01   Re: How to install check_postgres on CentOS 8? Peter J. Holzer
• 13:07   Re: Need to find the no. of connections for a database Peter J. Holzer
• 14:04   Re: Need to find the no. of connections for a database Ravi Krishna
• 14:35   Re: Need to find the no. of connections for a database sivapostgres@yahoo.com
• 15:40   Re: Need to find the no. of connections for a database Ravi Krishna
• 15:58   Re: Need to find the no. of connections for a database Ireneusz Pluta/wp.pl
• 16:37   Re: Need to find the no. of connections for a database sivapostgres@yahoo.com
• 17:08   Re: Need to find the no. of connections for a database Ireneusz Pluta/wp.pl
• 17:26   Re: Need to find the no. of connections for a database sivapostgres@yahoo.com
• 17:54   Is it safe to rename an index through pg_class update? Kouber Saparev
• 18:30   Re: unexpected behavior with pglogical -- bug? Iban Rodriguez
• 18:52   Re: Is it safe to rename an index through pg_class update? Tom Lane
• 18:52   Re: Error “cache lookup failed for function” Adrian Klaver
• 19:08   Re: Is it safe to rename an index through pg_class update? Kouber Saparev
• 19:33   Re: Need to find the no. of connections for a database Ireneusz Pluta/wp.pl
• 20:08   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Marc
• 21:12   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Adrian Klaver
• 22:54   Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Tom Lane
• 22:58   trouble making PG use my Perl Kevin Brannen
• 23:07   Re: trouble making PG use my Perl Tom Lane
• 23:14   Re: Is it safe to rename an index through pg_class update? Tom Lane
• 23:40   pg_upgrade custom table locations. Move table locations during upgrade? Tory M Blue
• 23:42   RE: trouble making PG use my Perl Kevin Brannen

28 February 2020

• 00:28   A question relative to creating an audit table stan
• 00:30   Re: A question relative to creating an audit table Andrei Zhidenkov
• 00:35   Re: A question relative to creating an audit table Adrian Klaver
• 01:45   Re: pg_upgrade custom table locations. Move table locations during upgrade? Tory M Blue
• 01:53   Re: A question relative to creating an audit table Vik Fearing
• 04:10   Re: Need to find the no. of connections for a database sivapostgres@yahoo.com
• 06:47   table name "unnest" specified more than once Guyren Howe
• 07:45   Re: table name "unnest" specified more than once David G. Johnston
• 08:38   Re: Need to find the no. of connections for a database rob stone
• 09:03   Re: Need to find the no. of connections for a database Rob Sargent
• 10:28   Recursive CTEs and randomness - is there something I'm missing? Pól Ua Laoínecháin
• 16:13   Re: trouble making PG use my Perl Steven Lembark
• 16:17   Re: trouble making PG use my Perl Steven Lembark
• 16:25   Re: trouble making PG use my Perl Steven Lembark
• 16:50   Re: Need to find the no. of connections for a database sivapostgres@yahoo.com
• 16:59   Re: A question relative to creating an audit table stan
• 17:02   Re: A question relative to creating an audit table Andrei Zhidenkov
• 20:45   Re: Recursive CTEs and randomness - is there something I'm missing? Tom Lane

29 February 2020

• 01:19   Re: Recursive CTEs and randomness - is there something I'm missing? Adrian Klaver
• 22:48   Re: trouble making PG use my Perl Peter J. Holzer
• 23:03   Re: trouble making PG use my Perl Peter J. Holzer