Home > mailing lists

Mailing lists [pgsql-general]

1 March 2018

03:00 Re: How to avoid trailing zero (after decimal point) for numeric type column Charles Clavadetscher
03:07 Re: Enforce primary key on every table during dev? Tim Cross
03:15 Re: selecting timestamp chris
03:29 Re: Enforce primary key on every table during dev? btober@computer.org
06:47 Re: Enforce primary key on every table during dev? Melvin Davidson
14:20 Re: Enforce primary key on every table during dev? Alban Hertroys
16:19 Re: Enforce primary key on every table during dev? Ron Johnson
16:24 Version upgrade: is restoring the postgres database needed? Ron Johnson
18:07 Re: Enforce primary key on every table during dev? Rakesh Kumar
20:06 Custom ranking function for full text search Kiran Krishnamachari
20:46 Re: Version upgrade: is restoring the postgres database needed? Melvin Davidson
21:23 Posgresql Log: lots of parse statements Vikas Sharma
21:30 Re: Posgresql Log: lots of parse statements David G. Johnston
22:15 Re: Version upgrade: is restoring the postgres database needed? Ron Johnson
22:22 Re: Enforce primary key on every table during dev? Steven Lembark
22:37 Re: Version upgrade: is restoring the postgres database needed? Vick Khera
22:43 Re: Enforce primary key on every table during dev? Alban Hertroys
22:50 Re: Enforce primary key on every table during dev? Melvin Davidson
22:51 Re: Version upgrade: is restoring the postgres database needed? Ron Johnson
23:03 Re: Version upgrade: is restoring the postgres database needed? Melvin Davidson
23:07 Re: Enforce primary key on every table during dev? Steve Atkins
23:21 Re: Posgresql Log: lots of parse statements Vikas Sharma
23:22 Re: Version upgrade: is restoring the postgres database needed? Ron Johnson
23:26 Re: Posgresql Log: lots of parse statements Tom Lane
23:28 Re: Posgresql Log: lots of parse statements David G. Johnston
23:28 Re: Version upgrade: is restoring the postgres database needed? Melvin Davidson
23:32 Re: Enforce primary key on every table during dev? Ron Johnson
23:46 Re: Version upgrade: is restoring the postgres database needed? Adrian Klaver
23:47 Re: Enforce primary key on every table during dev? Daevor The Devoted
23:54 Re: Version upgrade: is restoring the postgres database needed? Ron Johnson
23:59 Re: Version upgrade: is restoring the postgres database needed? Ron Johnson

2 March 2018

00:08 Re: How to avoid trailing zero (after decimal point) for numeric type column Francisco Olarte
00:18 Re: Enforce primary key on every table during dev? Ron Johnson
00:20 Re: Enforce primary key on every table during dev? Francisco Olarte
00:20 Re: Version upgrade: is restoring the postgres database needed? Vick Khera
00:24 Re: Enforce primary key on every table during dev? Martin Moore
00:26 Re: Enforce primary key on every table during dev? Francisco Olarte
00:32 Re: Enforce primary key on every table during dev? Daevor The Devoted
00:35 Re: Enforce primary key on every table during dev? Francisco Olarte
00:40 Re: Enforce primary key on every table during dev? Francisco Olarte
00:52 Re: Enforce primary key on every table during dev? David G. Johnston
01:00 Re: Enforce primary key on every table during dev? Ron Johnson
01:05 Re: Enforce primary key on every table during dev? Melvin Davidson
01:11 Re: Enforce primary key on every table during dev? marcelo
01:39 Re: Enforce primary key on every table during dev? Ron Johnson
01:42 Re: Enforce primary key on every table during dev? Ron Johnson
02:06 Re: Enforce primary key on every table during dev? Daevor The Devoted
02:08 Re: Enforce primary key on every table during dev? marcelo
02:09 Re: Enforce primary key on every table during dev? Daevor The Devoted
02:12 Re: Enforce primary key on every table during dev? David G. Johnston
02:21 Re: Enforce primary key on every table during dev? Ron Johnson
02:24 Re: Enforce primary key on every table during dev? Ron Johnson
02:32 Re: Enforce primary key on every table during dev? David G. Johnston
02:32 Re: Enforce primary key on every table during dev? marcelo
02:36 Re: Enforce primary key on every table during dev? David G. Johnston
02:37 Re: Enforce primary key on every table during dev? Rakesh Kumar
02:44 Re: Enforce primary key on every table during dev? Daevor The Devoted
02:46 Re: Enforce primary key on every table during dev? Daevor The Devoted
02:48 Re: Enforce primary key on every table during dev? marcelo
02:55 Re: Enforce primary key on every table during dev? Ron Johnson
02:59 Re: Enforce primary key on every table during dev? Ron Johnson
02:59 Re: Enforce primary key on every table during dev? geoff hoffman
03:00 Re: Version upgrade: is restoring the postgres database needed? Adrian Klaver
03:03 Re: Enforce primary key on every table during dev? Ron Johnson
03:06 Re: Enforce primary key on every table during dev? Tim Cross
03:14 Re: Enforce primary key on every table during dev? Adrian Klaver
03:21 Re: Enforce primary key on every table during dev? David G. Johnston
03:26 Re: Enforce primary key on every table during dev? Ron Johnson
03:41 Re: Enforce primary key on every table during dev? Adrian Klaver
04:05 Re: Enforce primary key on every table during dev? Gavin Flower
04:06 Re: Enforce primary key on every table during dev? marcelo
04:20 Re: PQConsumeinput stuck on recv Andre Oliveira Freitas
04:28 How to perform PITR when all of the logs won't fit on the drive Tony Sullivan
04:33 Re: Enforce primary key on every table during dev? marcelo
04:34 Re: How to perform PITR when all of the logs won't fit on the drive Alan Hodgson
10:10 Re: Enforce primary key on every table during dev? Daevor The Devoted
11:24 Flyway and postgree multiple developers Łukasz Jarych
14:23 PG 10 logical replication version dependency? Colin 't Hart
15:01 Re: PG 10 logical replication version dependency? Thomas Kellerer
15:17 How can I include sql file in pgTAP unittest? Stéphane Klein
17:15 Tracking changes DML in history log table Łukasz Jarych
19:52 Re: How can I include sql file in pgTAP unittest? Adrian Klaver
19:52 jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
20:05 Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar Adrian Klaver
20:14 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
20:31 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
20:31 Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar Adrian Klaver
20:42 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
20:46 Re: How can I include sql file in pgTAP unittest? Stéphane Klein
20:47 Re: Enforce primary key on every table during dev? marcelo
20:55 Release upgarde failure Pawan Sharma
21:03 Re: Release upgarde failure David G. Johnston
22:21 Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar Adrian Klaver
22:29 Re: How to perform PITR when all of the logs won't fit on the drive Jeff Janes
23:54 Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar Adrian Klaver

3 March 2018

00:01 Re: How can I include sql file in pgTAP unittest? Adrian Klaver
00:04 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar David G. Johnston
00:11 Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar Adrian Klaver
00:37 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
00:43 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
00:48 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
00:52 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar David G. Johnston
00:52 Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar Adrian Klaver
00:58 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar Alexander Farber
01:05 Is there a continuous backup for pg ? Gary M
01:05 Re: jsonb_array_length: ERROR: 22023: cannot get array length of a scalar David G. Johnston
01:16 Re: Is there a continuous backup for pg ? Joshua D. Drake
01:22 Re: Is there a continuous backup for pg ? Steve Atkins
01:34 Re: Is there a continuous backup for pg ? Gary M
01:55 Re: Is there a continuous backup for pg ? David Steele
02:26 Re: jsonb_array_length: ERROR: 22023: cannot get array length of ascalar Adrian Klaver
02:36 Re: PQConsumeinput stuck on recv Andres Freund
02:44 Re: Is there a continuous backup for pg ? Gary M
03:32 Jira database won't start after disk filled up Paul Costello
03:34 Re: Is there a continuous backup for pg ? Vick Khera
03:44 Re: Jira database won't start after disk filled up Vick Khera
04:13 Re: Jira database won't start after disk filled up Paul Costello
05:13 Re: Is there a continuous backup for pg ? Gary M
06:36 SQL syntax Dale Seaburg
06:41 Re: SQL syntax Adrian Klaver
07:01 Re: SQL syntax Ken Tanzer
07:07 Re: SQL syntax Tom Lane
11:58 Re: SQL syntax Rob Sargent
13:08 pg_upgrade fails to restore function Roger Sunny
21:30 Re: pg_upgrade fails to restore function Tom Lane

4 March 2018

22:45 Re: Jira database won't start after disk filled up Vick Khera
23:48 Q: text palloc() size vs. SET_VARSIZE() Albrecht Dreß

5 March 2018

01:52 Re: Q: text palloc() size vs. SET_VARSIZE() Tom Lane
04:58 Re: Is there a continuous backup for pg ? raf@raf.org
07:53 momjian.us is down? Igal
07:59 Re: Is there a continuous backup for pg ? Sameer Kumar
09:24 Re: momjian.us is down? Adrian Klaver
09:27 Re: momjian.us is down? Igal
09:47 Pgadmin4 apt packages. Tim Uckun
11:11 Re: Pgadmin4 apt packages. Adrian Klaver
11:57 Re: momjian.us is down? Tom Lane
13:22 Re: momjian.us is down? Igal
17:07 PostgreSQL 10.3 and Ubuntu Olleg Samoylov
17:17 Re: Incredibly slow queries oninformation_schema.constraint_column_usage? Alexey Bashtanov
17:27 JDBC4 and setting statement_timeout: responds "is not yet implemented" Gunnar Halvorsen
18:55 Requiring pass and database psql shell command Łukasz Jarych
19:13 psql variables in the DO command Pavel Luzanov
19:33 Re: Requiring pass and database psql shell command James Keener
19:42 Re: psql variables in the DO command Pavel Stehule
19:52 Re: psql variables in the DO command Pavel Luzanov
19:56 Re: psql variables in the DO command Pavel Stehule
20:02 Re: psql variables in the DO command Pavel Luzanov
20:03 Re: Requiring pass and database psql shell command Łukasz Jarych
20:05 What is wrong with my pgadmin? Łukasz Jarych
20:13 psqlODBC and PostgreSQL
20:22 Re: What is wrong with my pgadmin? Adrian Klaver
20:22 Re: psql variables in the DO command Pavel Luzanov
20:23 Re: Requiring pass and database psql shell command Ron Johnson
20:23 回复： pg_upgrade fails to restore function Roger Sunny
20:27 Re: What is wrong with my pgadmin? Martin Moore
20:33 Re: Requiring pass and database psql shell command David G. Johnston
21:01 Re: psql variables in the DO command Pavel Stehule
21:06 Re: What is wrong with my pgadmin? Murtuza Zabuawala
21:19 Re: psql variables in the DO command Pavel Luzanov
21:35 Re: psql variables in the DO command Pavel Stehule
22:07 Re: What is wrong with my pgadmin? Łukasz Jarych
22:08 Re: What is wrong with my pgadmin? Łukasz Jarych
22:10 Re: What is wrong with my pgadmin? Łukasz Jarych
22:12 Re: What is wrong with my pgadmin? Łukasz Jarych
22:53 Best options for new PG instance David Gauthier
23:51 Re: Best options for new PG instance Steve Atkins

6 March 2018

00:05 Re: Q: text palloc() size vs. SET_VARSIZE() Albrecht Dreß
02:57 Re: PQConsumeinput stuck on recv Andre Oliveira Freitas
03:01 Re: PQConsumeinput stuck on recv Andres Freund
03:10 Re: Best options for new PG instance Tim Cross
05:36 Re: JDBC4 and setting statement_timeout: responds "is not yetimplemented" rob stone
07:11 Re: Best options for new PG instance Michael Paquier
07:54 org.postgresql.util.PSQLException: Error could not open file "base/":No such file or directory Raghavendra Rao J S V
08:05 RE: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory Alvaro Aguayo Garcia-Rada
10:45 Resync second slave to new master Dylan Luong
10:50 Re: What is wrong with my pgadmin? Łukasz Jarych
11:06 Re: What is wrong with my pgadmin? David G. Johnston
11:06 Re: What is wrong with my pgadmin? Adrian Klaver
11:13 Re: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory Adrian Klaver
11:23 Re: Resync second slave to new master Michael Paquier
12:00 RE: Resync second slave to new master Dylan Luong
12:25 Re: Best options for new PG instance Benjamin Scherrey
13:24 Re: Resync second slave to new master Michael Paquier
15:17 Re: psql variables in the DO command Pavel Luzanov
15:25 Re: psql variables in the DO command Pavel Stehule
16:15 Re: What is wrong with my pgadmin? Laurenz Albe
16:23 dirty_ratio & dirty_background_ratio settings with huge memory pinker
18:16 Re: dirty_ratio & dirty_background_ratio settings with huge memory Laurenz Albe
19:19 Re: dirty_ratio & dirty_background_ratio settings with huge memory Tomas Vondra
19:40 Re: dirty_ratio & dirty_background_ratio settings with huge memory Laurenz Albe
20:40 Re: What is wrong with my pgadmin? David G. Johnston
21:51 plpgsql function-parsing chris
22:12 normalizing a float array? Celia McInnis
22:16 Re: normalizing a float array? Achilleas Mantzios
22:55 Re: dirty_ratio & dirty_background_ratio settings with huge memory Andres Freund

7 March 2018

00:11 Re: plpgsql function-parsing Pavel Stehule
01:53 Barman versus pgBackRest Thomas Poty
02:26 Can I grant permissions to specific set of uids (linux) ? David Gauthier
02:41 Re: Can I grant permissions to specific set of uids (linux) ? Melvin Davidson
03:33 Re: Can I grant permissions to specific set of uids (linux) ? David G. Johnston
07:59 Re: dirty_ratio & dirty_background_ratio settings with huge memory pinker
08:05 Re: dirty_ratio & dirty_background_ratio settings with huge memory pinker
09:24 Help troubleshooting SubtransControlLock problems Scott Frazer
09:29 Re: dirty_ratio & dirty_background_ratio settings with huge memory Andres Freund
10:40 help to query json column Arup Rakshit
11:43 Re: Help troubleshooting SubtransControlLock problems Rene Romero Benavides
12:57 RE: help to query json column Charles Clavadetscher
13:07 save query as sql file Łukasz Jarych
13:22 Re: dirty_ratio & dirty_background_ratio settings with huge memory Laurenz Albe
13:24 Re: save query as sql file Murtuza Zabuawala
15:26 Caused by: org.postgresql.util.PSQLException: ERROR: syntax error ator near "merge". Vinodh NV
15:34 Re: Caused by: org.postgresql.util.PSQLException: ERROR: syntaxerror at or near "merge". Alvaro Herrera
16:27 Re: help to query json column Arup Rakshit
17:26 Re: JDBC4 and setting statement_timeout: responds "is not yetimplemented" => FIXED Gunnar Halvorsen
18:51 Re: WHERE 'Something%' LIKE ANY (array_field) Vishal
19:13 Authentication? Bjørn T Johansen
19:35 Java client fails to connect to database with replication slotsregistered if targetServerType=master Tom Dearman
19:45 Re: save query as sql file Adrian Klaver
19:46 Re: save query as sql file Łukasz Jarych
20:00 Re: save query as sql file Melvin Davidson
20:02 Re: save query as sql file Łukasz Jarych
20:14 Re: Authentication? David G. Johnston
21:14 Re: Authentication? Bjørn T Johansen
21:19 Re: Authentication? David G. Johnston
21:19 Re: Authentication? Stephen Frost
21:21 Re: Help troubleshooting SubtransControlLock problems Scott Frazer
21:36 Re: Authentication? Benedict Holland
21:40 Re: Authentication? Stephen Frost
21:52 Re: Help troubleshooting SubtransControlLock problems Laurenz Albe
22:23 Re: Help troubleshooting SubtransControlLock problems Scott Frazer
22:37 Re: Help troubleshooting SubtransControlLock problems Laurenz Albe
22:39 Re: Help troubleshooting SubtransControlLock problems Alvaro Herrera
23:21 a very primitive question about division Martin Mueller
23:23 Re: a very primitive question about division David G. Johnston
23:30 Re: a very primitive question about division Martin Mueller
23:43 Re: a very primitive question about division David G. Johnston
23:56 Re: a very primitive question about division Martin Mueller

8 March 2018

00:11 Re: a very primitive question about division David G. Johnston
00:41 Re: a very primitive question about division Martin Mueller
01:01 Replication pull instead of push PegoraroF10
01:38 Re: Replication pull instead of push Fabrízio de Royes Mello
01:49 Re: Replication pull instead of push PegoraroF10
03:20 Re: Help troubleshooting SubtransControlLock problems Scott Frazer
03:50 Re: Help troubleshooting SubtransControlLock problems Alvaro Herrera
05:05 Prefixing schema name Tiffany Thang
05:06 cached plan must not change result type Jan Bilek
05:13 Re: Prefixing schema name David G. Johnston
05:21 Re: cached plan must not change result type David G. Johnston
06:04 Timescale with replication advice geoff hoffman
06:55 Replication push instead of pull PegoraroF10
13:02 Re: Prefixing schema name Achilleas Mantzios
13:41 RE: Resync second slave to new master Dylan Luong
13:48 Re: Resync second slave to new master Yavuz Selim Sertoğlu
14:10 Re: Resync second slave to new master Michael Paquier
15:49 What is the meaning of pg_restore output? Alexandru Lazarev
16:38 RE: Resync second slave to new master Dylan Luong
18:26 Command to execute SQL string Łukasz Jarych
18:32 Trigger to create string to inverse SQL statement Łukasz Jarych
18:40 Re: Command to execute SQL string Francisco Olarte
18:44 Re: Trigger to create string to inverse SQL statement Francisco Olarte
18:48 Re: Command to execute SQL string Łukasz Jarych
18:51 Re: Trigger to create string to inverse SQL statement Łukasz Jarych
18:53 Re: Trigger to create string to inverse SQL statement Łukasz Jarych
19:14 Re: Command to execute SQL string David G. Johnston
21:30 Re: What is the meaning of pg_restore output? Adrian Klaver
22:30 Re: Trigger to create string to inverse SQL statement Francisco Olarte
22:33 Re: Trigger to create string to inverse SQL statement Francisco Olarte
22:48 Crash and core on 10.1 and 10.2 Kelly Burkhart
23:00 Re: Crash and core on 10.1 and 10.2 Tom Lane
23:06 Re: What is the meaning of pg_restore output? Alexandru Lazarev
23:40 Troubleshooting a segfault and instance crash Blair Boadway
23:47 Re: Troubleshooting a segfault and instance crash Pavel Stehule

9 March 2018

00:16 Re: Troubleshooting a segfault and instance crash Blair Boadway
00:26 circular wait not triggering deadlock ? Justin Pryzby
00:31 Re: Help troubleshooting SubtransControlLock problems Scott Frazer
00:34 Re: Troubleshooting a segfault and instance crash Pavel Stehule
00:57 Re: circular wait not triggering deadlock ? Tom Lane
01:05 Re: Crash and core on 10.1 and 10.2 Kelly Burkhart
01:45 Re: circular wait not triggering deadlock ? Justin Pryzby
02:05 Re: circular wait not triggering deadlock ? Tom Lane
02:13 Re: circular wait not triggering deadlock ? Justin Pryzby
03:06 Re: What is the meaning of pg_restore output? Adrian Klaver
03:12 JDBC connectivity issue chris
03:24 Re: JDBC connectivity issue Adrian Klaver
03:26 Re: JDBC connectivity issue Tim Cross
03:27 Re: JDBC connectivity issue Adrian Klaver
03:30 Re: JDBC connectivity issue chris
03:32 Re: What is the meaning of pg_restore output? Tom Lane
03:34 Re: Prefixing schema name Tiffany Thang
03:57 Re: JDBC connectivity issue Adrian Klaver
04:14 Re: JDBC connectivity issue David G. Johnston
04:51 Re: JDBC connectivity issue Dave Cramer
04:55 RE: Troubleshooting a segfault and instance crash Jan Bilek
14:25 Re: Authentication? Bjørn T Johansen
14:52 pg/tcl performance related wolfgang@alle-noten.de
19:26 Postgresql upgrade to 9.5.12/10.3 changes pg_dump format for cloningschemas Aldrin Martoq Ahumada
20:22 Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas David G. Johnston
20:41 Feature request: min/max for macaddr type Herwin Weststrate
20:51 Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas Andre Oliveira Freitas
20:56 Re: Barman versus pgBackRest David Steele
21:00 Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas Aldrin Martoq Ahumada
21:15 Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas Melvin Davidson
22:43 Re: pg/tcl performance related Tom Lane
22:43 ERROR could not access transaction/Could not open file pg_commit_ts Jeremy Finzel
22:54 Re: Feature request: min/max for macaddr type Tom Lane

10 March 2018

00:34 Re: ERROR could not access transaction/Could not open file pg_commit_ts Jeremy Finzel
00:40 Re: ERROR could not access transaction/Could not open filepg_commit_ts Alvaro Herrera
02:08 how to get list of sequences owned by a user/role Charlin Barak
02:24 Re: ERROR could not access transaction/Could not open file pg_commit_ts Jerry Sievers
04:22 Re: how to get list of sequences owned by a user/role Adrian Klaver
04:24 Re: how to get list of sequences owned by a user/role Adrian Klaver
05:13 Ability to create tables Ron Johnson
05:46 Re: Ability to create tables Tom Lane
06:10 Re: Ability to create tables Ron Johnson
06:25 Need followup setup instructions to postgresql-10.3-1-linux-x64.run Sherman Willden
10:19 pgpass hostname and IP address Ron Johnson
10:26 Re: pgpass hostname and IP address David G. Johnston
10:34 Re: pgpass hostname and IP address Ron Johnson
11:11 Re: pgpass hostname and IP address Adrian Klaver
12:17 Re: pgpass hostname and IP address Ron Johnson
12:49 Application Dependency/Limitations of Postgres Version Upgrade amitabh kumar
13:11 RE: Application Dependency/Limitations of Postgres Version Upgrade Alvaro Aguayo Garcia-Rada
20:50 Re: Application Dependency/Limitations of Postgres Version Upgrade Adrian Klaver
20:58 Re: Application Dependency/Limitations of Postgres Version Upgrade Félix GERZAGUET
21:00 wrong message when trying to create an already existing index legrand legrand
21:16 Re: wrong message when trying to create an already existing index Adrian Klaver
21:54 Re: wrong message when trying to create an already existing index legrand legrand
22:14 Re: wrong message when trying to create an already existing index Melvin Davidson
22:49 Re: wrong message when trying to create an already existing index legrand legrand
23:10 Re: wrong message when trying to create an already existing index Tom Lane
23:27 Re: momjian.us is down? Bruce Momjian

11 March 2018

00:53 Is there a way to create a functional index that tables tableoidcolumn as an arg? Ryan Murphy
00:53 Re: wrong message when trying to create an already existing index legrand legrand

12 March 2018

04:59 Re: Is there a way to create a functional index that tables tableoidcolumn as an arg? David Rowley
15:59 can someone send a design document of "parallel work" to me? lin
18:18 query_to_xml() returns invalid XML when query returns no rows Thomas Kellerer
21:56 Re: can someone send a design document of "parallel work" to me? Adrian Klaver

13 March 2018

00:14 psql in a bash function Ron Johnson
00:21 Re: psql in a bash function Melvin Davidson
00:24 Re: psql in a bash function Eric Raskin
00:26 UPSERT on a view Steven Roth
00:32 Re: psql in a bash function Ron Johnson
00:33 pglogical lag due to replication timeout greigwise
02:18 Logical decoding on standby Andreas Joseph Krogh
04:05 Reindex doesn't eliminate bloat Ron Johnson
04:20 Re: Reindex doesn't eliminate bloat Nikolay Samokhvalov
04:28 Re: Reindex doesn't eliminate bloat Ron Johnson
04:31 Re: query_to_xml() returns invalid XML when query returns no rows Peter Eisentraut
04:55 Re: Reindex doesn't eliminate bloat Adrian Klaver
05:00 Re: Reindex doesn't eliminate bloat Ron Johnson
05:58 Re: Logical decoding on standby Andreas Kretschmer
06:08 Re: Logical decoding on standby Andreas Kretschmer
06:28 Re: Logical decoding on standby David G. Johnston
07:39 Sv: Re: Logical decoding on standby Andreas Joseph Krogh
07:40 Re: Logical decoding on standby Andres Freund
09:23 Programmatically duplicating a schema matt.figg@internode.on.net
09:48 Re: Reindex doesn't eliminate bloat Nikolay Samokhvalov
10:16 Re: Reindex doesn't eliminate bloat Ron Johnson
10:22 Re: Programmatically duplicating a schema Adrian Klaver
12:05 Re: Programmatically duplicating a schema matt.figg@internode.on.net
13:19 Re: Logical decoding on standby Andreas Kretschmer
14:21 Re: Programmatically duplicating a schema Alban Hertroys
14:48 Question on corruption (PostgreSQL 9.6.1) Andy Halsall
17:28 Point-in-time recovery after failover Dylan Luong
17:51 Re: Point-in-time recovery after failover Laurenz Albe
19:09 Re: Programmatically duplicating a schema Melvin Davidson
19:47 Re: UPSERT on a view Melvin Davidson
19:57 Re: Programmatically duplicating a schema David G. Johnston
19:58 Re: Question on corruption (PostgreSQL 9.6.1) Tom Lane
20:02 Re: UPSERT on a view David G. Johnston
20:09 Re: UPSERT on a view Melvin Davidson
20:10 Re: UPSERT on a view Tom Lane
20:18 Re: UPSERT on a view Tom Lane
21:06 Re: Programmatically duplicating a schema Adrian Klaver
21:35 Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas Aldrin Martoq Ahumada
23:47 Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas Melvin Davidson

14 March 2018

01:21 Re: query_to_xml() returns invalid XML when query returns no rows Thomas Kellerer
02:05 Re: Is there a way to create a functional index that tables tableoidcolumn as an arg? Ryan Murphy
02:52 Re: Is there a way to create a functional index that tables tableoid column as an arg? Tom Lane
04:28 Re: query_to_xml() returns invalid XML when query returns no rows Peter Eisentraut
04:37 Re: Postgresql upgrade to 9.5.12/10.3 changes pg_dump format forcloning schemas Melvin Davidson
05:10 Re: Reindex doesn't eliminate bloat Joe Conway
05:46 Re: JDBC connectivity issue chris
05:47 Re: Reindex doesn't eliminate bloat Ron Johnson
05:48 Re: JDBC connectivity issue Adrian Klaver
19:19 Primary key gist index? Jeremy Finzel
19:33 Re: Primary key gist index? Adrian Klaver
20:51 Re: JDBC connectivity issue chris
21:17 wiki Disk Usage, table size: ERROR: could not open relation with OID 0 Hans Schou
21:44 Re: JDBC connectivity issue Adrian Klaver
22:27 Extract elements from JSON array and return them as concatenated string Alexander Farber
22:34 Re: Extract elements from JSON array and return them as concatenatedstring Ivan E. Panchenko
23:02 Re: Extract elements from JSON array and return them as concatenated string Alexander Farber
23:12 Re: Extract elements from JSON array and return them as concatenatedstring Adrian Klaver
23:15 Re: Extract elements from JSON array and return them as concatenatedstring Adrian Klaver

15 March 2018

00:10 Re: Primary key gist index? Jeremy Finzel
00:28 Re: Primary key gist index? Paul Jungwirth
00:44 Re: Primary key gist index? Tom Lane
00:45 Re: Primary key gist index? Adrian Klaver
00:52 Re: Primary key gist index? Steven Lembark
01:08 Re: Primary key gist index? Paul Jungwirth
01:41 Re: Extract elements from JSON array and return them as concatenatedstring Ivan E. Panchenko
01:49 Re: Primary key gist index? Jeremy Finzel
01:54 Re: Best options for new PG instance pinker
02:02 Re: Need followup setup instructions topostgresql-10.3-1-linux-x64.run pinker
02:47 Re: JDBC connectivity issue chris
03:17 PgBackrest questions chiru r
03:27 Re: JDBC connectivity issue Adrian Klaver
04:17 Re: PgBackrest questions Stephen Frost
04:27 Re: Extract elements from JSON array and return them as concatenated string Alexander Farber
05:32 Re: wiki Disk Usage, table size: ERROR: could not open relation withOID 0 Michael Paquier
05:44 Re: wiki Disk Usage, table size: ERROR: could not open relation with OID 0 Tom Lane
08:54 Re: PgBackrest questions chiru r
15:43 Snapshot recovery or rolling back commited Marc-Antoine Nüssli
16:08 Re: Snapshot recovery or rolling back commited rob stone
19:19 Re: How to monitor logical replication initial sync? bricklen
20:40 Change ON UPDATE behavior of fkey Mike Rylander
20:57 psql output result Tiffany Thang
21:01 Re: psql output result Geoff Winkless
21:03 Re: psql output result Adrian Klaver
21:16 Re: Question on corruption (PostgreSQL 9.6.1) Andy Halsall
21:55 Re: wiki Disk Usage, table size: ERROR: could not open relation withOID 0 Hans Schou
22:28 Re: wiki Disk Usage, table size: ERROR: could not open relation withOID 0 Hans Schou

16 March 2018

00:55 ERROR: right sibling's left-link doesn't match: block 5 links to 8instead of expected 2 in index "pg_toast_2619_index" Raghavendra Rao J S V
02:30 SELECT .. FOR UPDATE: find out who locked a row Enrico Thierbach
02:36 Re: SELECT .. FOR UPDATE: find out who locked a row pinker
02:38 Re: SELECT .. FOR UPDATE: find out who locked a row David G. Johnston
02:40 Re: psql output result Tiffany Thang
02:48 Re: SELECT .. FOR UPDATE: find out who locked a row Stephen Frost
03:12 Re: SELECT .. FOR UPDATE: find out who locked a row Melvin Davidson
03:55 Re: SELECT .. FOR UPDATE: find out who locked a row Enrico Thierbach
04:05 Re: SELECT .. FOR UPDATE: find out who locked a row Stephen Frost
05:00 Want to disable fully qualified table names on pg_dump in pg_dump(PostgreSQL) 9.6.8 Foolish Ewe
05:09 Re: Want to disable fully qualified table names on pg_dump in pg_dump(PostgreSQL) 9.6.8 Adrian Klaver
05:48 Re: SELECT .. FOR UPDATE: find out who locked a row Melvin Davidson
08:13 Re: PgBackrest questions chiru r
08:14 Re: SELECT .. FOR UPDATE: find out who locked a row Stephen Frost
08:18 Re: PgBackrest questions Stephen Frost
08:25 Re: SELECT .. FOR UPDATE: find out who locked a row Melvin Davidson
08:41 Re: PgBackrest questions Stephen Frost
08:45 Re: SELECT .. FOR UPDATE: find out who locked a row Stephen Frost
09:23 Re: SELECT .. FOR UPDATE: find out who locked a row Tom Lane
16:00 Circle and box intersect Martin Moore
17:00 error 53200 out of memory francis cherat
17:45 Re: Circle and box intersect Andreas Kretschmer
18:32 RE: Circle and box intersect Martin Moore
20:07 Re: SELECT .. FOR UPDATE: find out who locked a row Melvin Davidson
20:17 STRING_AGG and GROUP BY Alexander Farber
20:47 Re: SELECT .. FOR UPDATE: find out who locked a row Stephen Frost
21:00 Re: SELECT .. FOR UPDATE: find out who locked a row Enrico Thierbach
21:06 Re: SELECT .. FOR UPDATE: find out who locked a row Stephen Frost
21:08 Re: SELECT .. FOR UPDATE: find out who locked a row Enrico Thierbach
21:12 Prompt for parameter value in psql Tiffany Thang
21:17 Re: SELECT .. FOR UPDATE: find out who locked a row David G. Johnston
21:18 Re: Prompt for parameter value in psql Melvin Davidson
21:18 Re: Prompt for parameter value in psql Pavel Stehule
21:26 Re: error 53200 out of memory Adrian Klaver
21:40 Re: STRING_AGG and GROUP BY David G. Johnston
22:10 Re: STRING_AGG and GROUP BY Alexander Farber
22:40 Re: STRING_AGG and GROUP BY David G. Johnston
23:12 ora2pg and invalid command \N Charlin Barak
23:47 Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue Victoria
23:58 Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue Adrian Klaver

17 March 2018

00:03 Re: ora2pg and invalid command \N Adrian Klaver
00:05 Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue Victoria
00:06 Re: ora2pg and invalid command \N Pavel Stehule
00:24 Re: Question on corruption (PostgreSQL 9.6.1) Peter Geoghegan
00:36 Re: ora2pg and invalid command \N Charlin Barak
01:27 RE: error 53200 out of memory francis cherat
01:28 Re: ora2pg and invalid command \N Adrian Klaver
01:40 Re: ora2pg and invalid command \N Julien Rouhaud
02:06 Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue Victoria
02:33 Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue Adrian Klaver
02:55 Re: Want to disable fully qualified table names on pg_dump in pg_dump(PostgreSQL) 9.6.8 Foolish Ewe
03:17 Re: Nvim as external editor in psql as Postgres root user - .vimrc(environment?) issue Victoria Stuart (VictoriasJourney.com)
03:41 Re: Want to disable fully qualified table names on pg_dump in pg_dump(PostgreSQL) 9.6.8 Adrian Klaver
04:18 Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory hmidi slim
04:59 Re: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory Adrian Klaver
16:03 Re: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory hmidi slim
20:06 Re: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory Adrian Klaver
20:30 Re: What is the meaning of pg_restore output? Alexandru Lazarev
21:45 changing my mail address wambacher@posteo.de
21:51 Re: changing my mail address Stephen Frost
21:56 Re: changing my mail address wambacher@posteo.de
22:20 Re: What is the meaning of pg_restore output? Adrian Klaver
23:13 Re: changing my mail address Ron Johnson
23:36 Re: changing my mail address Michelle Konzack

18 March 2018

00:08 Re: changing my mail address Stephen Frost
00:31 Re: changing my mail address Ron Johnson
00:35 Re: changing my mail address Adrian Klaver
19:38 Re: changing my mail address Stephen Frost
19:54 Re: changing my mail address Michael Paquier

19 March 2018

03:54 pentaho timestamp issue PropAAS DBA
05:13 Re: pentaho timestamp issue Tom Lane
13:30 Logical replication: duplicate key problem Johann Spies
19:05 Re: Logical replication: duplicate key problem Adrian Klaver
22:31 PostgreSQL 9.6 Temporary files Jimmy Augustine
22:44 Re: PostgreSQL 9.6 Temporary files Andreas Kretschmer
22:45 Re: PostgreSQL 9.6 Temporary files Adrian Klaver
23:01 Re: PostgreSQL 9.6 Temporary files Melvin Davidson
23:02 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
23:04 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
23:09 Re: PostgreSQL 9.6 Temporary files Adrian Klaver
23:10 found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
23:12 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
23:15 Re: PostgreSQL 9.6 Temporary files Adrian Klaver
23:17 Re: PostgreSQL 9.6 Temporary files Melvin Davidson
23:17 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
23:20 Re: PostgreSQL 9.6 Temporary files Melvin Davidson
23:21 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
23:25 Re: PostgreSQL 9.6 Temporary files Andreas Kretschmer
23:25 Re: PostgreSQL 9.6 Temporary files Adrian Klaver
23:27 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
23:29 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
23:35 Re: PostgreSQL 9.6 Temporary files Adrian Klaver
23:46 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Alvaro Herrera
23:59 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel

20 March 2018

00:00 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
00:17 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund
00:32 Re: PostgreSQL 9.6 Temporary files Adrian Klaver
01:37 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
01:41 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund
01:53 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
01:56 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund
02:01 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
02:37 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
02:53 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund
02:53 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Peter Geoghegan
02:54 Re: STRING_AGG and GROUP BY Alexander Farber
02:55 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
03:02 Re: STRING_AGG and GROUP BY David G. Johnston
03:12 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Peter Geoghegan
03:19 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
13:08 RE: error 53200 out of memory francis cherat
15:44 You might be able to move the set-returning function into a LATERALFROM item. Alexander Farber
16:16 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
16:34 Re: You might be able to move the set-returning function into aLATERAL FROM item. Laurenz Albe
17:32 COPY error when \. char Nicolas Paris
17:46 Foreign Key locking / deadlock issue. HORDER Phil
19:29 Re: COPY error when \. char Adrian Klaver
19:51 Re: Foreign Key locking / deadlock issue. Adrian Klaver
19:51 Re: error 53200 out of memory Adrian Klaver
20:00 Re: PostgreSQL 9.6 Temporary files Adrian Klaver
20:04 Re: Foreign Key locking / deadlock issue. Adrian Klaver
20:27 Re: You might be able to move the set-returning function into a LATERAL FROM item. Tom Lane
20:28 Re: PostgreSQL 9.6 Temporary files Jimmy Augustine
20:31 Restore - disable triggers - when they fired? Durumdara
20:47 Re: Restore - disable triggers - when they fired? Adrian Klaver
20:56 Re: Restore - disable triggers - when they fired? Durumdara
21:23 postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
21:33 Re: Restore - disable triggers - when they fired? Adrian Klaver
21:38 Re: SELECT .. FOR UPDATE: find out who locked a row Enrico Thierbach
21:46 Re: postgresql-10.3 on unbuntu-17.10 - how?? Adrian Klaver
22:19 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel

21 March 2018

00:52 FDW Foreign Table Access: strange LOG message Albrecht Dreß
00:57 FATAL: semctl(15073290, 4, SETVAL, 0) failed: Invalid argument JotaComm
01:21 Re: FDW Foreign Table Access: strange LOG message Adrian Klaver
01:23 Re: You might be able to move the set-returning function into aLATERAL FROM item. Alexander Farber
01:24 Re: FATAL: semctl(15073290, 4, SETVAL, 0) failed: Invalid argument Adrian Klaver
01:38 Re: FDW Foreign Table Access: strange LOG message Tom Lane
02:19 Re: postgresql-10.3 on unbuntu-17.10 - how?? Christoph Berg
03:25 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
05:34 Re: postgresql-10.3 on unbuntu-17.10 - how?? Adrian Klaver
06:42 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
07:27 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
10:07 Re: postgresql-10.3 on unbuntu-17.10 - how?? Adrian Klaver
11:51 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
11:52 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
13:15 Re: Is there a way to get the name of the calling function in pgplsql? Pavel Stehule
13:24 Is there a way to get the name of the calling function in pgplsql? Thiemo Kellner
15:41 Re: Restore - disable triggers - when they fired? Durumdara
17:03 Re: Foreign Key locking / deadlock issue. rob stone
18:30 Re: Is there a way to get the name of the calling function inpgplsql? Thiemo Kellner, NHC Barhufpflege
18:33 RE: Foreign Key locking / deadlock issue. HORDER Phil
19:00 Re: Is there a way to get the name of the calling function in pgplsql? Pavel Stehule
19:02 Re: postgresql-10.3 on unbuntu-17.10 - how?? Adrian Klaver
19:16 Re: Restore - disable triggers - when they fired? Adrian Klaver
21:00 Foreign Key Validation after Reference Table Ownership Change Battuello, Louis
21:23 Re: Foreign Key Validation after Reference Table Ownership Change David G. Johnston
21:26 RE: Foreign Key locking / deadlock issue.... v2 HORDER Phil
21:30 RE: Re: Foreign Key Validation after Reference Table Ownership Change Battuello, Louis
22:09 Postgresql 10.3 , query never completes if LIMIT clause is specifiedand paralle processing is on Alessandro Aste
22:50 Re: Re: Foreign Key Validation after Reference Table Ownership Change David G. Johnston
23:12 Re: postgresql-10.3 on unbuntu-17.10 - how?? Vincenzo Romano
23:18 Re: Foreign Key Validation after Reference Table Ownership Change Louis Battuello
23:39 Re: Foreign Key Validation after Reference Table Ownership Change Tom Lane
23:48 Re: Foreign Key Validation after Reference Table Ownership Change Louis Battuello
23:51 Re: Foreign Key Validation after Reference Table Ownership Change Adrian Klaver
23:52 Re: Foreign Key Validation after Reference Table Ownership Change Tom Lane
23:59 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw

22 March 2018

00:14 Re: postgresql-10.3 on unbuntu-17.10 - how?? Adrian Klaver
00:15 Re: FDW Foreign Table Access: strange LOG message Albrecht Dreß
00:25 Re: FDW Foreign Table Access: strange LOG message Adrian Klaver
00:36 Foreign Key Validation after Reference Table Ownership Change David G. Johnston
00:56 Re: Foreign Key Validation after Reference Table Ownership Change Louis Battuello
01:01 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Tomas Vondra
01:44 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Alessandro Aste
02:16 Re: JDBC connectivity issue chris
02:30 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
02:31 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
02:37 Re: postgresql-10.3 on unbuntu-17.10 - how?? Rob Sargent
02:38 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
02:38 Re: postgresql-10.3 on unbuntu-17.10 - how?? Adrian Klaver
02:44 Re: JDBC connectivity issue Adrian Klaver
02:56 Re: JDBC connectivity issue chris
02:59 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
02:59 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
03:08 Re: postgresql-10.3 on unbuntu-17.10 - how?? Adrian Klaver
03:09 Prepared statements Tim Cross
03:13 Re: JDBC connectivity issue Adrian Klaver
03:16 Re: Prepared statements Rakesh Kumar
03:29 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Peter Geoghegan
03:32 Re: Prepared statements Steve Atkins
03:38 Re: postgresql-10.3 on unbuntu-17.10 - how?? Rob Sargent
08:04 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Tomas Vondra
14:33 Re: Prepared statements Laurenz Albe
15:06 Re: JDBC connectivity issue Dave Cramer
15:53 Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDEfor working with PostgreSQL databases Devart
16:33 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Alessandro Aste
17:02 Re: Prepared statements Rakesh Kumar
17:11 Re: Foreign Key locking / deadlock issue.... v2 rob stone
17:27 RE: Foreign Key locking / deadlock issue.... v2 HORDER Phil
17:53 Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerfulIDE for working with PostgreSQL databases Steven Hirsch
17:58 Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerfulIDE for working with PostgreSQL databases Raymond O'Donnell
19:55 Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerfulIDE for working with PostgreSQL databases Tim Clarke
19:58 Re: Introducing brand-new dbForge Studio for PostgreSQL, a powerfulIDE for working with PostgreSQL databases Melvin Davidson
22:00 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Tomas Vondra

23 March 2018

00:08 Re: FDW Foreign Table Access: strange LOG message Albrecht Dreß
00:53 Re: FDW Foreign Table Access: strange LOG message Adrian Klaver
01:27 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
01:40 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Alvaro Herrera
02:20 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Peter Geoghegan
03:24 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel
04:29 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Alessandro Aste
04:42 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Tomas Vondra
04:55 Re: FDW Foreign Table Access: strange LOG message Tom Lane
06:05 Re: postgresql-10.3 on unbuntu-17.10 - how?? Stuart McGraw
06:11 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Peter Geoghegan
10:35 Re: FDW Foreign Table Access: strange LOG message Michael Paquier
10:59 Re: FDW Foreign Table Access: strange LOG message Tom Lane
13:55 primary key and unique index Thomas Poty
14:10 Re: primary key and unique index David Rowley
14:31 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Alessandro Aste
15:23 Re: primary key and unique index Achilleas Mantzios
16:55 Use pgloader with FDW Patricia DECHANDOL
17:43 Re: Foreign Key locking / deadlock issue.... v2 rob stone
18:51 Re: Use pgloader with FDW Adrian Klaver
19:07 RE: Use pgloader with FDW Patricia DECHANDOL
19:25 Re: Use pgloader with FDW Adrian Klaver
19:27 RE: Use pgloader with FDW Patricia DECHANDOL
19:57 Re: Use pgloader with FDW Alban Hertroys
19:59 RE: Use pgloader with FDW Patricia DECHANDOL
20:10 Re: JDBC connectivity issue JCMS22
20:24 Re: JDBC connectivity issue JCMS22
21:42 RE: Foreign Key locking / deadlock issue.... v2 HORDER Phil
23:12 Re: JDBC connectivity issue Dave Cramer
23:41 Re: postgresql-10.3 on unbuntu-17.10 - how?? Christoph Berg

24 March 2018

01:22 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Alessandro Aste
02:58 Re: FDW Foreign Table Access: strange LOG message Albrecht Dreß
03:30 pg_stat_statements: password in command is not obfuscated legrand legrand
04:04 case and accent insensitive MOISES ESPINOSA
04:22 Re: FDW Foreign Table Access: strange LOG message Tom Lane
05:17 Re: pg_stat_statements: password in command is not obfuscated David Rowley
14:53 RE: primary key and unique index HORDER Phil
16:22 Re: primary key and unique index Thomas Poty
17:30 Re: Foreign Key locking / deadlock issue.... v2 rob stone
20:49 Re: case and accent insensitive Andreas Kretschmer

25 March 2018

00:03 RE: Foreign Key locking / deadlock issue.... v2 HORDER Phil
00:20 Re: Foreign Key locking / deadlock issue.... v2 Adrian Klaver
04:44 Re: Troubleshooting a segfault and instance crash Blair Boadway
05:17 Re: Troubleshooting a segfault and instance crash Peter Geoghegan
05:41 Re: Troubleshooting a segfault and instance crash Blair Boadway
07:12 RE: Troubleshooting a segfault and instance crash Jan Bilek
10:18 Re: Troubleshooting a segfault and instance crash Pavel Stehule
15:15 Re: pg_stat_statements: password in command is not obfuscated Michael Paquier

26 March 2018

15:10 RE: Foreign Key locking / deadlock issue.... v2 HORDER Phil
17:41 Problem with postgreSQL Gian mario Caggiu
17:52 Warning of .partial wal file in PITR and Replication Environment Amee Sankhesara - Quipment India
19:35 PostgreSQL version on VMware vSphere ESXI 6.5 and harware version13 nmmulla
20:03 Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harwareversion 13 nmmulla
21:46 Re: [GENERAL] missing public on schema public Alvaro Herrera
22:46 Query performance hmidi slim
23:38 Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version13 Joshua D. Drake

27 March 2018

02:28 Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harwareversion 13 nmmulla
02:49 Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13 David G. Johnston
08:00 Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harwareversion 13 Michael Paquier
08:03 Re: [GENERAL] missing public on schema public Michael Paquier
10:03 Re: Problem with postgreSQL Adrian Klaver
10:12 Autonomous transaction, background worker Thiemo Kellner
10:39 Re: Warning of .partial wal file in PITR and Replication Environment Michael Paquier
13:20 Can't get policy to work correctly Ivo Limmen
14:17 Re: Can't get policy to work correctly Ivo Limmen
16:16 Issue with PostgreSQL replication and PITR Amee Sankhesara - Quipment India
16:22 Using Lateral Johann Spies
17:22 Must re-connect to see tables Blake McBride
17:23 Re: Must re-connect to see tables Blake McBride
17:23 Check constraints. Steve Rogerson
17:28 Re: Must re-connect to see tables Ron
17:48 Re: Must re-connect to see tables rob stone
18:16 Re: Must re-connect to see tables Blake McBride
18:31 Re: Must re-connect to see tables Daniel Verite
19:54 logical decoder lsn order between transactions Tom Dearman
20:42 Proposition for better performance hmidi slim
20:44 Re: Check constraints. Paul Jungwirth
21:13 Re: Autonomous transaction, background worker Paul Jungwirth
21:37 Re: Using Lateral Paul Jungwirth
21:49 Re: Proposition for better performance Paul Jungwirth
22:01 Re: Problem with postgreSQL Adrian Klaver
22:14 Re: Check constraints. Steve Rogerson
23:04 Re: Proposition for better performance hmidi slim
23:31 Re: Proposition for better performance Paul Jungwirth

28 March 2018

00:00 Postgresql 9.3 Server will not start after Ubuntu Upgrade Ken Beck
00:04 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Joshua D. Drake
00:05 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Moreno Andreo
00:14 Re: Proposition for better performance hmidi slim
00:17 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Adrian Klaver
00:25 Re: Proposition for better performance Paul Jungwirth
00:36 Re: Proposition for better performance Paul Jungwirth
00:42 Re: Proposition for better performance hmidi slim
00:44 Re: Problem with postgreSQL Adrian Klaver
02:37 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Ken Beck
02:46 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Ken Beck
02:47 ERROR: invalid byte sequence for encoding "UTF8": 0xfc armand pirvu
02:56 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Tim Cross
02:57 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Adrian Klaver
03:14 Postgres Foreign Data Wrapper and DB2 LUW Rakesh Kumar
03:14 Postgres Foreign Data Wrapper and DB2 LUW Rakesh Kumar
03:25 Re: Proposition for better performance Paul Jungwirth
03:46 Connection hangs on new created schema Juan Manuel Cuello
03:55 Re: Proposition for better performance armand pirvu
04:06 Re: Postgres Foreign Data Wrapper and DB2 LUW ajmcello
04:06 Re: Postgres Foreign Data Wrapper and DB2 LUW ajmcello
04:11 Congrats to PostgreSQL sponsor OpenSCG Joshua D. Drake
04:30 Re: ERROR: invalid byte sequence for encoding "UTF8": 0xfc armand pirvu
04:36 connection dropped from the backend server armand pirvu
04:47 Re: Troubleshooting a segfault and instance crash Blair Boadway
04:51 Re: Postgres Foreign Data Wrapper and DB2 LUW legrand legrand
05:03 Re: connection dropped from the backend server Adrian Klaver
05:07 Re: connection dropped from the backend server armand pirvu
05:11 Re: connection dropped from the backend server Adrian Klaver
05:49 Re: connection dropped from the backend server Tom Lane
08:21 Re: connection dropped from the backend server armand pirvu
09:07 Re: connection dropped from the backend server armand pirvu
10:11 Re: connection dropped from the backend server Adrian Klaver
11:02 pg_dump -Fd -j2 on standby in 9.6.6 Stefan Petrea
11:15 RE: [EXTERNAL]pg_dump -Fd -j2 on standby in 9.6.6 Stefan Petrea
11:25 Re: pg_dump -Fd -j2 on standby in 9.6.6 Andreas Kretschmer
11:53 Re: Issue with PostgreSQL replication and PITR Laurenz Albe
11:58 Re: Connection hangs on new created schema Laurenz Albe
12:01 Hello all, I wanted to install any postgresql database for my development sanjeev kumar
12:13 Re: Hello all, I wanted to install any postgresql database for mydevelopment Thomas Kellerer
13:46 RE: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6 Stefan Petrea
14:05 Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6 Andreas Kretschmer
14:30 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Alessandro Aste
15:11 Fixed chars Enrico Pirozzi
15:32 Re: Fixed chars Andreas Kretschmer
15:53 Re: Fixed chars Enrico Pirozzi
16:06 Re: Connection hangs on new created schema Juan Manuel Cuello
18:22 Re: Using Lateral Johann Spies
19:14 Re: Postgresql 10.3 , query never completes if LIMIT clause isspecified and paralle processing is on Tomas Vondra
19:16 Re: Problem with postgreSQL Adrian Klaver
22:09 Query performance with cluster hmidi slim
22:24 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Moreno Andreo
22:28 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Adrian Klaver
22:36 pg_ctl promote causes error "could not read block" (PG 9.5.0 and 9.5.4) raj 1988
22:46 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Moreno Andreo
23:13 Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6 Ron
23:40 Re: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6 David G. Johnston

29 March 2018

00:33 Re: Using Lateral Paul Jungwirth
00:49 Using Lateral David G. Johnston
03:38 Question about buffers_alloc in pg_stat_bgwriter view for monitoring Alvar Freude
03:49 Query Crashes PG 10.3 using partitions, works on 9.6 Cory Tucker
03:57 RE: Query Crashes PG 10.3 using partitions, works on 9.6 Kumar, Virendra
04:03 RE: Query Crashes PG 10.3 using partitions, works on 9.6 Kumar, Virendra
04:10 Re: Query Crashes PG 10.3 using partitions, works on 9.6 Tom Lane
04:16 Re: Query Crashes PG 10.3 using partitions, works on 9.6 Cory Tucker
04:18 Re: Query Crashes PG 10.3 using partitions, works on 9.6 Cory Tucker
04:19 Re: Query Crashes PG 10.3 using partitions, works on 9.6 Tom Lane
04:45 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Ken Beck
04:58 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Adrian Klaver
06:31 Re: pg_ctl promote causes error "could not read block" (PG 9.5.0 and9.5.4) Michael Paquier
08:29 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Ken Beck
08:35 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Rob Sargent
08:37 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade David G. Johnston
09:31 Re: Autonomous transaction, background worker Thiemo Kellner
10:20 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Adrian Klaver
11:26 Bad Query Plans on 10.3 vs 9.6 Cory Tucker
11:54 Re: Using Lateral Johann Spies
11:56 Re: Bad Query Plans on 10.3 vs 9.6 David Rowley
14:30 Re: Question about buffers_alloc in pg_stat_bgwriter view formonitoring Gunnar \"Nick\" Bluth
15:48 Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade Ben Madin
16:50 Re: Question about buffers_alloc in pg_stat_bgwriter view formonitoring Alvar C.H. Freude
19:47 Re: Bad Query Plans on 10.3 vs 9.6 Tom Lane
20:21 Re: Bad Query Plans on 10.3 vs 9.6 Cory Tucker
20:26 Re: Bad Query Plans on 10.3 vs 9.6 David Rowley
21:08 Re: Bad Query Plans on 10.3 vs 9.6 Cory Tucker
21:21 Question about AWS Calculator Ravi Krishna
21:25 Re: Bad Query Plans on 10.3 vs 9.6 Tom Lane
23:24 Re: Question about buffers_alloc in pg_stat_bgwriter view formonitoring Alvar Freude
23:58 Re: Bad Query Plans on 10.3 vs 9.6 Cory Tucker

30 March 2018

00:04 dblink: could not send query: another command is already in progress Thiemo Kellner
04:29 Asynchronous Trigger? Cory Tucker
05:01 Autovacuum behavior with rapid insert/delete 9.6 Ted Filmore
05:07 Re: Autovacuum behavior with rapid insert/delete 9.6 Peter Geoghegan
11:39 Re: dblink: could not send query: another command is already inprogress Laurenz Albe
11:49 Re: Asynchronous Trigger? Laurenz Albe
13:59 Re: dblink: could not send query: another command is already inprogress Thiemo Kellner
15:14 Re: dblink: could not send query: another command is already inprogress Laurenz Albe
15:50 Re: Question about buffers_alloc in pg_stat_bgwriter view formonitoring Achilleas Mantzios
16:00 Re: Asynchronous Trigger? Adam Tauno Williams
19:46 Schema-based replication Moreno Andreo
23:08 Re: dblink: could not send query: another command is already inprogress Thiemo Kellner
23:54 Redacting params in PostgreSQL logs Vijaykumar Jain

31 March 2018

00:03 Re: Redacting params in PostgreSQL logs Vijaykumar Jain
15:53 Re: Redacting params in PostgreSQL logs Vijaykumar Jain
21:44 Problem with connection to host (wrong host) Mike Martin
21:59 Re: Problem with connection to host (wrong host) Peter Eisentraut
22:00 Re: Problem with connection to host (wrong host) Melvin Davidson