pgsql-general - April 2018

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

April 1, 2018

Thread Author Time
Re: unreliable behaviour of track_functions pinker 00:17
Re: unreliable behaviour of track_functions Adrian Klaver 04:08
Please suggest the best suited unit test frame work for postgresql database. Raghavendra Rao J S V 04:56
Re: unreliable behaviour of track_functions pinker 13:02
Re: unreliable behaviour of track_functions pinker 13:02
Re: unreliable behaviour of track_functions pinker 13:10
Re: Please suggest the best suited unit test frame work for postgresql database. Adrian Klaver 14:57
Re: unreliable behaviour of track_functions Adrian Klaver 16:29
PostgreSQL Cascade streaming replication problem Jakub Janeček 18:26
Re: [PATCH] Logical decoding of TRUNCATE Andres Freund 20:01

April 2, 2018

Thread Author Time
Re: [PATCH] Logical decoding of TRUNCATE Simon Riggs 06:39
Re: Please suggest the best suited unit test frame work for postgresql database. Steven Lembark 16:58
Re: Please suggest the best suited unit test frame work for postgresql database. Rob Sargent 17:05
Concatenate of values in hierarchical data Mr. Baseball 34 17:23
How to get an inclusive interval when using daterange hmidi slim 18:09
Re: [PATCH] Logical decoding of TRUNCATE Peter Eisentraut 18:30
Re: [PATCH] Logical decoding of TRUNCATE Simon Riggs 18:40
Re: [PATCH] Logical decoding of TRUNCATE Andres Freund 18:43
Re: [PATCH] Logical decoding of TRUNCATE Andres Freund 18:50
Re: How to get an inclusive interval when using daterange Tom Lane 19:13
Re: [PATCH] Logical decoding of TRUNCATE Christophe Pettus 21:04

April 3, 2018

Thread Author Time
Re: PostgreSQL Cascade streaming replication problem Michael Paquier 02:43
Re: PostgreSQL Cascade streaming replication problem Jakub Janeček 05:56
Re: PostgreSQL Cascade streaming replication problem Jakub Janeček 06:10
Autovacuum Problem Kein Name 06:36
Re: Autovacuum Problem Achilleas Mantzios 06:49
Re: Autovacuum Problem Kein Name 07:00
Re: Autovacuum Problem Achilleas Mantzios 07:39
Re: Autovacuum Problem Kein Name 07:54
Re: Autovacuum Problem Achilleas Mantzios 08:39
Seems like there is an issue with reltuples showing twice the number of rows Ranjith Ramachandra 09:14
Re: dblink: could not send query: another command is already in progress Laurenz Albe 09:28
How to install pgTAP on cenos machine Raghavendra Rao J S V 09:34
Re: Autovacuum Problem Vitaliy Garnashevich 10:35
Re: Seems like there is an issue with reltuples showing twice the number of rows Tomas Vondra 11:02
Re: How to install pgTAP on cenos machine Adrian Klaver 13:48
Re: Seems like there is an issue with reltuples showing twice the number of rows Tom Lane 14:19
Re: How to get an inclusive interval when using daterange hmidi slim 14:35
Re: How to get an inclusive interval when using daterange Adrian Klaver 14:37
Re: Seems like there is an issue with reltuples showing twice the number of rows Ranjith Ramachandra 15:22
Re: is pg_advisory_lock() suitable for long runs Merlin Moncure 16:30
Re: How to get an inclusive interval when using daterange hmidi slim 16:40
Re: How to get an inclusive interval when using daterange Paul Jungwirth 17:12
single sql, multiple schemas, one result set PegoraroF10 17:47
Re: single sql, multiple schemas, one result set Guyren Howe 18:05
Re: single sql, multiple schemas, one result set Rob Sargent 18:12
Concurrent CTE Artur Formella 20:01
LDAP Bind Password Kumar, Virendra 20:12

April 4, 2018

Thread Author Time
Re: dblink: could not send query: another command is already in progress 📎 Thiemo Kellner 00:35
Re: [PATCH] Logical decoding of TRUNCATE 📎 Peter Eisentraut 02:31
Re: dblink: could not send query: another command is already in progress Laurenz Albe 06:11
Re: [PATCH] Logical decoding of TRUNCATE Simon Riggs 07:03
Re: Concatenate of values in hierarchical data Alban Hertroys 09:43
PgUpgrade bumped my XIDs by ~50M? Jerry Sievers 22:29
Re: PgUpgrade bumped my XIDs by ~50M? Bruce Momjian 23:28

April 5, 2018

Thread Author Time
SQL statement in an error report for deferred constraint violation. Konrad Witaszczyk 00:04
Re: PgUpgrade bumped my XIDs by ~50M? Jerry Sievers 00:13
Extension make installcheck: include update/insert feedback? Paul Jungwirth 00:17
Re: PgUpgrade bumped my XIDs by ~50M? Bruce Momjian 00:29
Re: LDAP Bind Password Peter Eisentraut 00:40
Re: Extension make installcheck: include update/insert feedback? Tom Lane 01:06
Re: PgUpgrade bumped my XIDs by ~50M? Jerry Sievers 03:01
Re: Concurrent CTE Jeremy Finzel 04:31
Re: Concurrent CTE David G. Johnston 04:46
Re: Concurrent CTE Thomas Munro 05:12
Re: Concurrent CTE David G. Johnston 05:16
Re: Concurrent CTE Thomas Munro 05:47
AW: Concurrent CTE kpi6288 06:01
Re: Concurrent CTE Dorian Hoxha 14:52
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Adam =?utf-8?Q?Sj=C3=B8gren?= 15:19
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Adam =?utf-8?Q?Sj=C3=B8gren?= 15:32
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Tom Lane 15:37
pg_basebackup or dump for starting replication process PegoraroF10 15:45
Re: [PATCH] Logical decoding of TRUNCATE 📎 Peter Eisentraut 15:52
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Adam =?utf-8?Q?Sj=C3=B8gren?= 16:03
Docker + postgreSQL : OOM killing in a large Group by operation Jorge Daniel 17:02
Re: [PATCH] Logical decoding of TRUNCATE Alvaro Herrera 17:07
Re: Docker + postgreSQL : OOM killing in a large Group by operation Tom Lane 17:27
Re: PgUpgrade bumped my XIDs by ~50M? Jerry Sievers 18:39
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Adam =?utf-8?Q?Sj=C3=B8gren?= 20:27
Re: PgUpgrade bumped my XIDs by ~50M? Bruce Momjian 20:39
Re: PgUpgrade bumped my XIDs by ~50M? Jerry Sievers 21:02
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Tom Lane 21:04
decompose big queries hmidi slim 22:39
Re: decompose big queries David G. Johnston 22:51

April 6, 2018

Thread Author Time
ERROR: found multixact from before relminmxid Alexandre Arruda 00:09
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Pavan Deolasee 03:25
Re: pg_basebackup or dump for starting replication process Laurenz Albe 06:24
Extract dates of a given day hmidi slim 10:32
Re: Extract dates of a given day mariusz 12:19
Re: Extract dates of a given day rob stone 12:21
RE: LDAP Bind Password Kumar, Virendra 12:39
Re: ERROR: found multixact from before relminmxid Tomas Vondra 12:39
Re: decompose big queries Edson Carlos Ericksson Richter 13:06
Re: decompose big queries pinker 13:35
Re: decompose big queries Melvin Davidson 14:03
Re: decompose big queries Steven Hirsch 14:09
Re: ERROR: found multixact from before relminmxid Alexandre Arruda 14:29
dealing with lock Thomas Poty 14:58
Re: dealing with lock Laurenz Albe 15:11
Re: ERROR: found multixact from before relminmxid Tomas Vondra 16:11
Re: dealing with lock Thomas Poty 19:09
FDW with DB2 Ravi Krishna 20:01
Re: FDW with DB2 Joshua D. Drake 20:09
Re: FDW with DB2 Ravi Krishna 20:57
Re: FDW with DB2 Steven Hirsch 21:28
Re: dealing with lock Adrian Klaver 22:02
Re: FDW with DB2 Ravi Krishna 22:12
Re: FDW with DB2 Steven Hirsch 23:00
Re: FDW with DB2 Ravi Krishna 23:09

April 7, 2018

Thread Author Time
Re: dealing with lock Thomas Kellerer 06:00
Re: dealing with lock Thomas Poty 07:56
Re: dealing with lock Thomas Poty 07:57
Conflict between JSON_AGG and COPY Đỗ Ngọc Trí Cường 10:44
dump/restore problem due to CVE-2018-1058 (9.5.12) Rory Campbell-Lange 19:27
Re: dump/restore problem due to CVE-2018-1058 (9.5.12) Adrian Klaver 19:46
Re: [PATCH] Logical decoding of TRUNCATE Peter Eisentraut 23:40

April 8, 2018

Thread Author Time
Re: dump/restore problem due to CVE-2018-1058 (9.5.12) Rory Campbell-Lange 10:40
Re: dump/restore problem due to CVE-2018-1058 (9.5.12) Adrian Klaver 15:01
Sum of written buffers bigger than allocation? pinker 15:28
Re: Sum of written buffers bigger than allocation? Jeff Janes 15:53
Re: Conflict between JSON_AGG and COPY Adrian Klaver 17:59
Re: dump/restore problem due to CVE-2018-1058 (9.5.12) Rory Campbell-Lange 18:01
Re: dump/restore problem due to CVE-2018-1058 (9.5.12) Adrian Klaver 18:15
Rationale for aversion to the central database? Guyren Howe 21:39
Re: Rationale for aversion to the central database? Alvaro Aguayo Garcia-Rada 21:57
Re: Rationale for aversion to the central database? Ravi Krishna 22:09
Re: Rationale for aversion to the central database? Adrian Klaver 22:09
Re: Rationale for aversion to the central database? g@luxsci.net 22:37
Re: Rationale for aversion to the central database? Ravi Krishna 22:52
Re: Rationale for aversion to the central database? Stephen Frost 23:39
Re: Rationale for aversion to the central database? Stephen Frost 23:43

April 9, 2018

Thread Author Time
Re: Rationale for aversion to the central database? Tim Cross 01:37
Re: Rationale for aversion to the central database? Peter Klipstein 02:27
Re: Conflict between JSON_AGG and COPY Đỗ Ngọc Trí Cường 03:44
pg_stat_all_tables not updated when VACUUM ANALYZE execution finishes Sebastien Arod 10:37
Re: ERROR: found multixact from before relminmxid Alexandre Arruda 11:49
Re: pg_stat_all_tables not updated when VACUUM ANALYZE execution finishes Adrian Klaver 13:42
Re: Rationale for aversion to the central database? Peter J. Holzer 13:44
Re: Rationale for aversion to the central database? Ray Cote 13:45
algo for canceling a deadlocked transaction Thomas Poty 13:46
Re: algo for canceling a deadlocked transaction Stephen Frost 13:51
Re: Rationale for aversion to the central database? Melvin Davidson 13:57
Re: ERROR: found multixact from before relminmxid Tomas Vondra 14:01
Re: Rationale for aversion to the central database? Peter J. Holzer 14:04
Re: Conflict between JSON_AGG and COPY Adrian Klaver 14:14
Re: Conflict between JSON_AGG and COPY David G. Johnston 14:33
Re: algo for canceling a deadlocked transaction Thomas Poty 14:33
Re: algo for canceling a deadlocked transaction Christophe Pettus 14:42
Re: algo for canceling a deadlocked transaction Tom Lane 15:04
best way to write large data-streams quickly? Mark Moellering 15:49
Re: best way to write large data-streams quickly? Steve Atkins 16:01
Re: List all columns referencing an FK Peter Eisentraut 17:45
Re: How to monitor logical replication initial sync? Peter Eisentraut 18:09
Re: algo for canceling a deadlocked transaction Thomas Poty 18:47
Re: Conflict between JSON_AGG and COPY Daniel Verite 18:48
Re: Conflict between JSON_AGG and COPY Adrian Klaver 19:42
Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 karthik kumar 20:01
Re: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 Adrian Klaver 20:19
Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 karthik kumar 21:10
Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 Adrian Klaver 21:13
Re: ERROR: found multixact from before relminmxid Peter Geoghegan 21:23
Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 karthik kumar 21:37
Re: Rationale for aversion to the central database? Tim Cross 22:16
Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 Adrian Klaver 23:52

April 10, 2018

Thread Author Time
Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 Adrian Klaver 00:06
Re: ERROR: found multixact from before relminmxid Alexandre Arruda 00:55
Re: Fwd: Carto ODBC_FDW issue "ERROR: Connecting to driver" from PG to DB2 karthik kumar 00:59
Re: ERROR: found multixact from before relminmxid Peter Geoghegan 01:16
Re: ERROR: found multixact from before relminmxid Alexandre Arruda 01:56
Re: ERROR: found multixact from before relminmxid Peter Geoghegan 02:51
Re: ERROR: found multixact from before relminmxid Andres Freund 02:53
Re: ERROR: found multixact from before relminmxid Peter Geoghegan 03:08
Grant to a group defined in Windows AD Hans Schou 08:36
Using enum instead of join tables hmidi slim 10:24
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Pavan Deolasee 10:42
Re: ERROR: found multixact from before relminmxid Alexandre Arruda 11:31
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Adam =?utf-8?Q?Sj=C3=B8gren?= 11:52
Postgresql Split Brain: Which one is latest Vikas Sharma 13:50
Re: best way to write large data-streams quickly? Mark Moellering 14:17
Re: Postgresql Split Brain: Which one is latest Achilleas Mantzios 14:20
Re: Postgresql Split Brain: Which one is latest Adrian Klaver 14:26
Re: Postgresql Split Brain: Which one is latest Vikas Sharma 15:04
Re: Postgresql Split Brain: Which one is latest Melvin Davidson 15:28
Re: Postgresql Split Brain: Which one is latest Edson Carlos Ericksson Richter 15:35
Multiple records returned by a JOIN Alexander Farber 15:44
Re: Multiple records returned by a JOIN David G. Johnston 16:01
Re: Multiple records returned by a JOIN Alexander Farber 16:18
Re: Multiple records returned by a JOIN Alexander Farber 16:21
Re: Postgresql Split Brain: Which one is latest Adrian Klaver 16:29
Re: Postgresql Split Brain: Which one is latest Vikas Sharma 16:47
Re: Postgresql Split Brain: Which one is latest Ron 16:52
Re: Postgresql Split Brain: Which one is latest Adrian Klaver 16:55
Re: Postgresql Split Brain: Which one is latest Vikas Sharma 17:02
Re: Postgresql Split Brain: Which one is latest Adrian Klaver 17:07
Suggest the best values for the postgres configuration parameters Raghavendra Rao J S V 17:32
difference between checkpoint_segments and wal_keep_segments in postgres configuration file Raghavendra Rao J S V 17:36
Planning to change autovacuum_vacuum_scale_factor value to zero. Please suggest me if any negative impact. Raghavendra Rao J S V 17:45
Re: best way to write large data-streams quickly? Jerry Sievers 18:09
Re: Postgresql Split Brain: Which one is latest Jehan-Guillaume (ioguix) de Rorthais 19:19

Browse Archives

Prev | Next