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.
| 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 |
| Thread | Author | Time |
|---|---|---|
| Max sane value for join_collapse_limit? | Andreas Joseph Krogh | 08:19 |
| Re: GIN theory | jian he | 10:38 |
| Re: Support logical replication of DDLs | Amit Kapila | 11:15 |
| Re: Max sane value for join_collapse_limit? | Philip Semanchuk | 15:11 |
| Re: Logically replicated table has no visible rows | Jeff Ross | 17:10 |
| Re: Extension pg_trgm, permissions and pg_dump order | Nathan Bossart | 18:17 |
| Re: psql 15beta1 does not print notices on the console until transaction completes 📎 | Fabien COELHO | 18:25 |
| Why password authentication failed for user "postgres"? | BeginnerC | 22:32 |
| Re: Why password authentication failed for user "postgres"? | Reid Thompson | 22:38 |
| Thread | Author | Time |
|---|---|---|
| '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Bryn Llewellyn | 01:41 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | David G. Johnston | 02:01 |
| Call pstrdup() of palloc.h will change source string, please help! | mengfanjun | 03:07 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Bryn Llewellyn | 04:45 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Tom Lane | 05:37 |
| Window function? | Robert Stanford | 08:18 |
| Re: unoptimized nested loops | Tim Kelly | 11:32 |
| Re: Window function? | Thiemo Kellner | 12:56 |
| Re: Window function? | Robert Stanford | 13:18 |
| Re: Window function? | Tom Lane | 14:50 |
| Re: Why password authentication failed for user "postgres"? | Jeff Janes | 16:00 |
| Re: Window function? | David G. Johnston | 16:25 |
| Re: Call pstrdup() of palloc.h will change source string, please help! | Tom Lane | 17:05 |
| Re: Window function? | John W Higgins | 17:06 |
| Thread | Author | Time |
|---|---|---|
| Logical replication of large objects | Andreas Joseph Krogh | 09:23 |
| Re: Why password authentication failed for user "postgres"? 📎 | Frank Finner | 23:06 |
| Re: Why password authentication failed for user "postgres"? | David G. Johnston | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Extension pg_trgm, permissions and pg_dump order | Noah Misch | 06:30 |
| GSSAPI authentication | Niels Jespersen | 12:05 |
| Re: GSSAPI authentication | Michael van der Kolff | 12:26 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:01 |
| SV: GSSAPI authentication | Niels Jespersen | 13:33 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:41 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:42 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:49 |
| Re: [EXT] Re: Accessing composite type elements | Garfield Lewis | 15:22 |
| Thread | Author | Time |
|---|---|---|
| RE: Support logical replication of DDLs 📎 | [email protected] | 02:59 |
| SV: GSSAPI authentication | Niels Jespersen | 05:43 |
| Re: psql 15beta1 does not print notices on the console until transaction completes | Peter Eisentraut | 12:05 |
| SQL state: 42601. Execption handling. | Ц | 13:11 |
| SQL state: 42601. Execption handling. | Ц | 14:19 |
| Re: SQL state: 42601. Execption handling. | Tom Lane | 14:36 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Merlin Moncure | 15:09 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL state: 42601. Execption handling. | Kyotaro Horiguchi | 01:12 |
| message log merge (streaming replication) | Peter Adlersburg | 07:59 |
| Re: psql 15beta1 does not print notices on the console until transaction completes | Fabien COELHO | 10:16 |
| [No subject] | Jim McNamara | 10:51 |
| Fwd: | Jim McNamara | 11:03 |
| 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 | pgdba pgdba | 16:43 |
| gawk extension linux missing stuff in package manager fedora 36 | Jim McNamara | 17:15 |
| Re: gawk extension linux missing stuff in package manager fedora 36 | Daniel Verite | 18:09 |
| Re: | Ian Lawrence Barwick | 23:13 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: newbie db design question | Rino Mardo | 00:20 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 06:46 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |