pgsql-general since 2022-06-09 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

June 9, 2022

Thread Author Time
Re: FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_wal/0000000x.history": No such file or directory Kyotaro Horiguchi 02:19
Sharing DSA pointer between parallel workers after they've been created Ma, Marcus 03:00
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 05:17
Fwd: message log merge (streaming replication) Peter Adlersburg 05:31
Re: message log merge (streaming replication) Ian Lawrence Barwick 07:26
Re: psql 15beta1 does not print notices on the console until transaction completes Peter Eisentraut 07:38
Re: message log merge (streaming replication) Kyotaro Horiguchi 07:51
Cluster OID Limit Lucas 09:10
RE: Support logical replication of DDLs 📎 houzj.fnst@fujitsu.com 11:43
A function to find errors in groups in a table Shaozhong SHI 13:37
A function to find errors in groups in a table Shaozhong SHI 13:37
Re: Cluster OID Limit Tom Lane 13:49
Re: Cluster OID Limit Adrian Klaver 15:02
Re: Cluster OID Limit SERHAD ERDEM 15:08
Re: Cluster OID Limit Joshua Drake 17:22
Re: Sharing DSA pointer between parallel workers after they've been created Joshua Drake 17:23
Re: Logical replication of large objects Joshua Drake 18:24
Re: Logical replication of large objects Andreas Joseph Krogh 18:58
Re: A function to find errors in groups in a table Steve Midgley 19:16
Re: cast to domain with default collation issue. David G. Johnston 22:44
Re: Row level security insert policy does not validate update new values/content? David G. Johnston 23:09
Re: A function to find errors in groups in a table Shaozhong SHI 23:13
Re: A function to find errors in groups in a table Steve Midgley 23:25

June 10, 2022

Thread Author Time
Re: Support logical replication of DDLs Amit Kapila 06:26
How to drop a subscription inside a stored procedure? Thomas Kellerer 12:57
Re: How to drop a subscription inside a stored procedure? Adrian Klaver 14:58
multiple entries for synchronous_standby_names Nitesh Nathani 16:04
How to get response message Rama Krishnan 16:37
Re: How to get response message Adrian Klaver 16:47
Re: How to get response message Francisco Olarte 18:57
Re: How to get response message David G. Johnston 19:08
Need optimization in query Shubham Mittal 19:18
Re: How to drop a subscription inside a stored procedure? Thomas Kellerer 20:29

June 11, 2022

Thread Author Time
newbie db design question Rino Mardo 07:05
Re: newbie db design question Gavan Schneider 08:36
Re: newbie db design question Ray O'Donnell 08:43
Re: newbie db design question Peter J. Holzer 09:50
PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Markur Sens 19:49
Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Tom Lane 21:06
Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Markur Sens 21:14
Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Tom Lane 21:25

June 12, 2022

Thread Author Time
Re: newbie db design question Rino Mardo 00:20
Re: Support logical replication of DDLs 📎 Zheng Li 06:46

June 13, 2022

Thread Author Time
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 03:45
"A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Bryn Llewellyn 05:43
Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Pavel Stehule 06:07
Re: Need optimization in query Shubham Mittal 08:21
RE: Support logical replication of DDLs houzj.fnst@fujitsu.com 10:08
Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Bryn Llewellyn 19:01
Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Pavel Stehule 19:38
Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Tom Lane 19:38
Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Christophe Pettus 20:07
Tools to convert timestamp data to another time zone in PostgreSQL Joel Rabinovitch 21:52
Re: Tools to convert timestamp data to another time zone in PostgreSQL Adrian Klaver 22:30

June 14, 2022

Thread Author Time
Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Bryn Llewellyn 01:40
Re: multiple entries for synchronous_standby_names Michael Paquier 02:18
RE: Build Postgres On AIX Mark Hill 03:43
Re: Tools to convert timestamp data to another time zone in PostgreSQL Ilya Anfimov 06:53
Postgres NOT IN vs NOT EXISTS optimization Dirschel, Steve 15:58
Re: Postgres NOT IN vs NOT EXISTS optimization Jeremy Smith 16:06
Re: Postgres NOT IN vs NOT EXISTS optimization Tom Lane 16:09
Recent 11.16 release change Daniel Brinzila 19:30
Re: Recent 11.16 release change Tom Lane 21:23
Re: Recent 11.16 release change Daniel Brinzila 21:35
Re: cast to domain with default collation issue. Tom Lane 21:48

June 15, 2022

Thread Author Time
Re: Support logical replication of DDLs Zheng Li 00:14
Re: Support logical replication of DDLs Amit Kapila 04:00
RE: Support logical replication of DDLs houzj.fnst@fujitsu.com 06:45
PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ian Dauncey 07:31
Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ray O'Donnell 08:11
RE: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ian Dauncey 10:58
Automatic autovacuum to prevent wraparound - PG13.5 Mauro Farracha 11:13
Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ray O'Donnell 11:55
Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Tom Lane 13:48
Re: Automatic autovacuum to prevent wraparound - PG13.5 Laurenz Albe 14:27
Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Adrian Klaver 15:21
Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Imre Samu 15:46
Re: Extension pg_trgm, permissions and pg_dump order Nathan Bossart 17:35

June 16, 2022

Thread Author Time
ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn 02:27
Re: ERROR: failed to find conversion function from key_vals_nn to record[] David G. Johnston 03:13
Re: Extension pg_trgm, permissions and pg_dump order 📎 Noah Misch 05:42
Re: ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn 06:07
Re: ERROR: failed to find conversion function from key_vals_nn to record[] David G. Johnston 06:39
[No subject] Rama Krishnan 14:08
Re: Adrian Klaver 14:33
Re: ERROR: failed to find conversion function from key_vals_nn to record[] 📎 Tom Lane 14:54
Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Daniel Popowich 19:59
Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Tom Lane 20:26
Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Bryn Llewellyn 20:40

June 17, 2022

Thread Author Time
Re: Abdul Qoyyuum 02:38
Any way to understand state after data corruption failures during startup. Harinath Kanchu 02:46
Re: ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn 03:28
Re: ERROR: failed to find conversion function from key_vals_nn to record[] David G. Johnston 04:01
Re: Any way to understand state after data corruption failures during startup. Kyotaro Horiguchi 05:03
Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 06:35
Re: ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn 06:58
Re: Postgresql error : PANIC: could not locate a valid checkpoint record Mateusz Henicz 10:00
RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 10:03
Re: Postgresql error : PANIC: could not locate a valid checkpoint record Mateusz Henicz 10:09
Re: Postgresql error : PANIC: could not locate a valid checkpoint record Laurenz Albe 10:39
Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Daniel Popowich 15:26
Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Pavel Stehule 15:39
Re: Support logical replication of DDLs 📎 Zheng Li 19:38

June 18, 2022

Thread Author Time
Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn 00:14
ISBN (was: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?) Peter J. Holzer 06:11
Re: ERROR: failed to find conversion function from key_vals_nn to record[] Peter J. Holzer 06:44
Re: Peter J. Holzer 07:07
Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Alban Hertroys 10:28

June 19, 2022

Thread Author Time
Re: ISBN (was: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?) Bryn Llewellyn 03:33
Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn 04:48
Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? jian he 10:06
Index creation Дмитрий Иванов 19:05
Re: Index creation David G. Johnston 19:08
Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") Bryn Llewellyn 21:31
Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn 22:11
Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Thomas Kellerer 22:30
Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") Tom Lane 23:28

June 20, 2022

Thread Author Time
Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") David G. Johnston 01:10
Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn 02:45
RE: Support logical replication of DDLs houzj.fnst@fujitsu.com 03:31
A error happend when I am clone the git repository Wen Yi 03:33
Re: A error happend when I am clone the git repository Adrian Klaver 04:41
Re: A error happend when I am clone the git repository Tom Lane 04:48
Re: Index creation Дмитрий Иванов 05:17
AIX and EAGAIN on open() Christoph Berg 09:53
RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 10:51
Re: Index creation Jeff Janes 18:23
Re: A error happend when I am clone the git repository Magnus Hagander 20:31

June 21, 2022

Thread Author Time
accessing postgres from c++ Rino Mardo 02:56
Re: Index creation Дмитрий Иванов 03:30
How to use 32 bit ODBC driver Aditya Bhardwaj 05:51
Re: accessing postgres from c++ Laurenz Albe 05:59
Re: accessing postgres from c++ Dominique Devienne 07:07
INSERT ALL with DML ERROR Logging replacement in PostgreSQL Jagmohan Kaintura 07:08
Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Gilles Darold 07:37
Re: accessing postgres from c++ Matthias Apitz 07:57
Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Jagmohan Kaintura 08:28
Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Gilles Darold 08:54
Reminder: Call for Papers for PostgreSQL Conference Europe 2022 is closing soon! Andreas 'ads' Scherbaum 11:57
RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 12:02
RE: Support logical replication of DDLs 📎 houzj.fnst@fujitsu.com 12:19
Re: Postgresql error : PANIC: could not locate a valid checkpoint record Mateusz Henicz 12:29
Re: accessing postgres from c++ Rino Mardo 12:56
Re: How to use 32 bit ODBC driver Rino Mardo 13:27
Re: How to use 32 bit ODBC driver Adrian Klaver 14:51
Re: Extension pg_trgm, permissions and pg_dump order Nathan Bossart 17:56

June 22, 2022

Thread Author Time
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 03:37
Re: Support logical replication of DDLs 📎 Masahiko Sawada 05:38
Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row Matthias Apitz 06:39
Source code test data folder don't have CSV files. How to get the CSV file. jian he 06:40
RE: How to use 32 bit ODBC driver Aditya Bhardwaj 07:30
Re: Support logical replication of DDLs vignesh C 09:07
RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 11:18
RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 11:24
PostgreSQL with Patroni not replicating to all nodes after adding 3rd node (another secondary) Zb B 14:58
Re: Extension pg_trgm, permissions and pg_dump order Nathan Bossart 16:25
ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek 19:17
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Adrian Klaver 19:25
Tuning a query with ORDER BY and LIMIT Dirschel, Steve 19:39
Re: Tuning a query with ORDER BY and LIMIT Michael van der Kolff 20:02
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek 20:18
Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer 21:48
Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer 22:13
Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer 22:19
Re: Support logical replication of DDLs Zheng Li 22:22
Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer 22:25
Re: Tuning a query with ORDER BY and LIMIT Tom Lane 23:22
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tom Lane 23:26

June 23, 2022

Thread Author Time
Re: Tuning a query with ORDER BY and LIMIT Jeff Janes 02:51
Re: Tuning a query with ORDER BY and LIMIT Jeff Janes 03:10
Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row Matthias Apitz 04:57
Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Jagmohan Kaintura 06:25
RE: Support logical replication of DDLs houzj.fnst@fujitsu.com 07:09
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek 07:37
Re: Support logical replication of DDLs Amit Kapila 10:00
Re: Support logical replication of DDLs Alvaro Herrera 12:43
Differences in Escaped bytea's when creating a plain pg_dump WR 15:13
Re: Differences in Escaped bytea's when creating a plain pg_dump WR 16:21
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Adrian Klaver 17:11
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Adrian Klaver 18:21
Re: Differences in Escaped bytea's when creating a plain pg_dump Daniel Verite 21:14

June 24, 2022

Thread Author Time
Re: Support logical replication of DDLs Masahiko Sawada 02:39
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek 08:11
Re: Support logical replication of DDLs Amit Kapila 10:19
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Peter Eisentraut 11:21
RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 13:03
Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tom Lane 14:36
Re: Automatic autovacuum to prevent wraparound - PG13.5 Ninad Shah 16:56
Re: Automatic autovacuum to prevent wraparound - PG13.5 Peter Geoghegan 17:11

June 25, 2022

Thread Author Time
Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer 18:30

June 26, 2022

Thread Author Time
Question about attention to pgsql-hackers@lists.postgresql.org A Z 10:37
Re: Question about attention to pgsql-hackers@lists.postgresql.org Laurenz Albe 11:22
Re: Question about attention to pgsql-hackers@lists.postgresql.org Julien Rouhaud 13:15
Re: Question about attention to pgsql-hackers@lists.postgresql.org Mladen Gogala 16:07
Re: Support logical replication of DDLs Alvaro Herrera 17:50
How can I set up Postgres to use given amount of RAM? W.P. 18:40
Re: How can I set up Postgres to use given amount of RAM? Zahid Rahman 22:49
Re: How can I set up Postgres to use given amount of RAM? Mladen Gogala 23:39

June 27, 2022

Thread Author Time
Re: Postgresql error : PANIC: could not locate a valid checkpoint record Michael Paquier 00:04
Re: Differences in Escaped bytea's when creating a plain pg_dump WR 06:44

Browse Archives

Prev | Next