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 |
|---|---|---|
| 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 📎 | Zheng Li | 00:18 |
| Re: Support logical replication of DDLs | Japin Li | 00:22 |
| Re: Support logical replication of DDLs | Japin Li | 00:25 |
| Re: Support logical replication of DDLs | Japin Li | 00:38 |
| Re: PSQL bug? | Kyotaro Horiguchi | 00:52 |
| Re: Support logical replication of DDLs | Japin Li | 10:19 |
| Re: How to explicitly lock and unlock tables in pgsql? | Merlin Moncure | 16:38 |
| Re: Support logical replication of DDLs | Zheng Li | 17:25 |
| Re: Support logical replication of DDLs | Zheng Li | 17:29 |
| Re: How to explicitly lock and unlock tables in pgsql? | Laurenz Albe | 22:48 |
| Re: Support logical replication of DDLs | Japin Li | 23:33 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause | PALAYRET Jacques | 09:45 |
| Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause | Torsten Förtsch | 10:16 |
| Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause | Guillaume Lelarge | 10:42 |
| PG12: Any drawback of increasing wal_keep_segments | Shukla, Pranjal | 11:32 |
| Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause | David G. Johnston | 12:42 |