pgsql-general - June 2017

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

Search the Archives

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

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

June 1, 2017

Thread Author Time
Re: dump to pg vinny 08:14
Re: Build PostgreSQL With XML Support on Linux Osahon Oduware 09:49
Re: Redo the filenode link in tablespace tel medola 10:47
Re: Slow query plan used Wetzel, Juergen (Juergen) 12:07
Re: Redo the filenode link in tablespace Adrian Klaver 13:29
Re: Slow query plan used Andreas Kretschmer 14:45
Re: Slow query plan used Bill Moran 15:43
Rounding Double Precision or Numeric Louis Battuello 16:26
Re: Rounding Double Precision or Numeric Torsten Förtsch 16:41
Re: Slow query plan used Tom Lane 16:41
Re: Rounding Double Precision or Numeric Steve Atkins 16:42
Re: Rounding Double Precision or Numeric Scott Marlowe 16:58
Re: jsonb case insensitive search Karl Czajkowski 17:24
Re: Rounding Double Precision or Numeric Louis Battuello 17:38
Re: jsonb case insensitive search armand pirvu 19:05
Re: jsonb case insensitive search armand pirvu 20:14
Re: jsonb case insensitive search Karl Czajkowski 20:44
Re: dump to pg Nicolas Paris 21:21
Re: dump to pg Thomas Kellerer 21:33
Re: dump to pg Nicolas Paris 21:37
repmgr cascade replication node delay Juliano 22:30
Re: repmgr cascade replication node delay David G. Johnston 22:42

June 2, 2017

Thread Author Time
Re: jsonb case insensitive search Guyren Howe 00:00
Re: Slow query plan used Wetzel, Juergen (Juergen) 05:51
Re: Slow query plan used Tom Lane 06:06
Oracle database into PostgreSQL using Ora2PG tool. PAWAN SHARMA 08:16
Re: Oracle database into PostgreSQL using Ora2PG tool. Pavel Stehule 08:43
Re: Oracle database into PostgreSQL using Ora2PG tool. PAWAN SHARMA 09:03
Re: Oracle database into PostgreSQL using Ora2PG tool. PAWAN SHARMA 09:15
Re: Oracle database into PostgreSQL using Ora2PG tool. Pavel Stehule 09:33
Why restore_command is called for existing files in pg_xlog? Alexander Kukushkin 09:51
PostGIS ST_CreateOverview Function For Non-Public Schema Osahon Oduware 09:52
Writing a C function to return the log file name Kouber Saparev 11:35
Re: Oracle database into PostgreSQL using Ora2PG tool. Neil Anderson 12:19
Re: Oracle database into PostgreSQL using Ora2PG tool. Igor Neyman 13:45
ST_CreateOverview Function Generating Overview-Rasters With Black Grids 📎 Osahon Oduware 13:51
Re: Oracle database into PostgreSQL using Ora2PG tool. Igor Neyman 13:52
Re: repmgr cascade replication node delay Juliano 14:03
Re: Oracle database into PostgreSQL using Ora2PG tool. stevenchang1213 15:57
Re: dump to pg Neil Anderson 16:31
Re: dump to pg Adrian Klaver 17:39
Re: dump to pg Nicolas Paris 18:03
Re: Oracle database into PostgreSQL using Ora2PG tool. 📎 Neil Anderson 20:10
Re: Oracle database into PostgreSQL using Ora2PG tool. Igor Neyman 20:18
Re: dump to pg 📎 Neil Anderson 20:24
index duplicates primary key, but is used more? jonathan vanasco 23:02
Re: index duplicates primary key, but is used more? Tom Lane 23:11

June 4, 2017

Thread Author Time
Re: index duplicates primary key, but is used more? Steven Chang 04:36
Re: dump to pg Steven Chang 09:24

June 5, 2017

Thread Author Time
pg_rewind - enable wal_log_hints or data-checksums Dylan Luong 00:37
Re: pg_rewind - enable wal_log_hints or data-checksums Michael Paquier 01:38
Re: Oracle database into PostgreSQL using Ora2PG tool. PAWAN SHARMA 09:08
Unable to install EASM postgre due to error 8023 Garry Sim 10:14
Re: Redo the filenode link in tablespace tel medola 12:24
Re: Redo the filenode link in tablespace tel medola 14:17
Re: Redo the filenode link in tablespace Adrian Klaver 18:41
Re: Redo the filenode link in tablespace tel medola 18:55
Re: Redo the filenode link in tablespace Adrian Klaver 19:02
Re: Redo the filenode link in tablespace tel medola 19:10
Help with restoring a dump in Tar format? (dependencies/ordering) Ken Tanzer 22:35
Re: Help with restoring a dump in Tar format? (dependencies/ordering) David G. Johnston 22:57
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Adrian Klaver 23:02
Re: Redo the filenode link in tablespace 📎 tel medola 23:07
Re: Redo the filenode link in tablespace Adrian Klaver 23:13

June 6, 2017

Thread Author Time
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Ken Tanzer 00:15
Re: Help with restoring a dump in Tar format? (dependencies/ordering) John R Pierce 00:28
Re: Help with restoring a dump in Tar format? (dependencies/ordering) David G. Johnston 00:32
Re: Help with restoring a dump in Tar format? (dependencies/ordering) John R Pierce 00:40
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Ken Tanzer 00:45
Re: Help with restoring a dump in Tar format? (dependencies/ordering) David G. Johnston 00:49
Re: Help with restoring a dump in Tar format? (dependencies/ordering) John R Pierce 00:52
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Adrian Klaver 00:52
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Ken Tanzer 00:59
Re: Help with restoring a dump in Tar format? (dependencies/ordering) David G. Johnston 01:10
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Ken Tanzer 01:21
Re: Help with restoring a dump in Tar format? (dependencies/ordering) David G. Johnston 01:44
Re: Unable to install EASM postgre due to error 8023 Scott Mead 01:55
Re: Unable to install EASM postgre due to error 8023 Garry Sim 01:59
Re: Unable to install EASM postgre due to error 8023 Scott Mead 02:09
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Tom Lane 02:11
Re: Unable to install EASM postgre due to error 8023 Garry Sim 02:13
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Ken Tanzer 02:25
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Adrian Klaver 02:41
Replication slot and pg_rewind Bhattacharyya, Subhro 03:03
Re: Replication slot and pg_rewind Michael Paquier 03:19
Re: Replication slot and pg_rewind Bhattacharyya, Subhro 04:52
Re: Replication slot and pg_rewind Michael Paquier 05:04
Re: Redo the filenode link in tablespace tel medola 11:40
Re: Redo the filenode link in tablespace Adrian Klaver 13:37
Re: Writing a C function to return the log file name Albe Laurenz 15:56
Re: Redo the filenode link in tablespace tel medola 18:09
Re: Redo the filenode link in tablespace Adrian Klaver 19:37
Re: Redo the filenode link in tablespace tel medola 21:07

June 7, 2017

Thread Author Time
Re: Redo the filenode link in tablespace Adrian Klaver 00:08
Extract from text id other table - PG 9.1 Patrick B 02:32
Re: Extract from text id other table - PG 9.1 David G. Johnston 03:50
Re: Writing a C function to return the log file name Kouber Saparev 09:44
Re: Extract from text id other table - PG 9.1 Jan de Visser 12:24
ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 ADSJ (Adam Sjøgren) 13:33
Advisory lock deadlock issue David Rosenstrauch 14:16
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Achilleas Mantzios 14:22
Re: Advisory lock deadlock issue Merlin Moncure 14:32
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Harry Ambrose 14:49
Re: Redo the filenode link in tablespace tel medola 14:53
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Achilleas Mantzios 15:01
Re: Advisory lock deadlock issue David Rosenstrauch 15:11
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Tom Lane 15:27
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Harry Ambrose 16:28
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Tom Lane 16:46
Re: Help with restoring a dump in Tar format? (dependencies/ordering) Tom Lane 17:42
Re: Advisory lock deadlock issue Adrian Klaver 20:46
How does BDR replicate changes among nodes in a BDR group Zhu, Joshua 20:50
Re: Redo the filenode link in tablespace Adrian Klaver 20:58

June 8, 2017

Thread Author Time
Re: How does BDR replicate changes among nodes in a BDR group Craig Ringer 00:58
Re: Redo the filenode link in tablespace tel medola 01:05
pg_catalog tables don't have constraints? Neil Anderson 03:43
Re: pg_catalog tables don't have constraints? Tom Lane 04:07
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 📎 Harry Ambrose 08:33
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 📎 Harry Ambrose 08:33
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 📎 Harry Ambrose 08:33
Re: Redo the filenode link in tablespace tel medola 10:53
Re: Redo the filenode link in tablespace Karsten Hilbert 11:04
Re: Redo the filenode link in tablespace tel medola 11:11
Re: Redo the filenode link in tablespace Karsten Hilbert 11:43
Re: pg_catalog tables don't have constraints? Neil Anderson 11:59
Re: Redo the filenode link in tablespace Adrian Klaver 13:33
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 ADSJ (Adam Sjøgren) 15:13
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 ADSJ (Adam Sjøgren) 15:19
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Adrian Klaver 15:23
Weirdness with "not in" query greigwise 15:27
Re: Weirdness with "not in" query Alban Hertroys 15:33
Re: Weirdness with "not in" query greigwise 15:35
Re: Weirdness with "not in" query Adrian Klaver 15:38
Performance issue with Pointcloud extension 📎 Eric Lemoine 16:00
Re: Performance issue with Pointcloud extension Bill Moran 16:13
Removing null bytes from a json column Timothy Garnett 16:15
Re: Performance issue with Pointcloud extension Adrian Klaver 16:18
Re: Performance issue with Pointcloud extension 📎 Eric Lemoine 16:20
Re: Performance issue with Pointcloud extension Adrian Klaver 16:23
Re: Performance issue with Pointcloud extension 📎 Eric Lemoine 16:40
Re: Performance issue with Pointcloud extension 📎 Eric Lemoine 17:10
Re: Performance issue with Pointcloud extension Moreno Andreo 17:27
Re: Performance issue with Pointcloud extension 📎 Eric Lemoine 17:41
Is there a way to verify a signed digest within Postgres? Jonathan Zacharuk 17:45
Re: Performance issue with Pointcloud extension Tom Lane 18:07
Re: How does BDR replicate changes among nodes in a BDR group Zhu, Joshua 18:47
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Tom Lane 18:49
Db backup Jimmy Lunceford 19:10
Re: Db backup Joshua D. Drake 19:21
Re: Db backup John R Pierce 19:29
Re: Db backup John R Pierce 19:34
Re: Performance issue with Pointcloud extension Éric 20:41

June 9, 2017

Thread Author Time
Function with limit and offset - PostgreSQL 9.3 marcinha rocha 00:53
Re: Function with limit and offset - PostgreSQL 9.3 David G. Johnston 01:05
Re: Function with limit and offset - PostgreSQL 9.3 John R Pierce 01:13
Re: How does BDR replicate changes among nodes in a BDR group Craig Ringer 01:34
Re: Function with limit and offset - PostgreSQL 9.3 marcinha rocha 01:36
Re: Function with limit and offset - PostgreSQL 9.3 David G. Johnston 01:49
Re: Function with limit and offset - PostgreSQL 9.3 marcinha rocha 02:13
Re: Function with limit and offset - PostgreSQL 9.3 David G. Johnston 02:47
Re: Function with limit and offset - PostgreSQL 9.3 John R Pierce 04:56
Limiting DB access by role after initial connection? Ken Tanzer 05:37
Re: Limiting DB access by role after initial connection? Ken Tanzer 07:07
pg_upgrade --link on Windows Arnaud L. 10:00
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Harry Ambrose 11:44
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Achilleas Mantzios 12:13
Re: Limiting DB access by role after initial connection? Joe Conway 13:42
Re: pg_upgrade --link on Windows Bruce Momjian 14:07
Enc: Extending SQL in C using VARIABLE length type in user defined type Fabiana Zioti 14:18
Re: pg_upgrade --link on Windows Adrian Klaver 14:24
Re: Limiting DB access by role after initial connection? [email protected] 14:31
Re: pg_upgrade --link on Windows Arnaud L. 14:39
Re: pg_upgrade --link on Windows Adrian Klaver 14:55
Re: pg_upgrade --link on Windows Arnaud L. 15:02
Re: pg_upgrade --link on Windows Arnaud L. 15:28
Vacuum and state_change armand pirvu 15:45
Re: Limiting DB access by role after initial connection? Ken Tanzer 15:56
Re: Vacuum and state_change Adrian Klaver 16:01
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Harry Ambrose 16:02
Re: Performance issue with Pointcloud extension 📎 Eric Lemoine 16:13
Re: Vacuum and state_change armand pirvu 16:13
Re: pg_upgrade --link on Windows George Neuner 16:13
Re: Vacuum and state_change Adrian Klaver 16:23
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Robert Lakes 16:34
Re: pg_upgrade --link on Windows George Neuner 16:45
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Tom Lane 17:19
Re: Performance issue with Pointcloud extension Adrian Klaver 17:35
Re: Performance issue with Pointcloud extension Jeff Janes 17:36
Re: Limiting DB access by role after initial connection? Joe Conway 18:22
Re: pg_catalog tables don't have constraints? kbrannen 18:57
Re: pg_catalog tables don't have constraints? Thomas Kellerer 19:04
Re: Vacuum and state_change armand pirvu 20:31
Re: Vacuum and state_change Adrian Klaver 20:52
Re: Vacuum and state_change armand pirvu 21:01
Re: Limiting DB access by role after initial connection? Ken Tanzer 21:16
Re: Vacuum and state_change Adrian Klaver 21:20
Re: Limiting DB access by role after initial connection? Ken Tanzer 21:20
Re: Vacuum and state_change armand pirvu 21:26
Re: Limiting DB access by role after initial connection? Joe Conway 21:30
Re: pg_catalog tables don't have constraints? Neil Anderson 22:03

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30