pgsql-general - September 2019

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

Sept. 1, 2019

Thread Author Time
Re: SQL equivalint of #incude directive ? Tony Shelver 08:05
Re: SQL equivalint of #incude directive ? Francisco Olarte 10:03
pgmodeler ? stan 10:30
Re: pgmodeler ? stan 10:35
Re: pgmodeler ? Olivier Gautherot 10:41
Re: pgmodeler ? Pavel Stehule 11:04
Re: pgmodeler ? Thiemo Kellner 11:45
Re: Unexpected "canceling statement due to user request" error 📎 Tom Lane 23:46

Sept. 2, 2019

Thread Author Time
Re: Unexpected "canceling statement due to user request" error Will Storey 00:21
Re: Unexpected "canceling statement due to user request" error Tom Lane 00:58
Upgrade 96 -> 11 James Sewell 04:03
Re: How to get RAISE messges displayed? Luca Ferrari 06:28
partition by range or by list constraint check (was Re: literal vs dynamic partition constraint in plan execution) Luca Ferrari 08:40
Re: Upgrade 96 -> 11 Adrian Klaver 13:56
Re: partition by range or by list constraint check (was Re: literal vs dynamic partition constraint in plan execution) Tom Lane 15:32
Posible off topic ? pgmodeler stan 17:31
Re: Posible off topic ? pgmodeler Susan Hurst 20:43
Re: Posible off topic ? pgmodeler Thiemo Kellner 21:01
Re: Upgrade 96 -> 11 James Sewell 21:20
Re: Upgrade 96 -> 11 Adrian Klaver 21:41
Re: Upgrade 96 -> 11 James Sewell 21:45
Re: Upgrade 96 -> 11 Adrian Klaver 21:55
Re: Upgrade 96 -> 11 James Sewell 23:57

Sept. 3, 2019

Thread Author Time
Re: Upgrade 96 -> 11 Adrian Klaver 00:15
Re: Upgrade 96 -> 11 James Sewell 00:20
Re: Upgrade 96 -> 11 Adrian Klaver 00:34
Re: Upgrade 96 -> 11 James Sewell 00:38
Re: Upgrade 96 -> 11 Adrian Klaver 00:52
restore and recovery using WAL: unkown messages in serverlog Matthias Apitz 07:56
Re: implicit transaction changes trigger behaviour Willy-Bas Loos 08:06
Re: restore and recovery using WAL: unkown messages in serverlog Luca Ferrari 08:12
Re: pgmodeler ? Tony Shelver 09:09
Slow statement using parallelism after 9.6>11 upgrade Arnaud L. 12:10
Re: Slow statement using parallelism after 9.6>11 upgrade Tom Lane 13:43
Re: Slow statement using parallelism after 9.6>11 upgrade Arnaud L. 14:06
Re: Slow statement using parallelism after 9.6>11 upgrade Paul Ramsey 14:39
Postgres HA issue - Standby server does not start after Master compute host is shut down 📎 Nagendra Bandi 14:57
Re: Slow statement using parallelism after 9.6>11 upgrade Imre Samu 15:02
Re: Slow statement using parallelism after 9.6>11 upgrade Arnaud L. 15:04
Re: Slow statement using parallelism after 9.6>11 upgrade Arnaud L. 15:09
Re: Postgres HA issue - Standby server does not start after Master compute host is shut down Jehan-Guillaume (ioguix) de Rorthais 15:13
Re: Postgres HA issue - Standby server does not start after Master compute host is shut down Nagendra Bandi 16:01
Re: Bad Estimate for multi tenant database queries Michael Lewis 18:39
Re: literal vs dynamic partition constraint in plan execution Michael Lewis 19:00
Re: Upgrade 96 -> 11 Adrian Klaver 19:47
Running a Simple Update Statement Fails, Second Time Suceeds. Kumar, Virendra 20:56
RE: Running a Simple Update Statement Fails, Second Time Suceeds. Kumar, Virendra 21:08
Re: Running a Simple Update Statement Fails, Second Time Suceeds. Adrian Klaver 21:32
Re: Running a Simple Update Statement Fails, Second Time Suceeds. Tom Lane 21:41
Re: Running a Simple Update Statement Fails, Second Time Suceeds. Kumar, Virendra 22:08
Re: Bad Estimate for multi tenant database queries Peter Grman 22:10
Re: Upgrade 96 -> 11 James Sewell 22:45
killing vacuum analyze process Julie Nishimura 23:02
Re: killing vacuum analyze process Tom Lane 23:11
Re: killing vacuum analyze process Julie Nishimura 23:29
Re: Unexpected "canceling statement due to user request" error Will Storey 23:38

Sept. 4, 2019

Thread Author Time
Re: Upgrade 96 -> 11 Adrian Klaver 00:03
Re: killing vacuum analyze process Ron 00:19
Re: killing vacuum analyze process Tom Lane 03:56
Re: Upgrade 96 -> 11 James Sewell 06:18
Re: Slow statement using parallelism after 9.6>11 upgrade Arnaud L. 07:04
Re: Slow statement using parallelism after 9.6>11 upgrade Arnaud L. 07:14
Re: Slow statement using parallelism after 9.6>11 upgrade Arnaud L. 08:28
Re: Postgres HA issue - Standby server does not start after Master compute host is shut down Jehan-Guillaume (ioguix) de Rorthais 08:36
Re: Postgres HA issue - Standby server does not start after Master compute host is shut down Luca Ferrari 09:14
RE: Running a Simple Update Statement Fails, Second Time Suceeds. Kumar, Virendra 15:02
PG11.2 - wal_level =minimal max_wal_senders = 0 Jason Ralph 15:15
Re: Running a Simple Update Statement Fails, Second Time Suceeds. Tom Lane 15:17
Re: PG11.2 - wal_level =minimal max_wal_senders = 0 Luca Ferrari 16:16
RE: PG11.2 - wal_level =minimal max_wal_senders = 0 Jason Ralph 20:44
Re: Running a Simple Update Statement Fails, Second Time Suceeds. Adrian Klaver 23:42

Sept. 5, 2019

Thread Author Time
floating point output Rob Sargent 00:23
Re: floating point output Adrian Klaver 04:14
Re: PG11.2 - wal_level =minimal max_wal_senders = 0 Luca Ferrari 06:33
Re: floating point output Luca Ferrari 06:48
Uninstall postgres Sonam Sharma 08:53
Sv: Uninstall postgres Andreas Joseph Krogh 08:57
Re: Uninstall postgres Sonam Sharma 09:01
Re: Uninstall postgres Sonam Sharma 09:07
Re: Uninstall postgres Andreas Joseph Krogh 09:12
Rebuild pg_toast from scratch? Moreno Andreo 12:12
Re: floating point output Rob Sargent 13:32
Re: Rebuild pg_toast from scratch? Tom Lane 13:53
Cannot restore dump when using IS DISTINCT FROM on a HSTORE column Lele Gaifax 14:16
Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column Adrian Klaver 14:30
Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column Tom Lane 14:35
Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column Adrian Klaver 14:50
postgresql: Help with hstore hextension Lu, Dan 15:04
Re: postgresql: Help with hstore hextension Tom Lane 16:05
Re: Rebuild pg_toast from scratch? Moreno Andreo 16:20
Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column Lele Gaifax 16:23
RE: postgresql: Help with hstore hextension Lu, Dan 16:24
Re: Rebuild pg_toast from scratch? Tom Lane 16:37
Environment Variable for --data-checksum during initdb Ray Cote 19:25
Question from someone who is not trained in computer sciences Judith Lacoste 21:00
Re: Question from someone who is not trained in computer sciences Ben Chobot 21:13
Re: Question from someone who is not trained in computer sciences Peter Geoghegan 21:30
Re: Question from someone who is not trained in computer sciences Basques, Bob (CI-StPaul) 21:35
Re: Question from someone who is not trained in computer sciences Ron 21:48
pg_restore issues with intarray Kevin Brannen 21:57
Re: Environment Variable for --data-checksum during initdb Adrian Klaver 22:29
Re: Question from someone who is not trained in computer sciences Adrian Klaver 22:42
Re: pg_restore issues with intarray Adrian Klaver 22:52
RE: pg_restore issues with intarray Kevin Brannen 23:06
Re: Question from someone who is not trained in computer sciences Sam Gendler 23:08
Re: pg_restore issues with intarray Adrian Klaver 23:24
Re: pg_restore issues with intarray Adrian Klaver 23:28
Re: Question from someone who is not trained in computer sciences Judith Lacoste 23:33

Sept. 6, 2019

Thread Author Time
RE: pg_restore issues with intarray Kevin Brannen 00:05
Re: pg_restore issues with intarray Adrian Klaver 00:35
Re: pg_restore issues with intarray Jerry Sievers 00:37
Seeking New Members for the Community Code of Conduct Committee Stacey Haysler 06:20
Re: PG11.2 - wal_level =minimal max_wal_senders = 0 Benoit Lobréau 07:41
Primary Key Update issue ? Patrick FICHE 09:06
Sv: Primary Key Update issue ? Andreas Joseph Krogh 09:16
RE: Primary Key Update issue ? Patrick FICHE 09:25
RE: Primary Key Update issue ? Andreas Joseph Krogh 09:34
Bad estimates on GIN bigint[] index Arnaud L. 10:26
RE: SQL equivalint of #incude directive ? Kevin Brannen 15:05
RE: pg_restore issues with intarray Kevin Brannen 15:32
RE: pg_restore issues with intarray Kevin Brannen 15:45
Re: pg_restore issues with intarray Jerry Sievers 16:58
RE: pg_restore issues with intarray Kevin Brannen 17:38
Re: pg_restore issues with intarray Adrian Klaver 22:39

Sept. 7, 2019

Thread Author Time
Re: PG11.2 - wal_level =minimal max_wal_senders = 0 Jason Ralph 00:15
Convert a row to a nested JSON document containing all relations in PostgreSQL Ali Alizadeh 04:35
Re: Environment Variable for --data-checksum during initdb Ray Cote 12:32
kind of a bag of attributes in a DB . . . Albretch Mueller 12:45
Re: Environment Variable for --data-checksum during initdb Adrian Klaver 18:02
Re: kind of a bag of attributes in a DB . . . Adrian Klaver 18:05
Re: Convert a row to a nested JSON document containing all relations in PostgreSQL Adrian Klaver 19:15
How to access Postgres .pgpass file from php? Howard Wells 22:17
Re: How to access Postgres .pgpass file from php? Adrian Klaver 22:40

Sept. 8, 2019

Thread Author Time
Whan is it safe to mark a function PARALLEL SAFE? Jim Finnerty 01:37
Re: kind of a bag of attributes in a DB . . . Chris Travers 10:01
Re: How to access Postgres .pgpass file from php? rob stone 12:02
Re: Convert a row to a nested JSON document containing all relations in PostgreSQL Ali Alizadeh 12:22
Re: Whan is it safe to mark a function PARALLEL SAFE? Tom Lane 19:27
Re: Whan is it safe to mark a function PARALLEL SAFE? Peter Geoghegan 20:28
Re: Convert a row to a nested JSON document containing all relations in PostgreSQL Adrian Klaver 21:11
help formualting a query stan 23:11
Re: help formualting a query Tom Lane 23:23

Sept. 9, 2019

Thread Author Time
Re: floating point output Rob Sargent 04:16
Re: floating point output Tom Lane 05:03
Re: PG11.2 - wal_level =minimal max_wal_senders = 0 Luca Ferrari 06:48
pgbouncer with ldap Ayub M 07:26
Re: pgbouncer with ldap Christoph Moench-Tegeder 07:40
Re: pgbouncer with ldap Ayub M 07:58
Re: pgbouncer with ldap Christoph Moench-Tegeder 08:03
Re: pgbouncer with ldap Laurenz Albe 09:41
Re: floating point output Peter J. Holzer 10:19
Re: pgbouncer with ldap Achilleas Mantzios 10:46
Permissions on postgresql.conf, psql and patroni Peter J. Holzer 10:58
Re: Permissions on postgresql.conf, psql and patroni Daniel Verite 11:29
database "cdf_100_1313" does not exist nikhil raj 11:46
Re: database "cdf_100_1313" does not exist Karsten Hilbert 11:54
Re: database "cdf_100_1313" does not exist nikhil raj 11:58
Re: Whan is it safe to mark a function PARALLEL SAFE? Jim Finnerty 12:42
Re: database "cdf_100_1313" does not exist Dan Livingston 13:08
Re: database "cdf_100_1313" does not exist nikhil raj 13:16
Re: database "cdf_100_1313" does not exist Rob Sargent 13:28
Re: database "cdf_100_1313" does not exist nikhil raj 13:43
Re: Permissions on postgresql.conf, psql and patroni Tom Lane 14:03
Re: database "cdf_100_1313" does not exist Tom Lane 14:17
Re: database "cdf_100_1313" does not exist nikhil raj 14:30
Re: database "cdf_100_1313" does not exist Adrian Klaver 14:34
Re: database "cdf_100_1313" does not exist nikhil raj 14:38
Re: database "cdf_100_1313" does not exist Daniel Verite 14:45
Re: Permissions on postgresql.conf, psql and patroni Peter J. Holzer 17:15
Re: Permissions on postgresql.conf, psql and patroni Peter J. Holzer 18:43
Issues with inconsistent COLLATION installation Cory Nemelka 18:43
Re: Issues with inconsistent COLLATION installation Cory Nemelka 18:45
Re: Issues with inconsistent COLLATION installation Cory Nemelka 20:08
Re: Issues with inconsistent COLLATION installation Tom Lane 20:29
Re: Issues with inconsistent COLLATION installation Daniel Verite 20:46
Re: Issues with inconsistent COLLATION installation Tom Lane 21:08
Re: Issues with inconsistent COLLATION installation Cory Nemelka 21:18
Re: pgbouncer with ldap Ayub M 23:50
RE: database "cdf_100_1313" does not exist Klint Gore 23:54

Sept. 10, 2019

Thread Author Time
pgrounting extension in 11 Prakash Ramakrishnan 12:59
Re: pgrounting extension in 11 Adrian Klaver 13:46
Re: pgrounting extension in 11 Prakash Ramakrishnan 13:53
Re: pgrounting extension in 11 Adrian Klaver 14:19
Re: pgrounting extension in 11 Prakash Ramakrishnan 14:28
pg full text search very slow for Chinese characters Jimmy Huang 15:53
Re: pg full text search very slow for Chinese characters Cory Nemelka 16:00
Re: pg full text search very slow for Chinese characters Michael Lewis 16:10
Re: pg full text search very slow for Chinese characters Cory Nemelka 16:13
Re: pg full text search very slow for Chinese characters Jimmy Huang 16:20
Re: pg full text search very slow for Chinese characters Tom Lane 16:21
Re: pg full text search very slow for Chinese characters Andreas Joseph Krogh 16:42
Re: kind of a bag of attributes in a DB . . . Albretch Mueller 16:59
Recover data from aborted transactions Aaron Spike 17:18
Re: kind of a bag of attributes in a DB . . . Adrian Klaver 19:26

Sept. 11, 2019

Thread Author Time
Re: pg full text search very slow for Chinese characters Kyotaro Horiguchi 02:34
ERROR: too many dynamic shared memory segments Nicola Contu 07:47