pgsql-general - April 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

April 1, 2021

Thread Author Time
How to implement expiration in PostgreSQL? Glen Huang 01:51
Re: How to implement expiration in PostgreSQL? Tim Clarke 07:58
Re: accessing cross-schema materialized views Tim Clarke 08:05
Re: How to implement expiration in PostgreSQL? Glen Huang 13:28
Re: How to implement expiration in PostgreSQL? Tim Clarke 13:43
Re: How to implement expiration in PostgreSQL? Glen Huang 13:47
Re: How to implement expiration in PostgreSQL? Tim Clarke 14:15
Re: How to implement expiration in PostgreSQL? Glen Huang 14:23
Re: How to implement expiration in PostgreSQL? Tim Clarke 14:31
Re: How to implement expiration in PostgreSQL? Glen Huang 14:36
Is replacing transactions with CTE a good idea? Glen Huang 14:49
Re: Is replacing transactions with CTE a good idea? Brian Dunavant 14:58
Re: Is replacing transactions with CTE a good idea? Dave Cramer 15:04
Re: Is replacing transactions with CTE a good idea? Rob Sargent 15:04
Re: Is replacing transactions with CTE a good idea? Glen Huang 15:06
Re: Is replacing transactions with CTE a good idea? Glen Huang 15:09
Re: Is replacing transactions with CTE a good idea? Dave Cramer 15:10
Re: Is replacing transactions with CTE a good idea? Glen Huang 15:20
Re: Is replacing transactions with CTE a good idea? Dave Cramer 15:24
Re: Is replacing transactions with CTE a good idea? Glen Huang 15:26
Re: Is replacing transactions with CTE a good idea? Glen Huang 15:29
storage in mem Marc Millas 15:32
Re: Is replacing transactions with CTE a good idea? Brian Dunavant 15:49
Re: How to implement expiration in PostgreSQL? David G. Johnston 15:56
Slick way to update multiple tables. Theodore M Rolle, Jr. 16:16
Re: Slick way to update multiple tables. Michael Lewis 16:42
Re: Slick way to update multiple tables. Theodore M Rolle, Jr. 17:19
Re: Slick way to update multiple tables. Michael Lewis 17:27
Re: questions about wraparound Jehan-Guillaume de Rorthais 18:03
Re: Slick way to update multiple tables. Michael Lewis 18:54
Re: Slick way to update multiple tables. Paul Jungwirth 19:37
Re: Is replacing transactions with CTE a good idea? Bruce Momjian 19:39
Re: Upgrading from 11 to 13 📎 Bruce Momjian 22:06
Re: Upgrading from 11 to 13 Jonathan S. Katz 23:26
Re: Upgrading from 11 to 13 Koen De Groote 23:28
Re: Upgrading from 11 to 13 Alvaro Herrera 23:32

April 2, 2021

Thread Author Time
Re: Upgrading from 11 to 13 Bruce Momjian 01:18
Re: Upgrading from 11 to 13 Bruce Momjian 01:55
Re: Upgrading from 11 to 13 Bruce Momjian 01:56
Re: Primary keys and composite unique keys(basic question) Merlin Moncure 02:28
Re: Primary keys and composite unique keys(basic question) Rob Sargent 03:26
Have I found an interval arithmetic bug? Bryn Llewellyn 04:46
Re: Primary keys and composite unique keys(basic question) Hemil Ruparel 06:56
Re: Copy Statistics Tables During Upgrade Pierre Forstmann 07:06
Re: Primary keys and composite unique keys(basic question) Bertrand Mamasam 07:35
Re: questions about wraparound Jehan-Guillaume de Rorthais 08:29
Re: Primary keys and composite unique keys(basic question) Laurenz Albe 08:40
pass non-formated query to PL function Joao Miguel Ferreira 09:34
Re: pass non-formated query to PL function Pavel Stehule 09:42
Re: pass non-formated query to PL function Gianni Ceccarelli 09:53
Re: pass non-formated query to PL function Joao Miguel Ferreira 13:45
Re: How to implement expiration in PostgreSQL? Vincent Veyron 15:00
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 18:05
Re: Have I found an interval arithmetic bug? Bruce Momjian 18:06
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 20:05
Re: Have I found an interval arithmetic bug? Ken Tanzer 20:20
Re: Have I found an interval arithmetic bug? Zhihong Yu 20:27
Re: Have I found an interval arithmetic bug? John W Higgins 21:00
How to install PostgreSQL binaries on a different directory than the default one Allie Crawford 22:01
How to deny access to Postgres when connected from host/non-local A. Reichstadt 23:06
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 23:47
Re: Have I found an interval arithmetic bug? Bruce Momjian 23:48
Re: Have I found an interval arithmetic bug? Bruce Momjian 23:49
Re: Have I found an interval arithmetic bug? Bruce Momjian 23:58

April 3, 2021

Thread Author Time
Re: Have I found an interval arithmetic bug? Zhihong Yu 00:07
Re: How to install PostgreSQL binaries on a different directory than the default one rob stone 00:25
Re: Have I found an interval arithmetic bug? Bruce Momjian 00:36
Re: How to install PostgreSQL binaries on a different directory than the default one Benedict Holland 00:46
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 00:50
Re: Have I found an interval arithmetic bug? Bruce Momjian 01:02
Re: Have I found an interval arithmetic bug? Zhihong Yu 01:11
Re: Have I found an interval arithmetic bug? Isaac Morland 01:23
Re: Have I found an interval arithmetic bug? Zhihong Yu 02:06
Fwd: Proposed Italian Translation of Code of Conduct Policy 📎 Stacey Haysler 02:07
Re: Have I found an interval arithmetic bug? Bruce Momjian 02:19
Re: Have I found an interval arithmetic bug? Bruce Momjian 02:21
Re: Have I found an interval arithmetic bug? Zhihong Yu 02:53
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 03:00
ignore tablespace in schema definition queries Joao Miguel Ferreira 10:59
Re: ignore tablespace in schema definition queries Allan Kamau 13:13
Re: questions about wraparound Luca Ferrari 13:22
Re: ignore tablespace in schema definition queries Mark Johnson 13:25
Re: ignore tablespace in schema definition queries Joao Miguel Ferreira 16:22
Re: Upgrading from 11 to 13 Koen De Groote 17:37
Re: How to deny access to Postgres when connected from host/non-local Joe Conway 18:02
Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1 Stephan Knauss 18:47
What is the expected difference in performance between querying a all partitions of a partitioned table and non partitioned one? John Garrison 18:48
Re: Upgrading from 11 to 13 Adrian Klaver 18:50
Re: = t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value Peter J. Holzer 18:53
Re: Upgrading from 11 to 13 Peter J. Holzer 19:19
Re: Upgrading from 11 to 13 Koen De Groote 19:47
Re: Upgrading from 11 to 13 Bruce Momjian 20:05
Re: Upgrading from 11 to 13 Adrian Klaver 20:17

April 4, 2021

Thread Author Time
Re: Is replacing transactions with CTE a good idea? Ron 02:06
Re: Slick way to update multiple tables. Ron 02:10
Re: Is replacing transactions with CTE a good idea? Dave Cramer 12:35
Re: Is replacing transactions with CTE a good idea? Bruce Momjian 13:12
Re: Is replacing transactions with CTE a good idea? Dave Cramer 14:02

April 5, 2021

Thread Author Time
Re: How to deny access to Postgres when connected from host/non-local A. Reichstadt 04:20
Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1 Stephan Knauss 07:23
Re: Have I found an interval arithmetic bug? Justin Pryzby 16:33
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 18:01
Re: Have I found an interval arithmetic bug? Justin Pryzby 18:15
Re: Is replacing transactions with CTE a good idea? Bruce Momjian 18:18
Re: Is replacing transactions with CTE a good idea? Dave Cramer 18:32
Re: Have I found an interval arithmetic bug? Bruce Momjian 18:37
Re: Is replacing transactions with CTE a good idea? Bruce Momjian 18:41
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 20:06
Re: Have I found an interval arithmetic bug? Bruce Momjian 20:35
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 20:58
Re: MultiXactId wraparound and last aggressive vacuum time Michael Schanne 21:28

April 6, 2021

Thread Author Time
Re: Primary keys and composite unique keys(basic question) Merlin Moncure 02:10
Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1 Tom Lane 02:11
Re: Primary keys and composite unique keys(basic question) Merlin Moncure 02:17
Re: Primary keys and composite unique keys(basic question) Rob Sargent 02:37
Re: Primary keys and composite unique keys(basic question) Merlin Moncure 02:53
Upgrade from 11.3 to 13.1 failed with out of memory Mihalidesová Jana 06:15
Re: questions about wraparound Laurenz Albe 08:46
LDAP, single sign on from Windows client chlor 12:17
Re: Upgrade from 11.3 to 13.1 failed with out of memory Magnus Hagander 13:22
RE: Open source licenses DAVID Nicolas 13:47
Re: Open source licenses Laurenz Albe 14:12
Re: questions about wraparound Jehan-Guillaume de Rorthais 15:46
Re: LDAP, single sign on from Windows client Stephen Frost 15:59
Re: MultiXactId wraparound and last aggressive vacuum time Jehan-Guillaume de Rorthais 16:01
Check constraint failure messages Miles Elam 19:40
Re: Check constraint failure messages Ron 20:03
Re: Check constraint failure messages Miles Elam 20:50
Re: Check constraint failure messages Ron 20:58
Re: Check constraint failure messages Miles Elam 21:18

April 7, 2021

Thread Author Time
RE: Open source licenses DAVID Nicolas 06:41
Re: Open source licenses Laurenz Albe 08:50
RE: Upgrade from 11.3 to 13.1 failed with out of memory Mihalidesová Jana 09:24
Using indexes through a plpgsql procedure Ciaran Doherty 11:15
Cascade publication with pg_stat_replication empty PegoraroF10 11:16
Re: Cascade publication with pg_stat_replication empty Laurenz Albe 14:18
Re: Using indexes through a plpgsql procedure Peter J. Holzer 14:36
PostgreSQL log query's result size Hellmuth Vargas 14:53
Re: PostgreSQL log query's result size Peter J. Holzer 15:02
Re: Cascade publication with pg_stat_replication empty PegoraroF10 15:30
Re: Cascade publication with pg_stat_replication empty PegoraroF10 16:09
Re: Primary keys and composite unique keys(basic question) Ron 16:16
Re: Primary keys and composite unique keys(basic question) Rob Sargent 16:35
Re: Primary keys and composite unique keys(basic question) Ron 17:59
Re: Primary keys and composite unique keys(basic question) Rob Sargent 18:16
Re: Primary keys and composite unique keys(basic question) Ron 18:35

April 8, 2021

Thread Author Time
could not receive data from client: Connection reset by peer Jagmohan Kaintura 02:37
Re: could not receive data from client: Connection reset by peer Tom Lane 02:59
Re: Primary keys and composite unique keys(basic question) Peter J. Holzer 11:39
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 17:24
Re: Have I found an interval arithmetic bug? Bryn Llewellyn 18:17
RE: Check constraint failure messages Kevin Brannen 20:32

April 9, 2021

Thread Author Time
Re: Check constraint failure messages Miles Elam 00:20
Re: ERROR : invalid transaction termination : PostgreSQL v12 Siddhartha2485 01:43
"index contains unexpected zero page" problem Yi Sun 01:44
where clauses including timstamptz and intervals Niels Jespersen 07:24
Re: where clauses including timstamptz and intervals hubert depesz lubaczewski 10:24
Who altered the database? Durumdara 11:14
Re: Is replacing transactions with CTE a good idea? Glen Huang 15:05
Re: Is replacing transactions with CTE a good idea? Bruce Momjian 15:17
Re: where clauses including timstamptz and intervals Ron 15:52
Re: Who altered the database? Ron 15:56
Re: where clauses including timstamptz and intervals Tom Lane 16:23
Re: Who altered the database? Ganesh Korde 17:00
Re: where clauses including timstamptz and intervals Francisco Olarte 17:29
SV: where clauses including timstamptz and intervals Niels Jespersen 17:39
issue during installation of postgresql binary zip sadaqat 20:37
Re: Multiple LDAP Servers for ldap Authentication Richard Yen 22:21

April 10, 2021

Thread Author Time
Re: where clauses including timstamptz and intervals Francisco Olarte 07:31
The Amazon CloudFront distribution is configured to block access from your country. felix.quintgz 19:00
Re: The Amazon CloudFront distribution is configured to block access from your country. Ron 23:30

April 11, 2021

Thread Author Time
Re: The Amazon CloudFront distribution is configured to block access from your country. felix.quintgz 00:03
Re: The Amazon CloudFront distribution is configured to block access from your country. Ron 00:06
Re: The Amazon CloudFront distribution is configured to block access from your country. felix.quintgz 00:31
Ways to "serialize" result set for later use? 📎 Adam Brusselback 02:06
Re: The Amazon CloudFront distribution is configured to block access from your country. Stephan Knauss 09:53
Re: The Amazon CloudFront distribution is configured to block access from your country. obi reddy 10:49
Re: The Amazon CloudFront distribution is configured to block access from your country. Israel Brewster 14:12
Re: The Amazon CloudFront distribution is configured to block access from your country. Ron 14:52
Reuse of REF Cursor Abraham, Danny 15:03
Re: Who altered the database? Vincent Veyron 15:03
Re: Reuse of REF Cursor David G. Johnston 15:07
Re: The Amazon CloudFront distribution is configured to block access from your country. Israel Brewster 15:07
Re: The Amazon CloudFront distribution is configured to block access from your country. David G. Johnston 15:10
Re: The Amazon CloudFront distribution is configured to block access from your country. felix.quintgz 15:11
Re: The Amazon CloudFront distribution is configured to block access from your country. Ron 15:16
Re: Reuse of REF Cursor Tom Lane 15:23
Re: The Amazon CloudFront distribution is configured to block access from your country. Adrian Klaver 15:25
Re: The Amazon CloudFront distribution is configured to block access from your country. Adrian Klaver 15:30
Re: The Amazon CloudFront distribution is configured to block access from your country. Adrian Klaver 15:38
RE: Re: Reuse of REF Cursor Abraham, Danny 15:45
Re: Reuse of REF Cursor Tom Lane 17:50
RE: Re: Reuse of REF Cursor Abraham, Danny 18:02
Re: Reuse of REF Cursor Tom Lane 18:09
Re: Have I found an interval arithmetic bug? Zhihong Yu 19:57
How can I insert the image as a blob in the table Igor Korot 21:03
RE: Re: Reuse of REF Cursor Abraham, Danny 23:11
Prepare Statement VS Literal Values Virendra Kumar 23:14
Re: How can I insert the image as a blob in the table David G. Johnston 23:24
Re: Have I found an interval arithmetic bug? Zhihong Yu 23:33

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