pgsql-general since 2021-12-19 00:00

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

Dec. 19, 2021

Thread Author Time
PGBouncer logs explanation required Shubham Mittal 11:50
RE: Best Strategy for Large Number of Images Zahir Lalani 14:24

Dec. 20, 2021

Thread Author Time
md5 issues Postgres14 on OL7 Michael Mühlbeyer 09:35
Re: Best Strategy for Large Number of Images Estevan Rech 10:29
Re: Best Strategy for Large Number of Images Andreas Joseph Krogh 10:44
Re: Best Strategy for Large Number of Images Imre Samu 11:32
How to reduce query planning time (10s) iulian dragos 12:30
Re: How to reduce query planning time (10s) Pavel Stehule 12:42
Update concurrency Sylvain Déve 13:45
Re: Update concurrency David G. Johnston 13:52
Re: md5 issues Postgres14 on OL7 Christoph Moench-Tegeder 14:22
Re: Update concurrency Tom Lane 15:07
Re: Update concurrency Tom Lane 16:38
Re: How to reduce query planning time (10s) iulian dragos 16:50
Re: How to reduce query planning time (10s) Pavel Stehule 16:53
Re: How to reduce query planning time (10s) Tom Lane 17:04
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn 19:28
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule 19:37
Freeing transient memory in aggregate functions Matt Magoffin 20:26
Re: PGBouncer logs explanation required Peter Eisentraut 21:07
Re: Freeing transient memory in aggregate functions Tom Lane 21:25
How best to turn select result into options like 'a|b|c'' Shaozhong SHI 22:10
Re: How best to turn select result into options like 'a|b|c'' Ray O'Donnell 22:23
Re: How best to turn select result into options like 'a|b|c'' David G. Johnston 22:37

Dec. 21, 2021

Thread Author Time
Re: Max connections reached without max connections reached James Sewell 00:22
Re: Max connections reached without max connections reached James Sewell 00:25
Sorting difference in version 10 vs 13 Akheel Ahmed 05:09
Re: Sorting difference in version 10 vs 13 Tom Lane 05:12
Re: Sorting difference in version 10 vs 13 Akheel Ahmed 05:31
Re: Sorting difference in version 10 vs 13 Ron 06:35
How to confirm the pg_hba.conf service is correctly working shing dong 09:18
Re: How to confirm the pg_hba.conf service is correctly working Tom Lane 14:42
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn 18:28
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule 18:50
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Michael Lewis 18:57
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule 19:04
Re: Freeing transient memory in aggregate functions Matt Magoffin 19:29

Dec. 22, 2021

Thread Author Time
storing zipped SQLite inside PG ? David Gauthier 02:27
Re: storing zipped SQLite inside PG ? Steve Baldwin 02:50
storing zipped SQLite inside PG ? David G. Johnston 03:14
Re: How to confirm the pg_hba.conf service is correctly working shing dong 04:24
Re: How to confirm the pg_hba.conf service is correctly working David G. Johnston 05:01
Re: storing zipped SQLite inside PG ? David Gauthier 05:05
Re: storing zipped SQLite inside PG ? David G. Johnston 05:23
Re: surprisingly slow creation of gist index used in exclude constraint 📎 Chris Withers 09:58
Re: How to confirm the pg_hba.conf service is correctly working Dave Cramer 10:58
Postgresql crashing during pg_dump Paulo Silva 14:13
Re: Postgresql crashing during pg_dump Tom Lane 14:40
Re: Postgresql crashing during pg_dump Ron 14:43
Re: surprisingly slow creation of gist index used in exclude constraint Laurenz Albe 15:21
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn 20:54
Tab-completion error...? Theodore M Rolle, Jr. 21:15
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL David G. Johnston 21:24
Re: When Update balloons memory Peter Geoghegan 21:38
Re: Tab-completion error...? Adrian Klaver 21:54
Re: Tab-completion error...? Magnus Hagander 22:22
Re: Tab-completion error...? Adrian Klaver 22:24

Dec. 23, 2021

Thread Author Time
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn 01:27
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn 01:40
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL David G. Johnston 03:18
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn 04:29
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule 06:25
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule 06:31
Re: [External] Re: md5 issues Postgres14 on OL7 Michael Mühlbeyer 07:28
Re: How to confirm the pg_hba.conf service is correctly working shing dong 10:14
Re: How to confirm the pg_hba.conf service is correctly working Imre Samu 11:25
Re: How to confirm the pg_hba.conf service is correctly working Vijaykumar Jain 13:32
Re: storing zipped SQLite inside PG ? Дмитрий Иванов 15:02
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Bryn Llewellyn 21:05

Dec. 24, 2021

Thread Author Time
Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL Pavel Stehule 05:35

Dec. 25, 2021

Thread Author Time
restore-command error handling Sebastiaan Mannem 08:04

Dec. 26, 2021

Thread Author Time
Wal files in /pgsql/14/main/pg_wal not removed Lucas 12:09
Re: storing zipped SQLite inside PG ? amihay gonen 12:43
Re: Wal files in /pgsql/14/main/pg_wal not removed Tom Lane 16:14
Re: Wal files in /pgsql/14/main/pg_wal not removed Lucas 23:09

Dec. 27, 2021

Thread Author Time
Deprecating plans for PGPASSWORD environment variable as insecure Alexey Murz Korepov 08:55
Re: Deprecating plans for PGPASSWORD environment variable as insecure Pavel Stehule 09:03
Logical Replication - One table 8 minutes, Identical Two Tables 28 Minutes (Expected 16 Minutes) Avi Weinberg 13:35

Dec. 28, 2021

Thread Author Time
psql command failing with error "undefined symbol: PQhostaddr" Narendra katlamudi 12:29
Re: psql command failing with error "undefined symbol: PQhostaddr" Osvaldo Kussama 12:44
Re: psql command failing with error "undefined symbol: PQhostaddr" Pavel Stehule 12:52
Re: psql command failing with error "undefined symbol: PQhostaddr" Adrian Klaver 15:54

Dec. 29, 2021

Thread Author Time
Re: psql command failing with error "undefined symbol: PQhostaddr" Narendra katlamudi 08:31
Initial Sync - One Subscriber After The Other vs. Parallel Avi Weinberg 12:39
Find missing data in a column john polo 17:43
Find missing data in a column David G. Johnston 17:54
Re: Find missing data in a column Adrian Klaver 17:56
Re: Find missing data in a column Adrian Klaver 18:07
Re: Find missing data in a column Rob Sargent 18:10
Re: Find missing data in a column Adrian Klaver 18:16
Re: Find missing data in a column Alan Hodgson 18:36
csv copy error ourdiaspora 21:08
Re: csv copy error Adrian Klaver 21:15
Re: csv copy error David G. Johnston 21:46
Default values in functions Michael Lewis 22:59
Re: Default values in functions Tom Lane 23:31
Re: Default values in functions David G. Johnston 23:34

Dec. 30, 2021

Thread Author Time
Re: Default values in functions Michael Lewis 00:17
Re: Default values in functions Michael Lewis 00:22
Re: Default values in functions Tom Lane 00:28
Re: Default values in functions Tom Lane 00:31
Re: Default values in functions Michael Lewis 00:46
Re: Find missing data in a column john polo 02:09
pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq 07:09
Re: csv copy error Guillaume Lelarge 07:30
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Magnus Hagander 09:48

Dec. 31, 2021

Thread Author Time
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq 02:32
Re: csv copy error ourdiaspora 10:03
create query with date values ourdiaspora 13:12
Re: create query with date values Ron 15:34
Re: create query with date values David G. Johnston 16:24
a very naive question about table names in Postgres Martin Mueller 20:27
Re: a very naive question about table names in Postgres Craig McIlwee 20:36
Re: a very naive question about table names in Postgres Gavin Flower 20:40
Re: a very naive question about table names in Postgres Craig McIlwee 20:41
Re: a very naive question about table names in Postgres Karsten Hilbert 21:06
Re: a very naive question about table names in Postgres Josef Šimánek 21:17
Re: a very naive question about table names in Postgres Paul Jungwirth 21:25

Jan. 1, 2022

Thread Author Time
Re: a very naive question about table names in Postgres Dave Cramer 11:48
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Adrian Klaver 16:41
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Magnus Hagander 16:57

Jan. 2, 2022

Thread Author Time
Visibility of data from table inherits function ourdiaspora 12:23
Re: Visibility of data from table inherits function David G. Johnston 15:50
Re: Visibility of data from table inherits function Francisco Olarte 15:54
Re: Visibility of data from table inherits function ourdiaspora 19:41
Re: Visibility of data from table inherits function Adrian Klaver 19:55
Re: Visibility of data from table inherits function Achilleas Mantzios 21:37

Jan. 3, 2022

Thread Author Time
Re: Visibility of data from table inherits function Francisco Olarte 08:04
VACUUM FULL missing chunk number 0 for toast value Yi Sun 09:28
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq 14:58
Re: VACUUM FULL missing chunk number 0 for toast value Tom Lane 16:18
postgres_fdw FAST "where id in (140,144,148)" SLOW: "where id in (select 140 as id union select 144 union select 148)" Avi Weinberg 16:26

Jan. 4, 2022

Thread Author Time
restoring a single database from a pg_dumpall dump file Matthias Apitz 08:30
Re: md5 issues Postgres14 on OL7 Michael Paquier 11:52
Re: restoring a single database from a pg_dumpall dump file Tom Lane 15:01
Refresh ONE publication out of the Two Publications the Subscription has Avi Weinberg 15:47
Re: md5 issues Postgres14 on OL7 Tom Lane 17:54
Re: Tab-completion error...? Theodore M Rolle, Jr. 18:22
Re: Refresh ONE publication out of the Two Publications the Subscription has Achilleas Mantzios 18:29
Re: Tab-completion error...? Tom Lane 18:32
Re: As a Linux distro, how to package multiple postgres major versions? Chocimier 21:15
Re: md5 issues Postgres14 on OL7 Christoph Moench-Tegeder 21:16
Re: Tab-completion error...? Theodore M Rolle, Jr. 23:04
Re: Tab-completion error...? Tom Lane 23:15
Re: As a Linux distro, how to package multiple postgres major versions? Adrian Klaver 23:18

Jan. 5, 2022

Thread Author Time
Re: md5 issues Postgres14 on OL7 Michael Paquier 05:51
Re: md5 issues Postgres14 on OL7 Tom Lane 06:08
Re: md5 issues Postgres14 on OL7 Michael Paquier 07:09
Postgis - geography function Sameer TWAYANA 08:48
Can we use sql language to create a function in Postgres? Shaozhong SHI 11:04
Re: Can we use sql language to create a function in Postgres? Ray O'Donnell 11:08
Re: Can we use sql language to create a function in Postgres? Ray O'Donnell 11:10
Re: Can we use sql language to create a function in Postgres? hubert depesz lubaczewski 11:12
Re: Can we use sql language to create a function in Postgres? Shaozhong SHI 11:22
Re: Can we use sql language to create a function in Postgres? Shaozhong SHI 11:26
Re: Can we use sql language to create a function in Postgres? hubert depesz lubaczewski 11:34
How best to create and use associative array type in Postgres? Shaozhong SHI 12:10
Create and access a dictionary type Shaozhong SHI 13:17
Re: Postgis - geography function Tomas Vondra 13:20
Re: Create and access a dictionary type Tomas Vondra 13:22
Re: Create and access a dictionary type Shaozhong SHI 13:36
Replicate consistent snapshot to a second PG instance using FDWs Thomas Michael Engelke 14:12
Re: How best to create and use associative array type in Postgres? Tom Lane 14:54
Re: How best to create and use associative array type in Postgres? Shaozhong SHI 16:11
Re: How best to create and use associative array type in Postgres? Tom Lane 16:24
Re: Create and access a dictionary type Ron 16:24
Re: Create and access a dictionary type Tomas Vondra 16:35
Re: Create and access a dictionary type Tomas Vondra 16:37
Re: Create and access a dictionary type Ron 16:57
Re: Create and access a dictionary type Rob Sargent 16:59
Re: Can we use sql language to create a function in Postgres? Merlin Moncure 17:42
Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Dominique Devienne 18:05
Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Rob Sargent 18:10
Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Tom Lane 18:26
Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Tom Lane 19:04
Re: How best to create and use associative array type in Postgres? Shaozhong SHI 20:26
Re: How best to create and use associative array type in Postgres? Adrian Klaver 20:34

Jan. 6, 2022

Thread Author Time
How to write such a query? Igor Korot 06:39
Re: How to write such a query? Amul Sul 06:46
Re: How to write such a query? David G. Johnston 07:00
Re: How to write such a query? Ron 07:00
Re: How to write such a query? Igor Korot 07:06
Re: How to write such a query? Igor Korot 07:07
Re: How to write such a query? Ron 07:11
Re: How to write such a query? Igor Korot 07:14
Re: How to write such a query? Ron 07:14
Re: How to write such a query? Dmitry Igrishin 08:17
Re: md5 issues Postgres14 on OL7 📎 Michael Paquier 08:20
Getting json-value as varchar Andreas Joseph Krogh 12:28
Re: Getting json-value as varchar Thomas Markus 12:31
Re: Getting json-value as varchar Andreas Joseph Krogh 12:36
Recommended storage hardware Levente Birta 12:53
pg_dump parameter Augusto Mossambani 12:57
Re: Getting json-value as varchar David G. Johnston 13:13
Sv: Recommended storage hardware Andreas Joseph Krogh 13:17
Re: Getting json-value as varchar Andreas Joseph Krogh 13:20
Re: Getting json-value as varchar Thomas Markus 13:25
Re: Getting json-value as varchar David G. Johnston 13:29
Re: Getting json-value as varchar Andreas Joseph Krogh 13:33
Re: Getting json-value as varchar Pavel Stehule 13:42

Browse Archives

Prev | Next