pgsql-general since 2022-05-23 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

May 23, 2022

Thread Author Time
[No subject] Rama Krishnan 06:03
Re: Sureshsv Kseb 06:20
Re: Support logical replication of DDLs Amit Kapila 11:54
Re: Support logical replication of DDLs Zheng Li 15:40
list tablespaces named in custom format dump Rob Sargent 16:45
Re: list tablespaces named in custom format dump Adrian Klaver 16:50
Re: list tablespaces named in custom format dump Rob Sargent 16:54
Re: list tablespaces named in custom format dump Adrian Klaver 17:00
Re: list tablespaces named in custom format dump Rob Sargent 17:01
Re: list tablespaces named in custom format dump Adrian Klaver 17:07
Re: PLPGSQL - extra column existence in trigger Durumdara 17:14
Re: list tablespaces named in custom format dump Rob Sargent 17:19
psql connect over ssl load balancer [email protected] 17:28
Re: list tablespaces named in custom format dump Tom Lane 17:29
Re: psql connect over ssl load balancer Tom Lane 17:32
Can I start Update row in After Insert trigger function? Durumdara 17:35
Re: psql connect over ssl load balancer [email protected] 17:40
Re: Can I start Update row in After Insert trigger function? Adrian Klaver 17:41
Re: list tablespaces named in custom format dump Rob Sargent 17:48
Re: list tablespaces named in custom format dump Adrian Klaver 17:51
Re: list tablespaces named in custom format dump Rob Sargent 18:04
Re: list tablespaces named in custom format dump Adrian Klaver 18:10
Re: list tablespaces named in custom format dump Tom Lane 18:15
Re: list tablespaces named in custom format dump Rob Sargent 18:31
Re: list tablespaces named in custom format dump Adrian Klaver 18:59
Re: list tablespaces named in custom format dump Rob Sargent 19:26
Re: list tablespaces named in custom format dump Adrian Klaver 19:47
Re: list tablespaces named in custom format dump Rob Sargent 19:52

May 24, 2022

Thread Author Time
How is this possible "publication does not exist" 📎 operations i 02:20
Fwd: How is this possible "publication does not exist" 📎 operations i 02:34
Re: How is this possible "publication does not exist" Amit Kapila 04:13
cast to domain with default collation issue. jian he 05:02
Re: cast to domain with default collation issue. David G. Johnston 05:13
Re: cast to domain with default collation issue. Tom Lane 05:33
Re: Can I start Update row in After Insert trigger function? Durumdara 06:17
Would it be possible to utilize a GIN index to query for distinct values ? Danny Shemesh 09:36
Re: How is this possible "publication does not exist" Amit Kapila 09:38
Re: cast to domain with default collation issue. Tom Lane 14:42
existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 14:44
Re: existing row not found by SELECT ... WHERE CTID = ? Tom Lane 14:47
Re: Can I start Update row in After Insert trigger function? Adrian Klaver 15:27
Re: existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 15:42
Re: existing row not found by SELECT ... WHERE CTID = ? Laurenz Albe 15:50
About psql \dt unable display same name table which have different schema 徐志宇徐 15:59
Re: existing row not found by SELECT ... WHERE CTID = ? Tom Lane 16:11
Re: About psql \dt unable display same name table which have different schema Tom Lane 16:16
Re: About psql \dt unable display same name table which have different schema 徐志宇徐 16:39
Pg14 possible index corruption after reindex concurrently Aleš Zelený 18:16
Re: Pg14 possible index corruption after reindex concurrently Thomas Munro 19:58
Re: Pg14 possible index corruption after reindex concurrently Aleš Zelený 20:10

May 25, 2022

Thread Author Time
Re: How is this possible "publication does not exist" 📎 operations i 04:02
Re: How is this possible "publication does not exist" Amit Kapila 04:09
Re: cast to domain with default collation issue. jian he 05:58
Re: cast to domain with default collation issue. David G. Johnston 06:38
Re: How is this possible "publication does not exist" 📎 operations i 06:42
Re: cast to domain with default collation issue. jian he 07:19
link that explain ICU_LOCALE locale concept about local variant code and keywords. jian he 08:22
PG 13.6 : Data corruption error message not being sent to syslog Abhishek Bhola 08:32
Re: existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 09:21
Re: link that explain ICU_LOCALE locale concept about local variant code and keywords. jian he 10:23
Re: link that explain ICU_LOCALE locale concept about local variant code and keywords. Daniel Verite 10:23
Re: existing row not found by SELECT ... WHERE CTID = ? Laurenz Albe 10:51
Re: existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 12:01
Re: existing row not found by SELECT ... WHERE CTID = ? Christoph Moench-Tegeder 12:27
Extension pg_trgm, permissions and pg_dump order 12:55
Re: existing row not found by SELECT ... WHERE CTID = ? Laurenz Albe 13:22
Re: cast to domain with default collation issue. David G. Johnston 13:32
connect permission based on database name Rob Sargent 14:09
Re: PG 13.6 : Data corruption error message not being sent to syslog Tom Lane 14:11
Re: connect permission based on database name Tom Lane 14:20
Re: connect permission based on database name Rob Sargent 14:27
Connect to specific cluster on command line Carsten Klein 14:30
Re: existing row not found by SELECT ... WHERE CTID = ? Ravi Krishna 14:30
Re: Connect to specific cluster on command line Tom Lane 14:35
Re: existing row not found by SELECT ... WHERE CTID = ? Tom Lane 14:38
Re: connect permission based on database name Rob Sargent 14:38
Re: connect permission based on database name David G. Johnston 14:44
Re: connect permission based on database name Rob Sargent 14:45
Re: Connect to specific cluster on command line Carsten Klein 14:48
Re: Connect to specific cluster on command line Andreas Fröde 14:54
Re: Connect to specific cluster on command line Laurenz Albe 14:57
Re: Connect to specific cluster on command line Tom Lane 14:58
pg_create_logical_replication_slot in DB1 is blocked by a session in DB2 Fred Habash 15:01
Re: Connect to specific cluster on command line David G. Johnston 15:05
Re: Connect to specific cluster on command line Adrian Klaver 15:23
Re: Connect to specific cluster on command line Carsten Klein 15:26
Re: Pg14 possible index corruption after reindex concurrently Aleš Zelený 16:17
Re: Extension pg_trgm, permissions and pg_dump order Tom Lane 17:02
"Join Postgres on Slack" ? Bryn Llewellyn 17:24
Re: "Join Postgres on Slack" ? David G. Johnston 17:33
Automatic PK values not added to new rows Rich Shepard 17:43
Re: Automatic PK values not added to new rows Adrian Klaver 17:45
Re: Automatic PK values not added to new rows David G. Johnston 17:52
Re: "Join Postgres on Slack" ? Bryn Llewellyn 18:08
Re: Automatic PK values not added to new rows Rich Shepard 18:15
Re: Automatic PK values not added to new rows Adrian Klaver 18:16
Re: Automatic PK values not added to new rows Rich Shepard 18:17
Re: Automatic PK values not added to new rows Rich Shepard 18:18
Re: Automatic PK values not added to new rows Adrian Klaver 18:21
Re: Automatic PK values not added to new rows [RESOLVED] Rich Shepard 18:25
Re: Automatic PK values not added to new rows Thomas Kellerer 19:41
Re: PG 13.6 : Data corruption error message not being sent to syslog Abhishek Bhola 22:41
Re: Automatic PK values not added to new rows Rich Shepard 23:09

May 26, 2022

Thread Author Time
Re: Automatic PK values not added to new rows Ron 03:10
Re: Automatic PK values not added to new rows Adrian Klaver 04:19
Re: Support logical replication of DDLs 📎 Ajin Cherian 05:45
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 05:50
Re: Support logical replication of DDLs Masahiko Sawada 08:35
Re: existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 15:12
Re: existing row not found by SELECT ... WHERE CTID = ? David G. Johnston 15:24
Re: existing row not found by SELECT ... WHERE CTID = ? Tom Lane 16:02
Re: Support logical replication of DDLs Zheng Li 22:19

May 27, 2022

Thread Author Time
Re: Support logical replication of DDLs Amit Kapila 02:03
Re: pg_create_logical_replication_slot in DB1 is blocked by a session in DB2 Kyotaro Horiguchi 06:49
RE: Support logical replication of DDLs 📎 [email protected] 09:07
Determine if range list contains specified integer Andrus 10:51
Re: Support logical replication of DDLs Masahiko Sawada 16:15
Re: existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 16:36
Re: Determine if range list contains specified integer Adrian Klaver 16:40
Re: Determine if range list contains specified integer David G. Johnston 17:07
Re: Determine if range list contains specified integer Sándor Daku 17:14
Re: Extension pg_trgm, permissions and pg_dump order Robert Haas 18:46
Re: Extension pg_trgm, permissions and pg_dump order Tom Lane 18:53
autovacuum on primary blocking queries on replica? Don Seiler 19:00
Re: Extension pg_trgm, permissions and pg_dump order Robert Haas 19:29
Re: Extension pg_trgm, permissions and pg_dump order Tom Lane 19:32

May 28, 2022

Thread Author Time
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 04:51
Improve configurability for IO related behavoir 浩辰 何 12:11
JSONB index not in use, but is TOAST the real cause of slow query? Shaheed Haque 17:53
Re: JSONB index not in use, but is TOAST the real cause of slow query? Tom Lane 18:41
Re: JSONB index not in use, but is TOAST the real cause of slow query? Shaheed Haque 19:38
Re: JSONB index not in use, but is TOAST the real cause of slow query? Adrian Klaver 19:58
Re: JSONB index not in use, but is TOAST the real cause of slow query? Tom Lane 19:59
Re: Improve configurability for IO related behavoir Thomas Munro 20:33
Re: JSONB index not in use, but is TOAST the real cause of slow query? Shaheed Haque 20:48

May 29, 2022

Thread Author Time
Re: Extension pg_trgm, permissions and pg_dump order 📎 Nathan Bossart 03:30
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 04:34
Showing alternative query planner plans with explain ? Danny Shemesh 11:49
Re: Showing alternative query planner plans with explain ? Tom Lane 14:44
Re: JSONB index not in use, but is TOAST the real cause of slow query? Tom Lane 14:58
Re: autovacuum on primary blocking queries on replica? Laurenz Albe 15:02
Re: JSONB index not in use, but is TOAST the real cause of slow query? Shaheed Haque 16:03
Function definition regression in 15beta1 when specific parameter name (string) is used Alastair McKinley 16:46
Re: Function definition regression in 15beta1 when specific parameter name (string) is used Adrian Klaver 17:29
Re: Function definition regression in 15beta1 when specific parameter name (string) is used Adrian Klaver 17:30
Re: Function definition regression in 15beta1 when specific parameter name (string) is used Tom Lane 17:43
Re: Function definition regression in 15beta1 when specific parameter name (string) is used Alastair McKinley 19:26
psql 15beta1 does not print notices on the console until transaction completes Alastair McKinley 20:11
Re: psql 15beta1 does not print notices on the console until transaction completes Tom Lane 20:27
Re: psql 15beta1 does not print notices on the console until transaction completes Adrian Klaver 20:47
Is it possible to index "deep" into a JSONB column? Shaheed Haque 20:53
Re: psql 15beta1 does not print notices on the console until transaction completes Alastair McKinley 20:59
Re: psql 15beta1 does not print notices on the console until transaction completes Adrian Klaver 20:59
Re: psql 15beta1 does not print notices on the console until transaction completes Adrian Klaver 21:14
Re: psql 15beta1 does not print notices on the console until transaction completes Tom Lane 22:03

May 30, 2022

Thread Author Time
Re: psql 15beta1 does not print notices on the console until transaction completes Adrian Klaver 00:00
Re: psql 15beta1 does not print notices on the console until transaction completes Rob Sargent 00:02
Re: Is it possible to index "deep" into a JSONB column? Bryn Llewellyn 02:12
Re: Support logical replication of DDLs Masahiko Sawada 06:52
Re: Is it possible to index "deep" into a JSONB column? Shaheed Haque 08:18
Re: psql 15beta1 does not print notices on the console until transaction completes Fabien COELHO 09:05
Re: Is it possible to index "deep" into a JSONB column? Imre Samu 10:30
Re: Is it possible to index "deep" into a JSONB column? Imre Samu 10:50
Appending data locally to a logical replication subscriber andrew cooke 14:13
Re: psql 15beta1 does not print notices on the console until transaction completes 📎 Fabien COELHO 17:53
Re: Is it possible to index "deep" into a JSONB column? Shaheed Haque 18:59
Re: JSONB index not in use, but is TOAST the real cause of slow query? Jeff Janes 19:29
Re: autovacuum on primary blocking queries on replica? Jeff Janes 22:16

May 31, 2022

Thread Author Time
Re: Extension pg_trgm, permissions and pg_dump order Michael Paquier 04:30
Re: existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 06:36
Re: Is it possible to index "deep" into a JSONB column? Shaheed Haque 09:16
Re: Is it possible to index "deep" into a JSONB column? Shaheed Haque 10:31
The use of partial, expressional indices in pg < 14 Danny Shemesh 10:33
Re: psql 15beta1 does not print notices on the console until transaction completes 📎 Fabien COELHO 11:51
pgAdmin 4 v 6.9 Eric Katchan 13:22
Re: The use of partial, expressional indices in pg < 14 Tom Lane 14:29
Build Postgres On AIX Mark Hill 14:53
Re: Build Postgres On AIX Tom Lane 15:19
Re: Extension pg_trgm, permissions and pg_dump order 📎 Nathan Bossart 15:28
Logically replicated table has no visible rows Jeff Ross 17:46
Re: existing row not found by SELECT ... WHERE CTID = ? Matthias Apitz 18:03
unoptimized nested loops Tim Kelly 18:22
Database trigger (one server to another) Muhammad Bilal Jamil 18:59
Re: Database trigger (one server to another) Adrian Klaver 19:20

June 1, 2022

Thread Author Time
Re: Order of rows in statement triggers NEW/OLD tables Thomas Munro 01:50
GIN theory [email protected] 07:07
function currtid2() in SQL and ESQL/C to get the new CTID of a row Matthias Apitz 10:59
Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row Tom Lane 13:46
Extended multivariate statistics are ignored (potentially related to high null fraction, not sure) Danny Shemesh 16:28
Re: Extended multivariate statistics are ignored (potentially related to high null fraction, not sure) Bruce Momjian 20:08
Re: unoptimized nested loops David Rowley 21:10

June 2, 2022

Thread Author Time
Re: unoptimized nested loops Jeff Janes 04:05
Re: unoptimized nested loops Tom Lane 04:32
How to display complicated Chinese character: Biang. jian he 07:15
Re: How is this possible "publication does not exist" Amit Kapila 09:51
Re: unoptimized nested loops Tim Kelly 10:52
Re: How is this possible "publication does not exist" operations i 11:00
Re: How is this possible "publication does not exist" operations i 11:01
Re: How to display complicated Chinese character: Biang. Laurenz Albe 11:03
Re: How is this possible "publication does not exist" operations i 11:12

Browse Archives

Prev | Next