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: Support logical replication of DDLs | Aleksander Alekseev | 10:05 |
| Re: Support logical replication of DDLs | Marcos Pegoraro | 12:00 |
| Full text search - wildcard and a stop word | Allan Jardine | 15:22 |
| Re: Full text search - wildcard and a stop word | Tom Lane | 15:56 |
| AWS vs GCP storage | Torsten Förtsch | 20:27 |
| Re: AWS vs GCP storage | Adrian Klaver | 20:50 |
| Re: AWS vs GCP storage | Nikolay Samokhvalov | 21:38 |
| Thread | Author | Time |
|---|---|---|
| Plan regression from 12 to 13 | Radu Radutiu | 13:44 |
| tsvector string representation and parsing | Johannes Graën | 21:15 |
| Re: tsvector string representation and parsing | Tom Lane | 22:30 |
| Re: tsvector string representation and parsing | Johannes Graën | 23:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs | Zheng Li | 03:10 |
| Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*" | Peter J. Holzer | 07:49 |
| Re: Support logical replication of DDLs | Aleksander Alekseev | 08:56 |
| alter table to multi partitions | Catalin Maftei | 12:48 |
| Re: tsvector string representation and parsing | Tom Lane | 15:46 |
| \set \e and newline | Wim Bertels | 17:16 |
| Thread | Author | Time |
|---|---|---|
| After upgrade pg12 -> pg14 import time increased | Hu Bert | 08:25 |
| Re: \set \e and newline | Laurenz Albe | 09:33 |
| Re: alter table to multi partitions | Laurenz Albe | 09:36 |
| Transactions starting with Cursor with Hold are not closing in database. 📎 | Kumar, Mukesh | 13:06 |
| Thread | Author | Time |
|---|---|---|
| What IR model the PostgreSQL FTS implementation is based on? | Timo Myyrä | 11:14 |
| 20220226-Clarification regarding delay time of PostgeSQL starting up | Techsupport | 14:21 |
| Re: 20220226-Clarification regarding delay time of PostgeSQL starting up | Julien Rouhaud | 14:57 |
| Re: 20220226-Clarification regarding delay time of PostgeSQL starting up | Laurenz Albe | 15:17 |
| RE: 20220226-Clarification regarding delay time of PostgeSQL starting up | Techsupport | 18:34 |
| Re: 20220226-Clarification regarding delay time of PostgeSQL starting up | David G. Johnston | 18:45 |
| Re: 20220226-Clarification regarding delay time of PostgeSQL starting up | Julien Rouhaud | 19:17 |
| Re: 20220226-Clarification regarding delay time of PostgeSQL starting up | Mladen Gogala | 20:58 |
| Re: 20220226-Clarification regarding delay time of PostgeSQL starting up | Mladen Gogala | 21:13 |
| Thread | Author | Time |
|---|---|---|
| PG 14 Create Rule ERROR - RETURNING list has too few entries | Lucas | 02:44 |
| Re: PG 14 Create Rule ERROR - RETURNING list has too few entries | Lucas | 02:57 |
| Re: PG 14 Create Rule ERROR - RETURNING list has too few entries | Tom Lane | 03:06 |
| Re: PG 14 Create Rule ERROR - RETURNING list has too few entries | Lucas | 03:31 |
| Re: \set \e and newline | Wim Bertels | 11:34 |
| Re: \set \e and newline | Laurenz Albe | 17:37 |
| Thread | Author | Time |
|---|---|---|
| Require details that can we set characters length of a password to a User account in PostgreSQL Database. | Sonai muthu raja M | 08:18 |
| Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database. | Laurenz Albe | 11:49 |
| Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database. | Sonai muthu raja M | 12:46 |
| Thread | Author | Time |
|---|---|---|
| How to log to client (port native code to stored procedure)? | Durumdara | 09:14 |
| PostgreSQL Upgrade with Replication managed via repmgr | DAN LU | 12:21 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL Upgrade with Replication managed via repmgr | Ian Lawrence Barwick | 00:28 |
| Power loss test | Levente Birta | 07:29 |
| Postgres Wal Full | pgdba pgdba | 07:46 |
| Re: Postgres Wal Full | Andreas Kretschmer | 08:04 |
| Re: Postgres Wal Full | Kyotaro Horiguchi | 08:22 |
| Ynt: Postgres Wal Full | pgdba pgdba | 08:47 |
| Re: Postgres Wal Full | Bharath Rupireddy | 09:50 |
| Couldn't cast to record[] | Suresh Kumar R | 10:02 |
| Re: Couldn't cast to record[] | Pavel Stehule | 10:16 |
| oid2name: Why table and not relation? | Daniel Westermann (DWE) | 14:26 |
| Interesting fail when migrating Pg from Ubuntu Bionic to Focal | hubert depesz lubaczewski | 15:04 |
| Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal | hubert depesz lubaczewski | 15:11 |
| Re: Couldn't cast to record[] | Tom Lane | 15:48 |
| Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal | hubert depesz lubaczewski | 16:39 |
| Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal | hubert depesz lubaczewski | 16:44 |
| Re: Power loss test | Bruce Momjian | 17:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal | Mladen Gogala | 02:42 |
| Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal | Tom Lane | 02:48 |
| Re: Couldn't cast to record[] | Suresh Kumar R | 07:33 |
| REG:DR DRILL | obi reddy | 11:07 |
| Re: Couldn't cast to record[] | Tom Lane | 15:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal | hubert depesz lubaczewski | 14:04 |
| Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal | Tom Lane | 16:10 |
| FDW to postGIS Database | Susan Hurst | 16:36 |
| Do you know a json_populate_record alternative method to create a ROW with a named field notation? | Stéphane Klein | 18:41 |
| Re: Do you know a json_populate_record alternative method to create a ROW with a named field notation? | Tom Lane | 18:54 |
| Thread | Author | Time |
|---|---|---|
| Postgres migration from 9.2 to 14 | Lucas | 07:03 |
| Thread | Author | Time |
|---|---|---|
| Simple Query Doesn't Even with Data | Scott Macri | 01:40 |
| Could not read certificate file from while upgrading to PostgreSQLClient 12.9 | M Tarkeshwar Rao | 05:33 |
| Re: Simple Query Doesn't Even with Data | Julien Rouhaud | 08:20 |
| Re: Simple Query Doesn't Even with Data | Ken Tanzer | 08:30 |
| primary_conninfo and restore_command ? | Luca Ferrari | 13:51 |
| Re: primary_conninfo and restore_command ? | Julien Rouhaud | 14:04 |
| PQresultMemorySize of ResultSet larger than expected | Dominique Devienne | 14:09 |
| Re: primary_conninfo and restore_command ? | Bharath Rupireddy | 14:27 |
| Re: PQresultMemorySize of ResultSet larger than expected | Tom Lane | 15:00 |
| foreign key on delete cascade order? | George Woodring | 15:44 |
| Re: foreign key on delete cascade order? | Tom Lane | 15:56 |
| [pgpool] invalid read kind | Peter Juhasz | 16:18 |
| Re: foreign key on delete cascade order? | George Woodring | 17:32 |
| Re: foreign key on delete cascade order? | Tom Lane | 17:38 |
| Thread | Author | Time |
|---|---|---|
| Am I in the same transaction block in complex PLPGSQL? | Durumdara | 08:53 |
| Postgres query | Ian Dauncey | 10:02 |
| Re: Postgres query | hubert depesz lubaczewski | 10:57 |
| Re: foreign key on delete cascade order? | George Woodring | 14:48 |
| Re: Am I in the same transaction block in complex PLPGSQL? | Tom Lane | 15:01 |
| Re: Am I in the same transaction block in complex PLPGSQL? | Durumdara | 16:24 |
| COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | Dominique Devienne | 17:56 |
| Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | David G. Johnston | 18:28 |
| Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | Daniel Verite | 18:37 |
| Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | Dominique Devienne | 18:58 |
| Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | Daniel Verite | 19:32 |
| Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | Dominique Devienne | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Re: foreign key on delete cascade order? | Michael Lewis | 03:03 |
| Re: Am I in the same transaction block in complex PLPGSQL? | David G. Johnston | 05:23 |
| Thread | Author | Time |
|---|---|---|
| Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | Francisco Olarte | 08:41 |
| Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines | Francisco Olarte | 08:53 |
| Re: Support logical replication of DDLs | Dilip Kumar | 11:35 |
| delete query using CTE | Roger Bos | 14:44 |
| Re: delete query using CTE | Michael Lewis | 14:50 |
| Re: delete query using CTE | David G. Johnston | 14:52 |
| Re: delete query using CTE | Roger Bos | 16:06 |
| Re: delete query using CTE | benj.dev | 17:05 |
| Thread | Author | Time |
|---|---|---|
| Indexes that would span partitions. | Tim Uckun | 05:13 |
| LISTEN/NOTIFY ultra slow speed | Арсен Арутюнян | 12:53 |
| Restoring using PG_DUMP in PG12 results in | Shukla, Pranjal | 13:39 |
| Re: Restoring using PG_DUMP in PG12 results in | Adrian Klaver | 14:55 |
| Re: LISTEN/NOTIFY ultra slow speed | Tom Lane | 15:29 |
| Re: foreign key on delete cascade order? | George Woodring | 19:59 |
| Thread | Author | Time |
|---|---|---|
| Apparently table locks are the key issue to see red flags | Shaozhong SHI | 20:14 |
| Apparently table locks are the key issue to see red flags | Shaozhong SHI | 20:15 |
| Re: Apparently table locks are the key issue to see red flags | Ron | 20:21 |
| Re: Apparently table locks are the key issue to see red flags | Adrian Klaver | 20:23 |
| How to explicitly lock and unlock tables in pgsql? | Shaozhong SHI | 20:30 |
| How to explicitly lock and unlock tables in pgsql? | Shaozhong SHI | 20:30 |
| Apparently table locks are the key issue to see red flags | Shaozhong SHI | 20:32 |
| Re: How to explicitly lock and unlock tables in pgsql? | Fabrízio de Royes Mello | 20:35 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 21:17 |
| Re: Support logical replication of DDLs | Alvaro Herrera | 22:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs | Japin Li | 00:08 |
| Re: How to explicitly lock and unlock tables in pgsql? | Laurenz Albe | 07:51 |
| Re: PSQL bug? | Pavel Stehule | 10:38 |
| PSQL bug? | Dominique Devienne | 10:38 |
| Re: PSQL bug? | Dominique Devienne | 11:09 |
| Re: PSQL bug? | Josef Šimánek | 11:32 |
| Query on WAL Optimization and Streaming Replication | Shukla, Pranjal | 12:36 |
| High Postgres postmaster CPU when My Background Worker is loaded. | GoLang Developere | 12:58 |
| Re: Query on WAL Optimization and Streaming Replication | Laurenz Albe | 13:19 |
| Re: Apparently table locks are the key issue to see red flags | Jayson Hreczuck | 13:21 |
| Re: Query on WAL Optimization and Streaming Replication | Shukla, Pranjal | 14:05 |