pgsql-general - July 2024

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 15 16 17 18 19 20 21 22 23 24 25 26 27 30 31

July 1, 2024

Thread Author Time
Re: Passing a dynamic interval to generate_series() Francisco Olarte 07:20
Re: Passing a dynamic interval to generate_series() Shammat 07:37
MVCC: Using function doing INSERT and returning PK in WHERE clause of SELECT statement Dominique Devienne 08:33
Re: MVCC: Using function doing INSERT and returning PK in WHERE clause of SELECT statement Laurenz Albe 12:29

July 2, 2024

Thread Author Time
Question on partman extension while relation exist yudhi s 06:40
Re: Question on partman extension while relation exist Muhammad Ikram 07:13
Re: Question on partman extension while relation exist yudhi s 07:54
printing PGresult content with gdb 📎 clipperDB 16:13
Accommodating alternative column values Rich Shepard 21:47
Re: Accommodating alternative column values Christophe Pettus 21:50
Re: Accommodating alternative column values Rich Shepard 21:57
Re: Accommodating alternative column values Christophe Pettus 21:59
Re: Accommodating alternative column values Rich Shepard 22:11
Re: Accommodating alternative column values Christophe Pettus 22:13

July 3, 2024

Thread Author Time
Logical replication with temporary tables Stuart Campbell 00:47
Re: Logical replication with temporary tables Christophe Pettus 00:49
Re: Logical replication with temporary tables Stuart Campbell 01:16
Re: Logical replication with temporary tables Christophe Pettus 01:19
Re: Logical replication with temporary tables David G. Johnston 01:19
Re: Question on partman extension while relation exist Muhammad Ikram 03:18
Re: printing PGresult content with gdb Reid Thompson 12:02
Re: Accommodating alternative column values Rich Shepard 13:58
Re: Accommodating alternative column values David G. Johnston 14:03
Re: Accommodating alternative column values Rich Shepard 14:03
Re: Accommodating alternative column values Torsten Förtsch 14:04
Re: Accommodating alternative column values David G. Johnston 14:05
Re: Accommodating alternative column values Torsten Förtsch 14:06
Re: Accommodating alternative column values Rich Shepard 14:13
Re: Accommodating alternative column values Torsten Förtsch 14:21
Re: Accommodating alternative column values David G. Johnston 14:23
Re: Accommodating alternative column values Peter J. Holzer 14:32
Re: Accommodating alternative column values Adrian Klaver 14:39
Re: Accommodating alternative column values [RESOLVED] Rich Shepard 15:12
Re: printing PGresult content with gdb Tom Lane 15:55
Query 2 Node HA test case result Mukesh Tanuku 17:58
Description field for tables and views Kent Dorfman 19:28
Re: Description field for tables and views Christophe Pettus 19:30
Re: Description field for tables and views Guyren Howe 19:45
Can't dump new-style sequences independently from their tables. Christophe Pettus 19:55
Re: Description field for tables and views Achilleas Mantzios 19:56
Re: Description field for tables and views Kent Dorfman 20:24
Re: Description field for tables and views Christophe Pettus 20:25

July 4, 2024

Thread Author Time
RE: Configure autovacuum Shenavai, Manuel 15:16
Re: Configure autovacuum Adrian Klaver 15:42
Re: printing PGresult content with gdb 📎 Lana ABADIE 16:11
RE: Configure autovacuum Shenavai, Manuel 17:24
Design strategy for table with many attributes Lok P 19:37
Re: Design strategy for table with many attributes David G. Johnston 19:56
Re: Configure autovacuum Adrian Klaver 20:06
Re: Design strategy for table with many attributes Kent Dorfman 20:35
Re: Design strategy for table with many attributes Ron Johnson 20:50
JSONPath operator and escaping values in query Vasu Nagendra 20:56
Re: Design strategy for table with many attributes Guyren Howe 23:29
psql help Murthy Nunna 23:56

July 5, 2024

Thread Author Time
Re: JSONPath operator and escaping values in query David G. Johnston 01:11
Re: psql help David G. Johnston 01:16
RE: psql help Murthy Nunna 03:54
Re: psql help Adrian Klaver 04:25
Re: Design strategy for table with many attributes Lok P 05:07
Re: psql help David G. Johnston 05:19
Re: Design strategy for table with many attributes David Rowley 05:27
Re: psql help Tom Lane 05:31
Re: Design strategy for table with many attributes David G. Johnston 05:36
Re: Design strategy for table with many attributes Lok P 06:28
Re: Design strategy for table with many attributes Lok P 07:53
Re: Design strategy for table with many attributes David Rowley 08:13
Re: Design strategy for table with many attributes Lok P 08:53
Re: Design strategy for table with many attributes David Rowley 08:58
Load a csv or a avro? sud 09:08
Re: Load a csv or a avro? Kashif Zeeshan 09:57
Re: Load a csv or a avro? Josef Šimánek 10:02
Re: Load a csv or a avro? Muhammad Ikram 10:15
Re: psql help hubert depesz lubaczewski 11:05
RE: psql help Murthy Nunna 12:37
Re: Load a csv or a avro? Ron Johnson 13:03
confused about material view locks please explain Krishnakant Mane 13:28
Removing the default grant of EXECUTE on functions/procedures to PUBLIC Tefft, Michael J 14:45
Re: Removing the default grant of EXECUTE on functions/procedures to PUBLIC David G. Johnston 14:49
Re: Removing the default grant of EXECUTE on functions/procedures to PUBLIC Tom Lane 14:51
Re: Load a csv or a avro? Adrian Klaver 14:54
Planning of sub partitions Matt Hughes 15:24
Re: confused about material view locks please explain Peter J. Holzer 15:40
Re: Planning of sub partitions Matt Hughes 16:06
apt-archive.postgresql.org a bit broken? Tomas Pospisek 16:07
Re: apt-archive.postgresql.org a bit broken? Magnus Hagander 16:27
Re: apt-archive.postgresql.org a bit broken? Tomas Pospisek 17:07
RE: Removing the default grant of EXECUTE on functions/procedures to PUBLIC Tefft, Michael J 17:42
Can a long running procedure detect when smart shutdown is pending? Dennis White 18:12
Re: Removing the default grant of EXECUTE on functions/procedures to PUBLIC Tom Lane 18:22
RE: Removing the default grant of EXECUTE on functions/procedures to PUBLIC Tefft, Michael J 18:42
Re: Removing the default grant of EXECUTE on functions/procedures to PUBLIC Tom Lane 20:19
Re: Can a long running procedure detect when smart shutdown is pending? Achilleas Mantzios 20:57
Re: Planning of sub partitions David Rowley 22:26
Re: Can a long running procedure detect when smart shutdown is pending? Dennis White 23:36

July 6, 2024

Thread Author Time
Re: confused about material view locks please explain Krishnakant Mane 05:39
Re: Can a long running procedure detect when smart shutdown is pending? Pavel Stehule 05:39
Re: Can a long running procedure detect when smart shutdown is pending? Laurenz Albe 05:59
Re: Can a long running procedure detect when smart shutdown is pending? Achilleas Mantzios 06:06
Re: Can a long running procedure detect when smart shutdown is pending? Pavel Stehule 06:19
Re: Can a long running procedure detect when smart shutdown is pending? Pavel Stehule 06:22
Re: Alignment check Tomas Pospisek 06:47
Re: Can a long running procedure detect when smart shutdown is pending? Achilleas Mantzios 08:09
Re: confused about material view locks please explain Peter J. Holzer 11:49
Re: Can a long running procedure detect when smart shutdown is pending? Tom Lane 13:38
Re: Alignment check Michael Nolan 13:50
Re: Can a long running procedure detect when smart shutdown is pending? Dennis White 17:17
Re: Load a csv or a avro? sud 20:02
Re: Load a csv or a avro? sud 20:09
Re: Load a csv or a avro? Ron Johnson 20:23
Declaring a field that is also an out parameter in a function Michael Nolan 21:29
Re: Declaring a field that is also an out parameter in a function Tom Lane 22:13

July 7, 2024

Thread Author Time
Re: Declaring a field that is also an out parameter in a function Pavel Stehule 07:31
Re: Declaring a field that is also an out parameter in a function Pavel Stehule 09:13
Re: Declaring a field that is also an out parameter in a function Michael Nolan 13:01
Re: Declaring a field that is also an out parameter in a function Tom Lane 14:37
Re: Declaring a field that is also an out parameter in a function Pavel Stehule 14:42
Re: Declaring a field that is also an out parameter in a function David G. Johnston 14:47
Re: Declaring a field that is also an out parameter in a function Adrian Klaver 14:48
Re: Declaring a field that is also an out parameter in a function Pavel Stehule 14:53
Re: Declaring a field that is also an out parameter in a function Pavel Stehule 14:58
Re: Declaring a field that is also an out parameter in a function Adrian Klaver 15:00
Re: Declaring a field that is also an out parameter in a function Pavel Stehule 15:02
Re: Load a csv or a avro? Adrian Klaver 15:14

July 8, 2024

Thread Author Time
New Meet-up in the Stuttgart / Tübingen Valeria Kaplan 15:41
Upgrading from v12.7 to v15.7 Yongye Serkfem 18:52
v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Christophe Pettus 19:22
Re: Upgrading from v12.7 to v15.7 Ruben Morais 19:57
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE David G. Johnston 19:58
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Christophe Pettus 20:14
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Laurenz Albe 20:25
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Christophe Pettus 20:29
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Christophe Pettus 20:36
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Tom Lane 20:39
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE David G. Johnston 20:42
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Pavel Luzanov 21:00
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Tom Lane 21:16
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Pavel Luzanov 21:23
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE David G. Johnston 21:59
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Tom Lane 22:08
SQL: Chaining versus Pipelining Joseph Hammerman 22:26
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE David G. Johnston 22:39
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Tom Lane 22:58
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE David G. Johnston 23:24
Re: v16 roles, SET FALSE, INHERIT FALSE, ADMIN FALSE Robert Haas 23:37

July 9, 2024

Thread Author Time
RE: [EXTERNAL] Re: SSPI Feature Request 📎 Buoro, John 03:35
Logical Replication - PG_Wall size is too big, What can I do ? Jaurès FOUTE KUETE 06:05
Re: Logical Replication - PG_Wall size is too big, What can I do ? Laurenz Albe 07:42
Re: SQL: Chaining versus Pipelining Laurenz Albe 07:48
autovacuum_vacuum_cost_delay Shenavai, Manuel 11:38
Re: autovacuum_vacuum_cost_delay Muhammad Ikram 13:42
Re: autovacuum_vacuum_cost_delay Christoph Moench-Tegeder 16:23
Finding error in long input file Rich Shepard 22:14
Re: Finding error in long input file Ray O'Donnell 22:26
Re: Finding error in long input file Adrian Klaver 22:29
Re: Finding error in long input file Rich Shepard 22:33
Re: Finding error in long input file Rich Shepard 22:40
Re: Finding error in long input file Rich Shepard 22:46
Re: Finding error in long input file Adrian Klaver 22:52

July 10, 2024

Thread Author Time
Re: Finding error in long input file Craig McIlwee 00:46
can stored procedures with computational sql queries improve API performance? Krishnakant Mane 00:58
Re: can stored procedures with computational sql queries improve API performance? Guyren Howe 01:14
Re: can stored procedures with computational sql queries improve API performance? Krishnakant Mane 01:21
Re: can stored procedures with computational sql queries improve API performance? Guyren Howe 02:38
Re: Finding error in long input file Adrian Klaver 04:58
Re: Finding error in long input file Alban Hertroys 06:57
Postgres :- Could not open R2DBC Connection vimal va 07:48
Re: Postgres :- Could not open R2DBC Connection Kashif Zeeshan 07:52
Re: Postgres :- Could not open R2DBC Connection Matthias Apitz 07:55
Re: Finding error in long input file Rich Shepard 12:30
Re: Finding error in long input file 📎 Rich Shepard 12:52
Re: Finding error in long input file David G. Johnston 12:59
Re: Finding error in long input file Hans Schou 13:01
Re: Finding error in long input file Hans Schou 13:03
Re: can stored procedures with computational sql queries improve API performance? Rob Sargent 13:13
Re: Finding error in long input file Rich Shepard 13:32
Re: Finding error in long input file Rich Shepard 13:33
Re: [EXTERNAL] Re: SSPI Feature Request Peter J. Holzer 14:10
Re: [EXTERNAL] Re: SSPI Feature Request Ian Harding 14:27
Re: can stored procedures with computational sql queries improve API performance? Peter J. Holzer 14:33
Re: [EXTERNAL] Re: SSPI Feature Request Peter J. Holzer 15:03
Re: Finding error in long input file Adrian Klaver 15:05
Re: Finding error in long input file David G. Johnston 15:11
Re: Finding error in long input file Rich Shepard 15:26
Calendar Table 📎 Anthony Apollis 15:38
Re: Calendar Table David G. Johnston 15:48
Detecting PostgreSQL client library Igor Korot 16:05
Re: Detecting PostgreSQL client library Pavel Stehule 16:10
Re: Detecting PostgreSQL client library Igor Korot 16:25
Re: [EXTERNAL] Re: SSPI Feature Request Ian Harding 16:37
Re: Finding error in long input file Rich Shepard 17:06
Re: can stored procedures with computational sql queries improve API performance? Olivier Gautherot 17:33
Dropping column from big table sud 20:13
Re: can stored procedures with computational sql queries improve API performance? Ron Johnson 20:17
Re: can stored procedures with computational sql queries improve API performance? Juan Rodrigo Alejandro Burgos Mella 20:37
Re: Dropping column from big table Adrian Klaver 21:22

July 11, 2024

Thread Author Time
Query on partitioned table needs memory n_partitions * work_mem Dimitrios Apostolou 01:19
Postgresql range_agg() Return empty list 📎 Han Tang 01:37
Re: Query on partitioned table needs memory n_partitions * work_mem David Rowley 02:17
Re: Dropping column from big table sud 03:28
Re: Postgresql range_agg() Return empty list Paul A Jungwirth 04:46

Browse Archives

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