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 | vignesh C | 05:07 |
| Is there a way to know write statistics on an individual index | higherone | 06:58 |
| Reading from replication slot fails if publication is dropped and created. | G Chandrasekar | 07:13 |
| Re: Is there a way to know write statistics on an individual index | David Rowley | 10:53 |
| Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... | Kirk Wolak | 14:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs | li jie | 03:27 |
| Re: Support logical replication of DDLs | li jie | 03:31 |
| Inheritance pg_largeobject table | Zhao, Bing | 05:08 |
| Re: Inheritance pg_largeobject table | Ron | 05:27 |
| Re: Is there a way to know write statistics on an individual index | Maciek Sakrejda | 06:05 |
| Re: Inheritance pg_largeobject table | Thomas Boussekey | 06:37 |
| configure a patroni cluster with a follower who never can become leader | Marco Lechner | 10:03 |
| Re: configure a patroni cluster with a follower who never can become leader | Mateusz Henicz | 10:11 |
| Re: Support logical replication of DDLs | Amit Kapila | 10:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Regular expression for lower case to upper case. | Alban Hertroys | 10:41 |
| Re: Regular expression to UPPER() a lower case string | Peter J. Holzer | 13:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs 📎 | Zheng Li | 04:58 |
| Re: Support logical replication of DDLs | Ajin Cherian | 12:20 |
| Re: Support logical replication of DDLs 📎 | Ajin Cherian | 13:13 |
| PITR and instance without any activity | Adrien Nayrat | 16:53 |
| names of the WAL files | Matthias Apitz | 17:16 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 17:40 |
| Re: names of the WAL files | Reid Thompson | 18:22 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs | li jie | 02:37 |
| Re: Is there a way to know write statistics on an individual index | higherone | 08:28 |
| Re: Support logical replication of DDLs 📎 | vignesh C | 09:17 |
| Is there a way to detect that code is inside CREATE EXTENSION? | Michel Pelletier | 18:39 |
| Re: Is there a way to detect that code is inside CREATE EXTENSION? | Tom Lane | 18:49 |
| Re: Is there a way to detect that code is inside CREATE EXTENSION? | Julien Rouhaud | 18:58 |
| Re: Is there a way to detect that code is inside CREATE EXTENSION? | Michel Pelletier | 18:59 |
| Re: print in plpython not appearing in logs | Shaozhong SHI | 21:20 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Test if a database has any privilege granted to public | Bryn Llewellyn | 00:17 |
| postgres_fdw does not push down DISTINCT | Christophe Pettus | 04:29 |
| Re: Test if a database has any privilege granted to public | David G. Johnston | 17:08 |
| Thread | Author | Time |
|---|---|---|
| Autovacuum on sys tables | Inzamam Shafiq | 07:15 |
| tsvector not giving expected results on one host | Dan Langille | 18:53 |
| Re: tsvector not giving expected results on one host | Dan Langille | 19:41 |
| Re: tsvector not giving expected results on one host | Tom Lane | 19:55 |
| Re: tsvector not giving expected results on one host | Dan Langille | 20:14 |
| Re: tsvector not giving expected results on one host | Dan Langille | 20:22 |
| Re: tsvector not giving expected results on one host | Dan Langille | 20:33 |
| Postgres Date Type Value | Michael Arnold | 23:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres Date Type Value | Tom Lane | 00:20 |
| Re: Postgres Date Type Value | David G. Johnston | 00:24 |
| Re: Postgres Date Type Value | Michael Arnold | 01:15 |
| integer square root function proposed | Martin L. Buchanan | 02:39 |
| Re: integer square root function proposed | Rob Sargent | 03:20 |
| Re: integer square root function proposed | Martin L. Buchanan | 03:40 |
| Re: integer square root function proposed | Rob Sargent | 03:56 |
| Re: integer square root function proposed | Tom Lane | 04:20 |
| Re: Autovacuum on sys tables | Thomas Boussekey | 11:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Autovacuum on sys tables | Inzamam Shafiq | 06:12 |
| Re: Autovacuum on sys tables | Thomas Boussekey | 08:31 |
| Re: Support logical replication of DDLs | li jie | 10:02 |
| Re: Support logical replication of DDLs 📎 | Ajin Cherian | 13:19 |
| Re: Support logical replication of DDLs | Alvaro Herrera | 15:29 |
| Selecting across servers | Brad White | 18:14 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 21:25 |
| Thread | Author | Time |
|---|---|---|
| RE: Support logical replication of DDLs | Takamichi Osumi (Fujitsu) | 06:03 |
| Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | Chetan Kosanam | 09:37 |
| Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... | Andres Freund | 11:20 |
| Re: Implementing foreign data wrappers and avoiding n+1 querying | Brad White | 16:32 |
| Thread | Author | Time |
|---|---|---|
| How to write a crosstab which returns empty row results | David Goldsmith | 03:03 |
| Re: How to write a crosstab which returns empty row results | Brad White | 03:24 |
| Re: How to write a crosstab which returns empty row results | David Goldsmith | 07:25 |
| Re: How to write a crosstab which returns empty row results | David G. Johnston | 16:45 |
| Re: How to write a crosstab which returns empty row results | David Goldsmith | 16:56 |
| Re: How to write a crosstab which returns empty row results | David Goldsmith | 16:57 |
| Thread | Author | Time |
|---|---|---|
| best practice to patch a postgresql version? | qihua wu | 09:29 |
| Sample schemas and data that correlate with all examples in PostgreSQL documentation | Minh Van Le | 11:03 |
| Re: best practice to patch a postgresql version? | Ron | 15:54 |
| Thread | Author | Time |
|---|---|---|
| Re: best practice to patch a postgresql version? | qihua wu | 05:33 |
| Re: Support logical replication of DDLs 📎 | vignesh C | 06:13 |
| Re: best practice to patch a postgresql version? | Ron | 06:48 |
| Re: best practice to patch a postgresql version? | Guillaume Lelarge | 07:00 |
| Re: what is the solution like oracle DB's datafile | Eagna | 10:37 |
| Re: Support logical replication of DDLs 📎 | vignesh C | 12:03 |
| Re: what is the solution like oracle DB's datafile | Guillaume Lelarge | 15:43 |
| Re: best practice to patch a postgresql version? | Peter J. Holzer | 22:15 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:32 |
| Thread | Author | Time |
|---|---|---|
| https://wiki.postgresql.org/wiki/Working_with_Git link one link cannot open, another link is unrelated. | jian he | 10:01 |
| Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | Adrian Klaver | 17:45 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:42 |
| Re: Support logical replication of DDLs | Zheng Li | 22:50 |
| Thread | Author | Time |
|---|---|---|
| Updating column default values in code | Brad White | 00:15 |
| Re: Updating column default values in code | David G. Johnston | 00:46 |
| Re: Updating column default values in code | Adrian Klaver | 01:10 |
| Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | rob stone | 02:15 |
| Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | Ron | 02:17 |
| Re: https://wiki.postgresql.org/wiki/Working_with_Git link one link cannot open, another link is unrelated. | Melih Mutlu | 09:51 |
| Fwd: Segmentation fault on RelationGetDescr in my first extension | Дмитрий Цветков | 10:52 |
| Thread | Author | Time |
|---|---|---|
| Purging few months old data and vacuuming in production | Ranjith Paliyath | 06:39 |
| Re: Purging few months old data and vacuuming in production | Inzamam Shafiq | 07:17 |
| Re: Purging few months old data and vacuuming in production | Amitabh Kant | 07:18 |
| Re: Purging few months old data and vacuuming in production | Ron | 14:47 |
| Exact same output - pg_stat_statements | Rushikesh socha | 16:04 |
| Re: Exact same output - pg_stat_statements | Ron | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Inserts create new records in reporting table | Bret Stern | 07:02 |
| Re: Inserts create new records in reporting table | Ron | 08:55 |
| Re: Exact same output - pg_stat_statements | Rushikesh socha | 17:26 |
| REINDEX vs VACUUM | Hao Zhang | 21:04 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Antonis Christodoulou | 20:51 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Adrian Klaver | 21:00 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Antonis Christodoulou | 21:11 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Adrian Klaver | 21:48 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Rob Sargent | 21:50 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Antonis Christodoulou | 06:08 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Tom Lane | 06:19 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Ahmet Demir | 06:29 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Antonis Christodoulou | 06:34 |