pgsql-general - November 2021

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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Nov. 1, 2021

Thread Author Time
Re: Question: Is it possible to get the new xlog position after query execution? Oleg Serov 04:36
Re: Settings for a new machine - some guidance sought. Laurenz Albe 04:42
Naked EXISTS vs SELECT EXISTS very different performance. 📎 Jimmy A 06:10
Lazier alternative to row_to_json ? Florents Tselai 11:18
Re: Lazier alternative to row_to_json ? Tom Lane 14:05
Re: ZFS filesystem - supported ? Stephen Frost 17:00
Re: ZFS filesystem - supported ? Ron 17:10
Re: ZFS filesystem - supported ? Lucas 21:41
Re: ZFS filesystem - supported ? Stephen Frost 21:58
Re: ZFS filesystem - supported ? Lucas 23:07

Nov. 2, 2021

Thread Author Time
develop a extension with cpp? huangning290@yahoo.com 01:31
Re: ZFS filesystem - supported ? Mladen Gogala 02:43
Re: develop a extension with cpp? Ilya Anfimov 22:11
Re: develop a extension with cpp? Dmitry Igrishin 22:20

Nov. 3, 2021

Thread Author Time
Re: develop a extension with cpp? huangning290@yahoo.com 01:28
Doubt in pgbouncer Rama Krishnan 13:48
Re: Doubt in pgbouncer Ninad Shah 15:16
to_date() and to_timestamp() with negative years Bryn Llewellyn 17:40
Re: to_date() and to_timestamp() with negative years Tom Lane 17:54
Re: to_date() and to_timestamp() with negative years Bryn Llewellyn 18:18
Re: Selectivity and row count estimates for JSONB columns Tom Lane 19:24
Re: to_date() and to_timestamp() with negative years Adrian Klaver 19:37
Regex for (A) and (B) to find in Bus Stop (A) or (B) Shaozhong SHI 19:44
Regex for (A) and (B) to find in Bus Stop (A) or (B) Shaozhong SHI 19:45
Re: Regex for (A) and (B) to find in Bus Stop (A) or (B) David G. Johnston 19:55
Re: Regex for (A) and (B) to find in Bus Stop (A) or (B) David G. Johnston 20:01
Re: to_date() and to_timestamp() with negative years Bryn Llewellyn 20:39
Error with Insert from View with ON Conflict Alex Magnum 21:05
Re: Error with Insert from View with ON Conflict Steve Baldwin 21:18
Re: to_date() and to_timestamp() with negative years Adrian Klaver 22:14
Re: to_date() and to_timestamp() with negative years Tom Lane 22:23
Re: to_date() and to_timestamp() with negative years Bryn Llewellyn 22:56

Nov. 4, 2021

Thread Author Time
Re: to_date() and to_timestamp() with negative years Adrian Klaver 00:00
Re: to_date() and to_timestamp() with negative years Adrian Klaver 00:07
Re: Error with Insert from View with ON Conflict Peter Geoghegan 00:54
Re: to_date() and to_timestamp() with negative years Bryn Llewellyn 02:12
Re: to_date() and to_timestamp() with negative years Adrian Klaver 04:42
Re: Error with Insert from View with ON Conflict Alex Magnum 11:42
Streaming replication versus Logical replication Alanoly Andrews 15:41
Re: to_date() and to_timestamp() with negative years Bryn Llewellyn 17:29
Re: Streaming replication versus Logical replication Ninad Shah 18:19
Re: ZFS filesystem - supported ? Benedict Holland 18:36
RE: Streaming replication versus Logical replication Alanoly Andrews 19:16
Re: Streaming replication versus Logical replication Christophe Pettus 20:55
Re: to_date() and to_timestamp() with negative years Adrian Klaver 22:30

Nov. 5, 2021

Thread Author Time
An self-contained example "expanded" C data type Michel Pelletier 03:46
Re: An self-contained example "expanded" C data type Pavel Stehule 05:42
Debugging features needed Boboc Cristi 11:28
Re: Debugging features needed Vijaykumar Jain 11:41
Re: Debugging features needed Boboc Cristi 11:49
Re: Debugging features needed Tom Lane 13:51
Re: Debugging features needed Michael Lewis 14:16
Re: Debugging features needed Vijaykumar Jain 16:15
Re: Debugging features needed Boboc Cristi 17:06
Re: Debugging features needed Boboc Cristi 17:07

Nov. 6, 2021

Thread Author Time
Re: Determining if a table really changed in a trigger Mitar 07:13
Re: Question: Is it possible to get the new xlog position after query execution? Peter J. Holzer 11:51
Re: Determining if a table really changed in a trigger Tom Lane 13:43
Re: Determining if a table really changed in a trigger Mitar 20:04

Nov. 7, 2021

Thread Author Time
Design database schemas around a common subset of objects Erik Wienhold 00:02
Re: Design database schemas around a common subset of objects Adrian Klaver 17:38

Nov. 8, 2021

Thread Author Time
Re: Design database schemas around a common subset of objects Erik Wienhold 00:14
Re: Design database schemas around a common subset of objects Rich Shepard 01:10
Re: Question: Is it possible to get the new xlog position after query execution? Oleg Serov 03:42
Re: Design database schemas around a common subset of objects Rob Sargent 05:53
Re: Mongo FDW For Postgres Dhivya E 11:41
Re: Mongo FDW For Postgres Laurenz Albe 16:24
Re: Design database schemas around a common subset of objects Adrian Klaver 16:25
Re: Question: Is it possible to get the new xlog position after query execution? Christophe Pettus 17:11
Re: Question: Is it possible to get the new xlog position after query execution? Oleg Serov 18:03
libpq: How to cancel a COPY ... TO statement? Daniel Frey 18:59
Re: libpq: How to cancel a COPY ... TO statement? Tom Lane 19:05
Re: Question: Is it possible to get the new xlog position after query execution? Christophe Pettus 19:13
Logical Replication - Type messages? Stefen Hillman 19:16
Re: Question: Is it possible to get the new xlog position after query execution? Oleg Serov 19:47
Re: Question: Is it possible to get the new xlog position after query execution? Christophe Pettus 20:03

Nov. 9, 2021

Thread Author Time
Zero Downtime Upgrade Akheel Ahmed 00:51
Re: Zero Downtime Upgrade Brent Wood 01:18
Query Timeout not working using jpa Shubham Mittal 14:31
Logical Replication - Should Destination Table Columns Be Defined With Default Value Avi Weinberg 14:50
Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value David G. Johnston 15:54
RE: Logical Replication - Should Destination Table Columns Be Defined With Default Value Avi Weinberg 16:02
Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value Tom Lane 16:06
Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value Mark Dilger 16:07
Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value Michael Lewis 21:24
Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value Mark Dilger 21:43

Nov. 10, 2021

Thread Author Time
Understanding the differences between Temporal tables, CDC and Time Series. SQL Padawan 06:43
E.1.2. Migration to Version 14 Дмитрий Иванов 07:30
Re: Understanding the differences between Temporal tables, CDC and Time Series. Peter Eisentraut 07:53
Re: Understanding the differences between Temporal tables, CDC and Time Series. SQL Padawan 11:15
Re: E.1.2. Migration to Version 14 Bruce Momjian 16:11
Re: Logical Replication - Type messages? Tom Lane 16:48
Re: E.1.2. Migration to Version 14 Дмитрий Иванов 19:00
Pause streaming replication Rita 21:25

Nov. 11, 2021

Thread Author Time
Re: Pause streaming replication Ben Chobot 00:24
Re: Pause streaming replication Rita 01:36
Re: Pause streaming replication Ben Chobot 01:51
Re: Pause streaming replication Michael Paquier 02:41
Re: Pause streaming replication Laurenz Albe 07:21
Why in pgAdmin an active session is marked/highlighted in Red Shaozhong SHI 13:24
Re:Why in pgAdmin an active session is marked/highlighted in Red chris 14:05
Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? Jean Baro 14:20
Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer? Jean Baro 14:23
Re: Why in pgAdmin an active session is marked/highlighted in Red Laurenz Albe 16:06
Are all unlogged tables in any case truncated after a server-crash? sch8el 18:39
Re: Are all unlogged tables in any case truncated after a server-crash? David G. Johnston 21:10

Nov. 12, 2021

Thread Author Time
Pg_hba.conf problem after unexpected IP change Yessica Brinkmann 01:14
Re: Pg_hba.conf problem after unexpected IP change Adrian Klaver 01:41
I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database 📎 孤傲小二～阿沐 03:41
Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database David G. Johnston 04:23
回复： I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database 孤傲小二～阿沐 04:32
Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database David G. Johnston 05:10
回复： I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database 孤傲小二～阿沐 05:16
Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database Tom Lane 05:42
回复： I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database 孤傲小二～阿沐 05:51
Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database David G. Johnston 06:09
回复： I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database 孤傲小二～阿沐 06:12
sqrt_bigint_v2 📎 孤傲小二～阿沐 06:36
sqrt_bigint_v2 📎 孤傲小二～阿沐 06:37
Re: Are all unlogged tables in any case truncated after a server-crash? Laurenz Albe 07:41
Re: Are all unlogged tables in any case truncated after a server-crash? sch8el 10:53
Re: Pg_hba.conf problem after unexpected IP change Yessica Brinkmann 11:12
Re: Are all unlogged tables in any case truncated after a server-crash? sch8el 12:03
Re: Pg_hba.conf problem after unexpected IP change Dave Cramer 12:22
Re: Are all unlogged tables in any case truncated after a server-using Michael Lewis 14:00
Replace anonymized data in string Patrick FICHE 14:12
Re: Replace anonymized data in string Daniel Gustafsson 14:15
Re: Replace anonymized data in string Rob Sargent 15:07
RE: Replace anonymized data in string Patrick FICHE 15:21
Re: Are all unlogged tables in any case truncated after a server-crash? Michael Lewis 17:31
Re: Pg_hba.conf problem after unexpected IP change Yessica Brinkmann 18:34
Re: Pg_hba.conf problem after unexpected IP change Adrian Klaver 18:37
How to Implement DR for a Production PostgreSQL v12.8 database cluster with repmgr & PgBouncer? Hilbert, Karin 23:55

Nov. 13, 2021

Thread Author Time
help with a query yarden tamam 09:13

Nov. 14, 2021

Thread Author Time
pg_restore depending on user functions Дмитрий Иванов 10:10
Logical Replication - Source and Destination Table Name Not The Same Avi Weinberg 14:14
Re: pg_restore depending on user functions Tom Lane 17:31
Re: pg_restore depending on user functions Дмитрий Иванов 18:37
Re: pg_restore depending on user functions Tom Lane 18:46
Re: Pg_hba.conf problem after unexpected IP change Yessica Brinkmann 19:46
Re: Pg_hba.conf problem after unexpected IP change Ray O'Donnell 19:55
Re: Pg_hba.conf problem after unexpected IP change Adrian Klaver 20:16
Re: Pg_hba.conf problem after unexpected IP change Ray O'Donnell 20:17
Re: pg_restore depending on user functions Дмитрий Иванов 22:49
Re: pg_restore depending on user functions Дмитрий Иванов 23:52

Nov. 15, 2021

Thread Author Time
Re: pg_restore depending on user functions Tom Lane 00:06
PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response) 📎 Chen, Yan-Jack (NSB - CN/Hangzhou) 02:21
Managing major PostgreSQL upgrades Tiffany Thang 11:45
Re: help with a query Bruce Momjian 14:30
Re: help with a query Bruce Momjian 14:31
Re: PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response) Tom Lane 15:09
Re: help with a query Francisco Olarte 15:23
Re: pg_restore depending on user functions Дмитрий Иванов 15:46
Re: pg_restore depending on user functions Tom Lane 15:49
Re: pg_restore depending on user functions Дмитрий Иванов 16:03
Re: pg_restore depending on user functions Дмитрий Иванов 16:36
Re: pg_restore depending on user functions Дмитрий Иванов 21:24
Re: pg_restore depending on user functions Tom Lane 22:07

Nov. 16, 2021

Thread Author Time
Re: Managing major PostgreSQL upgrades Saul Perdomo 01:48
RE: PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response) Chen, Yan-Jack (NSB - CN/Hangzhou) 05:14
historical log of data records Sanjay Minni 08:26
reading this group other than thru mails Sanjay Minni 08:36
Re: historical log of data records Laurenz Albe 09:20
Re: historical log of data records Sanjay Minni 09:54
Re: historical log of data records Alban Hertroys 10:27
Re: historical log of data records Sanjay Minni 11:11
Re: reading this group other than thru mails Jan Wieck 11:39
Multiple multi-column gist indexes that shares one geometry field 王景隆 11:46
Re: historical log of data records Peter J. Holzer 13:31
Re: pg_restore depending on user functions Дмитрий Иванов 13:56
Re: historical log of data records Laurenz Albe 15:42
How is JSON stored in PG ? David Gauthier 15:54
Performance question about using autosave=always and cleanupSavepoints=true Joel Rabinovitch 16:09
Re: How is JSON stored in PG ? Adrian Klaver 16:26
Re: pg_restore depending on user functions Tom Lane 16:29
Re: Performance question about using autosave=always and cleanupSavepoints=true Dave Cramer 16:41
Re: How is JSON stored in PG ? Ray O'Donnell 16:46
Re: pg_restore depending on user functions Дмитрий Иванов 16:57
Postgres Equivalent of Oracle Package DAVID ROTH 17:23
Re: Postgres Equivalent of Oracle Package Pavel Stehule 17:27
Re: Postgres Equivalent of Oracle Package DAVID ROTH 19:51
Re: pg_restore depending on user functions Tom Lane 20:04
Plans with bad estimates/paths Joe Wildish 20:22
Re: Plans with bad estimates/paths Tomas Vondra 22:03

Nov. 17, 2021

Thread Author Time
Re: pg_restore depending on user functions Дмитрий Иванов 01:33
Re: pg_restore depending on user functions Tom Lane 01:47
Row estimate on empty tables Michael Lewis 01:55
Re: pg_restore depending on user functions Дмитрий Иванов 02:06
Account privileges Prathima Mulpuri 02:07
Re: Account privileges David G. Johnston 02:28
Re: Row estimate on empty tables Tom Lane 03:08
Re: Postgres Equivalent of Oracle Package Pavel Stehule 04:13
Re: Managing major PostgreSQL upgrades Tiffany Thang 05:27
Re: Managing major PostgreSQL upgrades Saul Perdomo 05:37
postgresql 9.6x installers for windows are no longer available Ryan Wexler 05:44
create all indexes and triggers in a schema after bulk load Akheel Ahmed 07:13
Re: create all indexes and triggers in a schema after bulk load hubert depesz lubaczewski 07:16
Re: create all indexes and triggers in a schema after bulk load Akheel Ahmed 07:18
Re: Account privileges Joe Conway 14:01
Re: How is JSON stored in PG ? Laurenz Albe 15:54

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30