pgsql-general since 2022-06-14 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 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 [email protected] 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 [email protected] 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 📎 [email protected] 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 [email protected] 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 [email protected] A Z 10:37
Re: Question about attention to [email protected] Laurenz Albe 11:22
Re: Question about attention to [email protected] Julien Rouhaud 13:15
Re: Question about attention to [email protected] 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
Sv: How can I set up Postgres to use given amount of RAM? Andreas Joseph Krogh 06:50
Re: Differences in Escaped bytea's when creating a plain pg_dump WR 07:21
Re: Differences in Escaped bytea's when creating a plain pg_dump David G. Johnston 07:32
Table space not returned to the OS ? Florents Tselai 09:30
Re: Differences in Escaped bytea's when creating a plain pg_dump Wolfgang Rißler 09:31
Re: Table space not returned to the OS ? Magnus Hagander 09:38
Re: Table space not returned to the OS ? Thomas Boussekey 09:38
help for pg_wal issue Özge Özyavuz 09:50
Re: Table space not returned to the OS ? Florents Tselai 09:53
Re: Table space not returned to the OS ? Laurenz Albe 10:01
Re: Differences in Escaped bytea's when creating a plain pg_dump Daniel Verite 10:12
Re: help for pg_wal issue Laurenz Albe 10:28
Re: Question about attention to [email protected] Imre Samu 10:41
Re: Differences in Escaped bytea's when creating a plain pg_dump Wolfgang Rißler 11:00
Different sort result between PostgreSQL 8.4 and 12.5 gzh 11:30
Re: Different sort result between PostgreSQL 8.4 and 12.5 Magnus Hagander 11:33
Unique index prohibits partial aggregates Bos, Fred 11:49
Re: Table space not returned to the OS ? Magnus Hagander 14:33
Libpq question related to allocated resources Karl Denninger 16:35
Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") Bryn Llewellyn 19:36
Re: Unique index prohibits partial aggregates David Rowley 21:50

June 28, 2022

Thread Author Time
Re: Libpq question related to allocated resources Tom Lane 03:22
Re: Support logical replication of DDLs Amit Kapila 03:26
Re:Re: Different sort result between PostgreSQL 8.4 and 12.5 gzh 04:00
Re: help for pg_wal issue Kyotaro Horiguchi 07:28
Re: help for pg_wal issue Kyotaro Horiguchi 07:31
GIN index operator ?(jsonb,text) not working? jian he 08:55
Re: Support logical replication of DDLs Amit Kapila 12:13
Re: Libpq question related to allocated resources Karl Denninger 12:16
RE: Unique index prohibits partial aggregates Bos, Fred 12:45
Re: Support logical replication of DDLs vignesh C 16:47
Re: Unique index prohibits partial aggregates David Rowley 18:24

June 29, 2022

Thread Author Time
User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 01:41
Re: User's responsibility when using a chain of "immutable" functions? Christophe Pettus 02:02
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 02:22
Re: Support logical replication of DDLs Amit Kapila 03:06
Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 04:28
Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule 04:34
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 05:02
Re: User's responsibility when using a chain of "immutable" functions? Tom Lane 05:46
Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule 06:19
Re: User's responsibility when using a chain of "immutable" functions? Tom Lane 06:29
Re: User's responsibility when using a chain of "immutable" functions? Laurenz Albe 06:42
Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule 07:19
RE: Support logical replication of DDLs [email protected] 09:47
RE: Support logical replication of DDLs 📎 [email protected] 09:54
Re: Support logical replication of DDLs Amit Kapila 10:48
Re: User's responsibility when using a chain of "immutable" functions? Christophe Pettus 13:41
RE: help for pg_wal issue Özge Özyavuz 13:43
Question on pg_auto_failover extension DAN LU 14:14
Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 19:36
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 19:57

June 30, 2022

Thread Author Time
Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 00:03
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 00:51

Browse Archives

Prev | Next