pgsql-general since 2022-08-31 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)

Browse Archives

Prev | Next

Aug. 31, 2022

Thread Author Time
CREATE SUBSCRIPTION not picking up .pgpass while psql does Kristjan Mustkivi 13:03
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does hubert depesz lubaczewski 13:07
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does Kristjan Mustkivi 13:26
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does hubert depesz lubaczewski 13:27
Re: CREATE SUBSCRIPTION not picking up .pgpass while psql does Kristjan Mustkivi 13:39
View definition changes after reloading pg_dump export Wesley Schwengle 18:53

Sept. 1, 2022

Thread Author Time
Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword Torge 01:07
Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword Tom Lane 01:47
Re: Feature request for count_estimate(samplesize) aggregate or SAMPLE keyword Torge 01:49
Vacuum Full is not returning space to OS Sushant Postgres 09:47
Re: Vacuum Full is not returning space to OS Ron 11:57
Re: Vacuum Full is not returning space to OS Daniel Gustafsson 12:01
Re: Vacuum Full is not returning space to OS Ron 12:37
Re: View definition changes after reloading pg_dump export Tom Lane 14:08
Re: View definition changes after reloading pg_dump export Wesley Schwengle 14:35
Re: View definition changes after reloading pg_dump export Ron 14:36
Diffs in PG output vs WAL V 17:14
Re: Diffs in PG output vs WAL Christophe Pettus 17:19
Re: Missing query plan for auto_explain. Matheus Martin 19:20
Bind Parameter is Too Big Kluzak, Matthew C. 20:34
Re: Bind Parameter is Too Big Adrian Klaver 20:46
Re: Bind Parameter is Too Big Tom Lane 20:48
RE: Bind Parameter is Too Big Kluzak, Matthew C. 20:51
Re: Bind Parameter is Too Big Adrian Klaver 20:54
Re: Bind Parameter is Too Big Tom Lane 21:03
How to make PostreSQL utilities honor home directories? Jeffrey Walton 22:01
Re: How to make PostreSQL utilities honor home directories? Adrian Klaver 22:06
Re: How to make PostreSQL utilities honor home directories? Tom Lane 22:16
Re: How to make PostreSQL utilities honor home directories? Adrian Klaver 22:58
Re: How to make PostreSQL utilities honor home directories? Peter 23:04

Sept. 2, 2022

Thread Author Time
Re: How to make PostreSQL utilities honor home directories? Peter J. Holzer 00:23
Re: How to make PostreSQL utilities honor home directories? Jeffrey Walton 00:49
Re: How to make PostreSQL utilities honor home directories? Tom Lane 00:51
Re: How to make PostreSQL utilities honor home directories? Jeffrey Walton 01:31
Re: How to make PostreSQL utilities honor home directories? Ken Tanzer 02:59
Re: How to make PostreSQL utilities honor home directories? Adrian Klaver 04:10
RE: Unable to archive logs in standby server Meera Nair 04:41
Re: Missing query plan for auto_explain. Julien Rouhaud 04:48
Re: Missing query plan for auto_explain. Matheus Martin 09:58
Re: Missing query plan for auto_explain. Peter J. Holzer 11:16
Re: How to make PostreSQL utilities honor home directories? Peter J. Holzer 11:27
Re: How to make PostreSQL utilities honor home directories? Peter J. Holzer 11:34
Re: Unable to archive logs in standby server Christophe Pettus 14:12
Re: How to make PostreSQL utilities honor home directories? Jeffrey Walton 14:55
RE: Unable to archive logs in standby server Meera Nair 16:47
Determine if a user and database are available Jeffrey Walton 21:22
Re: Determine if a user and database are available Christophe Pettus 21:42
Re: Determine if a user and database are available David G. Johnston 22:00
Re: Determine if a user and database are available Tom Lane 22:21

Sept. 3, 2022

Thread Author Time
Re: Determine if a user and database are available Ron 00:33
Re: Determine if a user and database are available Adrian Klaver 00:44
Re: Determine if a user and database are available Tom Lane 00:55
[Beginner Querstion]Where can I find the news of database? BeginnerC 08:37
Re: [Beginner Querstion]Where can I find the news of database? Lutz Horn 08:50
Re: [Beginner Querstion]Where can I find the news of database? Mladen Gogala 20:35

Sept. 5, 2022

Thread Author Time
Re: Unable to archive logs in standby server Kyotaro Horiguchi 02:00
Re: Creating constraint dynamically [email protected] 06:02
How to check if checkpoint is finished in sql script? Yi Sun 08:55
Re: How to check if checkpoint is finished in sql script? hubert depesz lubaczewski 10:05
RE: Unable to archive logs in standby server Meera Nair 10:50
Re: Missing query plan for auto_explain. Matheus Martin 13:52
Re: Support logical replication of DDLs 📎 Ajin Cherian 14:18
Re: Missing query plan for auto_explain. Maxim Boguk 23:28

Sept. 6, 2022

Thread Author Time
Changing the admin/postgres user password Jeffrey Walton 02:40
Re: Changing the admin/postgres user password Christophe Pettus 02:46
Re: Changing the admin/postgres user password David G. Johnston 03:04
Postgres SQL unable to handle Null values for Text datatype Karthik K L V 06:10
Re: Postgres SQL unable to handle Null values for Text datatype Lutz Horn 06:25
RE: Unable to start replica after failover Lahnov, Igor 06:46
Re: Unable to start replica after failover Alexander Kukushkin 07:16
Re: Postgres SQL unable to handle Null values for Text datatype Mladen Gogala 12:57
Re: Postgres SQL unable to handle Null values for Text datatype Christophe Pettus 13:38
Re: Determine if a user and database are available Jeffrey Walton 14:13
log_min_messages = warning Dirschel, Steve 19:07
Feature proposal: immutable/sealed partitions (and maybe tables, too) Levi Aul 19:39
Re: log_min_messages = warning Adrian Klaver 19:45
RE: [EXT] Re: log_min_messages = warning Dirschel, Steve 19:54
Re: [EXT] Re: log_min_messages = warning Tom Lane 20:44
Re: Feature proposal: immutable/sealed partitions (and maybe tables, too) Ron 20:52
RE: [EXT] Re: log_min_messages = warning Dirschel, Steve 21:02
Re: [EXT] Re: log_min_messages = warning Tom Lane 21:29

Sept. 7, 2022

Thread Author Time
Re: Feature proposal: immutable/sealed partitions (and maybe tables, too) David Rowley 00:52
Re: Feature proposal: immutable/sealed partitions (and maybe tables, too) Levi Aul 01:33
Re: Feature proposal: immutable/sealed partitions (and maybe tables, too) David Rowley 01:58
RE: [EXT] Re: log_min_messages = warning Dirschel, Steve 13:24
Re: [EXT] Re: log_min_messages = warning Tom Lane 13:30

Sept. 8, 2022

Thread Author Time
[BeginnerQuestion]Why these is 6 rows in my SELECT statement? BeginnerC 08:37
Re: [BeginnerQuestion]Why these is 6 rows in my SELECT statement? Ian Lawrence Barwick 09:02
Re: Missing query plan for auto_explain. Matheus Martin 10:17
Re: [BeginnerQuestion]Why these is 6 rows in my SELECT statement? hubert depesz lubaczewski 12:41

Sept. 9, 2022

Thread Author Time
WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted Perry Smith 03:05
Re: WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted Tom Lane 03:42
Re: WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted Mladen Gogala 04:03
Re: ***SPAM*** Re: WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted Perry Smith 04:08
Re: ***SPAM*** Re: WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted Mladen Gogala 04:12
Re: ERROR: cache lookup failed for user mapping 476444 shanker singh 13:04
Re: ERROR: cache lookup failed for user mapping 476444 Tom Lane 15:10
Re: ERROR: cache lookup failed for user mapping 476444 Shanker Singh 16:17
Re: Missing query plan for auto_explain. Maxim Boguk 21:05

Sept. 10, 2022

Thread Author Time
pgBackRest on MacOS Marc 12:31
Re: pgBackRest on MacOS Ron 12:53

Sept. 11, 2022

Thread Author Time
[Beginner Question]Where can I get the source of hstore? Wen Yi 02:40
Re: [Beginner Question]Where can I get the source of hstore? Tom Lane 02:44
Re: [Beginner Question]Where can I get the source of hstore? Wen Yi 02:54
Re: [Beginner Question]Where can I get the source of hstore? Adrian Klaver 03:05
how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA <tableschema>” privilege or not ? yanliang lei 09:40
lippq client library and openssl initialization: PQinitOpenSSL() Sebastien Flaesch 10:55
Re: lippq client library and openssl initialization: PQinitOpenSSL() Jeffrey Walton 13:58
Re: lippq client library and openssl initialization: PQinitOpenSSL() Tom Lane 15:08
Re: [EXT] Re: log_min_messages = warning Junwang Zhao 15:40
Re: how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA <tableschema>” privilege or not ? David G. Johnston 16:03
Re: lippq client library and openssl initialization: PQinitOpenSSL() Daniel Gustafsson 20:57
Re: lippq client library and openssl initialization: PQinitOpenSSL() Tom Lane 21:35
Re: lippq client library and openssl initialization: PQinitOpenSSL() Daniel Gustafsson 21:43

Sept. 12, 2022

Thread Author Time
Re: lippq client library and openssl initialization: PQinitOpenSSL() Peter Eisentraut 11:21
Re: lippq client library and openssl initialization: PQinitOpenSSL() 📎 Daniel Gustafsson 11:55
Re: Support for dates before 4713 BC Watzinger, Alexander 12:22
Resolving host to IP address Sebastien Flaesch 12:23
unable to install pldebugger shashidhar Reddy 13:19
Re: unable to install pldebugger Pavel Stehule 13:25
Re: unable to install pldebugger Julien Rouhaud 13:31
Re: lippq client library and openssl initialization: PQinitOpenSSL() Tom Lane 13:47
Re: Resolving host to IP address Tom Lane 14:11
Re: Resolving host to IP address Francisco Olarte 14:12
Re: Resolving host to IP address Francisco Olarte 14:17
Re: Support for dates before 4713 BC Simon Riggs 14:40
Re: Resolving host to IP address Sebastien Flaesch 14:40
Re: Support for dates before 4713 BC Tom Lane 15:00
Re: Resolving host to IP address Francisco Olarte 15:30
Re: Support for dates before 4713 BC Simon Riggs 15:41
Re: Support for dates before 4713 BC Tom Lane 15:53
Postgresql acid components Rama Krishnan 16:34
Re: Missing query plan for auto_explain. Matheus Martin 16:34
Re: unable to install pldebugger shashidhar Reddy 16:44
Re: Missing query plan for auto_explain. Julien Rouhaud 16:46
Re: unable to install pldebugger Julien Rouhaud 16:49
Re: pgBackRest on MacOS Stephen Frost 16:53
Re: unable to install pldebugger shashidhar Reddy 18:05
Re: how to check specific user_name have “SELECT ON ALL TABLES IN SCHEMA <tableschema>” privilege or not ? Joe Conway 19:23
Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 22:51
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? David G. Johnston 23:17

Sept. 13, 2022

Thread Author Time
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Christophe Pettus 00:04
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 01:08
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? David G. Johnston 01:38
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 03:44
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Christophe Pettus 03:53
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 04:02
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 04:49
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 05:01
toast useless Marcos Pegoraro 11:45
Re: toast useless Simon Riggs 12:06
Re: toast useless Marcos Pegoraro 12:28
Re: toast useless Simon Riggs 13:18
Re: toast useless Ron 17:13
Aw: Re: toast useless 📎 Karsten Hilbert 17:16
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 18:23
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Christophe Pettus 18:30
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 18:39
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Christophe Pettus 18:47
How to Build NLS Files Mark Hill 19:19
Re: Postgresql acid components Adrian Klaver 19:41
get user info on log Marcos Pegoraro 19:45
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 19:46
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Guillaume Lelarge 19:57
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Jeremy Smith 20:11
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 21:10
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Christophe Pettus 21:26
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? >> CASE CLOSED Bryn Llewellyn 22:11
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 22:22
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 22:35

Sept. 14, 2022

Thread Author Time
Re: Postgresql acid components Rama Krishnan 07:17
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Guillaume Lelarge 07:21
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Karsten Hilbert 08:10
Mysterious performance degradation in exceptional cases Matthias Apitz 08:31
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Karsten Hilbert 11:08
CVE-2022-2625 misha1966 misha1966 14:02
Re: Mysterious performance degradation in exceptional cases Adrian Klaver 14:19
Re: Mysterious performance degradation in exceptional cases Tom Lane 14:23
understand pg_ndistinct type && Why with(autovacuum_enabled=off) some query estimate 100, some is 200. jian he 16:16
Re: CVE-2022-2625 Laurenz Albe 16:58
massive update on gin index Marcos Pegoraro 19:33
Re: massive update on gin index Guyren Howe 19:38
Re: massive update on gin index Rob Sargent 19:46
Re: massive update on gin index Marcos Pegoraro 19:51
Re: massive update on gin index Tom Lane 19:55
Re: massive update on gin index Marcos Pegoraro 20:20

Sept. 15, 2022

Thread Author Time
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Mladen Gogala 01:57
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Mladen Gogala 02:27
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 03:27
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 03:40
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 04:07
Re[2]: CVE-2022-2625 misha1966 misha1966 04:24
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 04:38
Re: Mysterious performance degradation in exceptional cases Matthias Apitz 05:33
Re: Re[2]: CVE-2022-2625 Laurenz Albe 08:22
Re: Resolving host to IP address Sebastien Flaesch 08:42
Re: CVE-2022-2625 Ron 08:54
Re[2]: CVE-2022-2625 misha1966 misha1966 10:23
Re: Support logical replication of DDLs 📎 Ajin Cherian 12:38
Re[2]: CVE-2022-2625 misha1966 misha1966 14:52

Browse Archives

Prev | Next