pgsql-general - June 2021

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

June 1, 2021

Thread Author Time
Re: Query on postgres_fdw extension Etsuro Fujita 10:01
Re: Query on postgres_fdw extension Bharath Rupireddy 10:24
RE: Framework for 0 downtime deploys Zahir Lalani 11:45
Re: Query on postgres_fdw extension Swathi P 15:09
CREATE/REFRESH MATERIALIZED VIEW planner difference? Philip Semanchuk 18:00
Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Vijaykumar Jain 18:20
Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Philip Semanchuk 18:26
Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Tom Lane 18:51
Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Vijaykumar Jain 19:15
Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Thomas Munro 19:23
Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Vijaykumar Jain 19:31
Internationalisation (i18n) with Postgres as backend Laura Smith 20:09
Re: Internationalisation (i18n) with Postgres as backend Rob Sargent 20:37
Re: Internationalisation (i18n) with Postgres as backend Steve Baldwin 21:10
Re: Internationalisation (i18n) with Postgres as backend Laura Smith 23:00
Re: Internationalisation (i18n) with Postgres as backend Laura Smith 23:08
Re: Internationalisation (i18n) with Postgres as backend Rob Sargent 23:42

June 2, 2021

Thread Author Time
Is consistent (deterministic) ordering possible in our case? gerry gan 06:21
Re: Is consistent (deterministic) ordering possible in our case? Vijaykumar Jain 06:49
Re: Internationalisation (i18n) with Postgres as backend Laura Smith 07:08
Re: Internationalisation (i18n) with Postgres as backend Laurenz Albe 08:38
Re: Internationalisation (i18n) with Postgres as backend Laurenz Albe 08:43
Re: CREATE/REFRESH MATERIALIZED VIEW planner difference? Philip Semanchuk 12:39

June 3, 2021

Thread Author Time
Re: Is consistent (deterministic) ordering possible in our case? gerry gan 01:34
Re: Is consistent (deterministic) ordering possible in our case? Tom Lane 02:51
BUG #17046: Upgrade postgres 11 to 13 version PG Bug reporting form 10:50
Re: BUG #17046: Upgrade postgres 11 to 13 version David Rowley 12:31
RE: BUG #17046: Upgrade postgres 11 to 13 version Ram Pratap Maurya 12:53
Dropping dependent tables Tiffany Thang 13:41
Re: Dropping dependent tables Tom Lane 14:18
LZ4 missing in pg14-beta1 Windows build, OLD VS/compiler used Hans Buschmann 17:56
Re: max_connections Vijaykumar Jain 18:44
syntax question Marc Millas 18:58
Re: syntax question Bruce Momjian 19:01
Re: syntax question Adrian Klaver 19:11
Re: syntax question Tom Lane 19:21
Re: max_connections Vijaykumar Jain 19:21
Re: syntax question Bruce Momjian 19:34
Re: syntax question Marc Millas 19:53
Re: syntax question Marc Millas 20:01
Re: syntax question David G. Johnston 20:22
index unique Marc Millas 20:51
Re: syntax question Marc Millas 20:55
Re: index unique Paul Ramsey 20:57
Re: syntax question Guyren Howe 21:07
Re: index unique Marc Millas 21:11
Re: syntax question Adrian Klaver 21:17
possible license violations tom.beacon 21:31
Re: BUG #17046: Upgrade postgres 11 to 13 version Adrian Klaver 21:37
arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Bryn Llewellyn 21:40
Re: syntax question Marc Millas 21:43
Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Adrian Klaver 21:44
Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Tom Lane 21:59
Re: possible license violations Bruce Momjian 22:02
Re: possible license violations Tom Lane 22:08
Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why? Bryn Llewellyn 22:10
inner subprograms ... Was: syntax question Bryn Llewellyn 22:35
Re: possible license violations Bruce Momjian 23:00

June 4, 2021

Thread Author Time
Re: Dropping dependent tables Tiffany Thang 01:10
Noinheritance with superuser saket bansal 03:13
Please tell me about character code conversion. 久門 愛 03:32
Re: Noinheritance with superuser Tom Lane 03:59
Re: Please tell me about character code conversion. Tom Lane 04:04
strange behavior of WAL files Atul Kumar 10:09
Re: strange behavior of WAL files Jehan-Guillaume de Rorthais 10:56
EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Pól Ua Laoínecháin 10:58
Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Vijaykumar Jain 11:27
RE: BUG #17046: Upgrade postgres 11 to 13 version Ram Pratap Maurya 11:46
Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. David Rowley 12:12
Re: strange behavior of WAL files Atul Kumar 12:54
Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Laurenz Albe 12:55
Re: strange behavior of WAL files Vijaykumar Jain 13:15
Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. David Rowley 13:40
Re: strange behavior of WAL files Vijaykumar Jain 13:42
Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Tom Lane 13:43
Re: strange behavior of WAL files Tom Lane 14:11
Re: EXPLAIN (ANALYZE, BUFFERS) - puzzling numbers for a simple query. Pól Ua Laoínecháin 14:16
Re: BUG #17046: Upgrade postgres 11 to 13 version Adrian Klaver 14:24
EXCLUDE USING and tstzrange Laura Smith 14:32
autovacuum on pg_catalog tables Zwettler Markus (OIZ) 14:40
Re: EXCLUDE USING and tstzrange Adrian Klaver 14:44
Re: EXCLUDE USING and tstzrange Laura Smith 14:58
Re: strange behavior of WAL files Atul Kumar 15:10
Re: EXCLUDE USING and tstzrange Joe Conway 15:20
Re: EXCLUDE USING and tstzrange Laura Smith 15:33
Re: autovacuum on pg_catalog tables Vijaykumar Jain 15:37
AW: [Extern] Re: autovacuum on pg_catalog tables Zwettler Markus (OIZ) 15:43
Re: [Extern] Re: autovacuum on pg_catalog tables Michael Lewis 15:51
Re: AW: [Extern] Re: autovacuum on pg_catalog tables Tom Lane 16:03
Re: AW: [Extern] Re: autovacuum on pg_catalog tables Laurenz Albe 16:04
Re: strange behavior of WAL files Atul Kumar 16:06
Re: possible license violations Stephen Frost 16:34
Struggling with EXCLUDE USING gist Laura Smith 16:47
Re: Struggling with EXCLUDE USING gist Adrian Klaver 17:07
Re: Struggling with EXCLUDE USING gist Julien Rouhaud 17:11
Re: Struggling with EXCLUDE USING gist Laura Smith 17:32
Re: Struggling with EXCLUDE USING gist Laura Smith 17:37
Re: Struggling with EXCLUDE USING gist Mark Dilger 17:45
Re: Struggling with EXCLUDE USING gist Adrian Klaver 18:02
Re: Struggling with EXCLUDE USING gist Adrian Klaver 18:21
Re: Struggling with EXCLUDE USING gist Joe Conway 18:26
Re: Struggling with EXCLUDE USING gist Laura Smith 18:31
Re: Struggling with EXCLUDE USING gist Laura Smith 18:55
Re: Struggling with EXCLUDE USING gist Mark Dilger 18:56
Re: Struggling with EXCLUDE USING gist Adrian Klaver 18:56
Re: strange behavior of WAL files Vijaykumar Jain 19:11
symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility rob stan 22:21
Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility Bruce Momjian 22:38
Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility Ron 22:39
Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility Tom Lane 22:44

June 5, 2021

Thread Author Time
Re: symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol: PQsetErrorContextVisibility rob stan 02:17
Ideas for building a system that parses medical research publications/articles Achilleas Mantzios 09:49
Re: Ideas for building a system that parses medical research publications/articles Laura Smith 10:52
Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios 11:14
Aw: Ideas for building a system that parses medical research publications/articles Karsten Hilbert 11:41
Re: Ideas for building a system that parses medical research publications/articles Laura Smith 11:44
Re: Ideas for building a system that parses medical research publications/articles Vijaykumar Jain 13:45
Re: Ideas for building a system that parses medical research publications/articles Adrian Klaver 15:34
Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios 16:56
Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios 17:03
Re: Ideas for building a system that parses medical research publications/articles Adrian Klaver 17:03
Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios 17:39
Re: Ideas for building a system that parses medical research publications/articles Adrian Klaver 19:12
Re: strange behavior of WAL files Tom Lane 19:44
Re: Ideas for building a system that parses medical research publications/articles Achilleas Mantzios 20:10

June 6, 2021

Thread Author Time
Symbolic link breaks for postgresql.auto.conf RAJAMOHAN 16:00
Re: Symbolic link breaks for postgresql.auto.conf Adrian Klaver 16:13
Re: Symbolic link breaks for postgresql.auto.conf Tom Lane 16:46
Re: Symbolic link breaks for postgresql.auto.conf Vijaykumar Jain 17:02
Re: Symbolic link breaks for postgresql.auto.conf Adrian Klaver 17:15
Re: Symbolic link breaks for postgresql.auto.conf Adrian Klaver 19:32
Re: strange behavior of WAL files Ravi Krishna 23:30
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 23:49

June 7, 2021

Thread Author Time
Re: index unique Peter J. Holzer 06:55
AW: AW: [Extern] Re: autovacuum on pg_catalog tables Zwettler Markus (OIZ) 10:07
base directory size getting increased Atul Kumar 10:41
Re: Symbolic link breaks for postgresql.auto.conf RAJAMOHAN 11:11
RE: Ideas for building a system that parses medical research publications/articles [EXT] Daniel Perrett 11:22
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 11:52
Re: base directory size getting increased Laurenz Albe 12:04
bottom / top posting Vijaykumar Jain 12:05
Re: base directory size getting increased Atul Kumar 12:18
Re: base directory size getting increased Ravi Krishna 13:44
Re: base directory size getting increased Laurenz Albe 13:50
Database issues when adding GUI Rich Shepard 15:02
Re: Database issues when adding GUI Rob Sargent 15:07
Re: Database issues when adding GUI Rob Sargent 15:09
Re: Database issues when adding GUI Philip Semanchuk 15:21
Re: Database issues when adding GUI Rich Shepard 15:31
Re: Database issues when adding GUI Rich Shepard 15:32
Re: Database issues when adding GUI Rob Sargent 15:37
Re: Database issues when adding GUI Adrian Klaver 15:42
Re: Database issues when adding GUI Rich Shepard 15:49
Re: AW: AW: [Extern] Re: autovacuum on pg_catalog tables Tom Lane 15:52
Re: Database issues when adding GUI Rich Shepard 15:56
Re: Database issues when adding GUI Tom Lane 15:57
Re: Database issues when adding GUI Rich Shepard 16:00
Re: Database issues when adding GUI Tom Lane 16:00
Re: Database issues when adding GUI Rich Shepard 16:03
Re: Database issues when adding GUI Alan Hodgson 16:08
Re: Database issues when adding GUI Tom Lane 16:11
Re: Database issues when adding GUI Rich Shepard 16:12
Re: Database issues when adding GUI Rich Shepard 16:17
Re: Database issues when adding GUI Tom Lane 16:17
Re: Database issues when adding GUI Rich Shepard 16:18
Re: Database issues when adding GUI Edson Carlos Ericksson Richter 16:18
Re: bottom / top posting Sam Gendler 16:20
Re: Database issues when adding GUI Rich Shepard 16:22
Re: base directory size getting increased Atul Kumar 16:22
Re: Database issues when adding GUI Tom Lane 16:24
Re: Database issues when adding GUI Alan Hodgson 16:24
Re: base directory size getting increased Atul Kumar 16:28
Re: bottom / top posting Tom Lane 16:31
Re: Database issues when adding GUI Rich Shepard 16:35
Re: Database issues when adding GUI David G. Johnston 16:42
Re: Database issues when adding GUI Adrian Klaver 17:19
Re: Database issues when adding GUI Rich Shepard 17:20
Re: index unique David G. Johnston 17:20
Re: Database issues when adding GUI Rich Shepard 17:21
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 17:27
Re: Database issues when adding GUI Adrian Klaver 17:33
Re: Database issues when adding GUI Rich Shepard 17:43
Re: bottom / top posting Francisco Olarte 17:53
Re: bottom / top posting Francisco Olarte 18:02
Re: bottom / top posting Dean Gibson (DB Administrator) 18:53
Need to omit time during weekends from age calculations David Gauthier 19:12
Re: Need to omit time during weekends from age calculations Ron 19:17
Re: Need to omit time during weekends from age calculations Joe Conway 19:34
Re: Need to omit time during weekends from age calculations Tom Lane 19:39
Re: Need to omit time during weekends from age calculations Pavel Stehule 19:45
Re: Need to omit time during weekends from age calculations David Gauthier 21:01
Re: Database issues when adding GUI Rich Shepard 21:26
Re: Database issues when adding GUI Adrian Klaver 21:29
Re: Database issues when adding GUI David G. Johnston 21:32
Re: Database issues when adding GUI David G. Johnston 21:34
Re: Database issues when adding GUI Adrian Klaver 21:39
Re: bottom / top posting Joshua Drake 21:40
Re: Database issues when adding GUI Rich Shepard 22:02
Re: Database issues when adding GUI Rich Shepard 22:04
Re: Database issues when adding GUI Adrian Klaver 22:06

Browse Archives

Prev | Next