pgsql-general - December 2023

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

Dec. 1, 2023

Thread Author Time
Re: libpq crashing on macOS during connection startup John DeSoi 01:26
Re: libpq crashing on macOS during connection startup Tom Lane 01:53
Feature request for INITCAP() function Jeff Gerbracht 02:08
Query related to pg_dump write to a pipe on a windows client and with compressed format Meera Nair 02:57
Re: Two started cluster on the same data directory and port Matthias Apitz 04:43
Re: Two started cluster on the same data directory and port Adrian Klaver 05:19
Re: Feature request for INITCAP() function Laurenz Albe 07:22
Re: PAF with Pacemaker Jehan-Guillaume de Rorthais 08:07
Re: Two started cluster on the same data directory and port Loles 09:17
Re: Feature request for INITCAP() function Daniel Verite 11:52
Re: libpq crashing on macOS during connection startup John DeSoi 14:13
Re: Query related to pg_dump write to a pipe on a windows client and with compressed format Ron Johnson 15:04
Re: Two started cluster on the same data directory and port Adrian Klaver 16:17
Re: Query related to pg_dump write to a pipe on a windows client and with compressed format Adrian Klaver 16:30
Re: libpq crashing on macOS during connection startup Tom Lane 17:02
Re: libpq crashing on macOS during connection startup John DeSoi 17:24
Help understand why DELETE is so slow Ping Yao 17:47
Re: Help understand why DELETE is so slow Christophe Pettus 17:50
Re: Query related to pg_dump write to a pipe on a windows client and with compressed format Tom Lane 18:19
Re: Understanding partial index selection Owen Nelson 19:08
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 19:28
Re: Emitting JSON to file using COPY TO Nathan Bossart 23:09

Dec. 2, 2023

Thread Author Time
Re: Emitting JSON to file using COPY TO Davin Shearer 03:00
Re: Emitting JSON to file using COPY TO Joe Conway 03:10
Re: Emitting JSON to file using COPY TO Joe Conway 14:31
Re: Emitting JSON to file using COPY TO Tom Lane 15:11
Re: Emitting JSON to file using COPY TO Maciek Sakrejda 18:50
Re: Emitting JSON to file using COPY TO Nathan Bossart 21:53
Re: Emitting JSON to file using COPY TO Joe Conway 22:37
Re: Emitting JSON to file using COPY TO Joe Conway 22:43

Dec. 3, 2023

Thread Author Time
Re: Emitting JSON to file using COPY TO Andrew Dunstan 13:46
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 14:53
Re: Emitting JSON to file using COPY TO Andrew Dunstan 15:10
Re: Emitting JSON to file using COPY TO Davin Shearer 15:31
Re: Emitting JSON to file using COPY TO Joe Conway 15:51
Re: Emitting JSON to file using COPY TO Joe Conway 16:03
Re: Emitting JSON to file using COPY TO Joe Conway 17:11
Re: Emitting JSON to file using COPY TO Joe Conway 19:24
Re: Emitting JSON to file using COPY TO Andrew Dunstan 19:47
Re: Emitting JSON to file using COPY TO Andrew Dunstan 19:52
Re: Emitting JSON to file using COPY TO Joe Conway 20:09
Re: Emitting JSON to file using COPY TO Davin Shearer 22:38

Dec. 4, 2023

Thread Author Time
Re: Emitting JSON to file using COPY TO Joe Conway 01:14
Re: Emitting JSON to file using COPY TO Davin Shearer 01:27
vacuum visibility relevance senor 02:08
Re: vacuum visibility relevance Ron Johnson 02:15
Re: vacuum visibility relevance Laurenz Albe 02:56
Re: vacuum visibility relevance David Rowley 02:57
Re: Emitting JSON to file using COPY TO Andrew Dunstan 12:41
Re: Emitting JSON to file using COPY TO Joe Conway 13:37
Re: Emitting JSON to file using COPY TO Andrew Dunstan 14:25
Re: libpq crashing on macOS during connection startup John DeSoi 15:40
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 15:45
vacuumdb seems not to like option -j when run from crontab 📎 Ron Johnson 16:07
Re: vacuumdb seems not to like option -j when run from crontab Alan Hodgson 16:13
Re: vacuumdb seems not to like option -j when run from crontab kaido vaikla 16:19
Re: vacuumdb seems not to like option -j when run from crontab Ron Johnson 16:22
Re: Emitting JSON to file using COPY TO Davin Shearer 18:37
Re: Emitting JSON to file using COPY TO Andrew Dunstan 20:06
Re: Help understand why DELETE is so slow Merlin Moncure 21:40
Re: Help understand why DELETE is so slow Ping Yao 21:42
Re: Help understand why DELETE is so slow Merlin Moncure 21:51
Re: Emitting JSON to file using COPY TO Davin Shearer 22:55

Dec. 5, 2023

Thread Author Time
Re: Help understand why DELETE is so slow Tom Lane 00:43
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 02:54
Re: Emitting JSON to file using COPY TO Andrew Dunstan 14:56
Re: Emitting JSON to file using COPY TO Joe Conway 16:54
Trainning and Certification roger popa 17:19
Re: Emitting JSON to file using COPY TO Davin Shearer 17:43
Re: vacuumdb seems not to like option -j when run from crontab Joshua Drake 17:56
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 18:51
Re: Emitting JSON to file using COPY TO Davin Shearer 19:50
Re: Emitting JSON to file using COPY TO Andrew Dunstan 20:55
Re: Emitting JSON to file using COPY TO Joe Conway 21:02
Re: Emitting JSON to file using COPY TO Joe Conway 21:09
Re: Emitting JSON to file using COPY TO Andrew Dunstan 21:12
Re: Emitting JSON to file using COPY TO Joe Conway 21:15
Re: Emitting JSON to file using COPY TO Andrew Dunstan 21:20
Re: Emitting JSON to file using COPY TO Joe Conway 21:46
Re: Emitting JSON to file using COPY TO Davin Shearer 23:45

Dec. 6, 2023

Thread Author Time
Delete Account Estevan Rech 10:45
Store PDF files in PostgreDB Priyadharshini Vellaisamy 11:27
Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function Roman Šindelář 12:04
PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res Arne Henrik Segtnan 12:21
Re: Emitting JSON to file using COPY TO Andrew Dunstan 12:36
RE: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function Patrick FICHE 13:44
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 13:49
GIN INdex is not used with && operator for a text array index balasubramanian c r 14:32
Re: Store PDF files in PostgreDB Ron Johnson 14:43
Max effective number of CPUs that Postgresql can handle? Ron Johnson 14:55
Re: GIN INdex is not used with && operator for a text array index Tom Lane 14:58
Re: Trainning and Certification Daniel Gustafsson 15:09
Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function Tom Lane 15:15
Re: Emitting JSON to file using COPY TO Andrew Dunstan 15:32
Re: Emitting JSON to file using COPY TO Tom Lane 15:44
Re: Delete Account Adrian Klaver 16:00
Re: Emitting JSON to file using COPY TO Joe Conway 16:15
Re: Delete Account Estevan Rech 16:16
Re: Emitting JSON to file using COPY TO Joe Conway 16:19
Re: Emitting JSON to file using COPY TO Andrew Dunstan 16:19
Re: PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res Adrian Klaver 16:21
Re: Delete Account Adrian Klaver 16:25
Re: Emitting JSON to file using COPY TO Tom Lane 16:26
Re: Emitting JSON to file using COPY TO Sehrope Sarkuni 16:28
Re: Emitting JSON to file using COPY TO Tom Lane 16:28
Re: Emitting JSON to file using COPY TO Nathan Bossart 16:33
Re: Emitting JSON to file using COPY TO Nathan Bossart 16:44
Disable autocommit inside dbeaver arun chirappurath 17:41
Re: Disable autocommit inside dbeaver Holger Jakobs 18:22
Re: Emitting JSON to file using COPY TO Daniel Verite 18:59
Re: Emitting JSON to file using COPY TO Joe Conway 19:47
Re: Emitting JSON to file using COPY TO Joe Conway 19:48
Re: Emitting JSON to file using COPY TO Tom Lane 20:20
Re: Emitting JSON to file using COPY TO Andrew Dunstan 21:03
Re: Emitting JSON to file using COPY TO Joe Conway 21:28
Re: Emitting JSON to file using COPY TO Sehrope Sarkuni 21:36
Re: Emitting JSON to file using COPY TO Nathan Bossart 21:41
Re: Emitting JSON to file using COPY TO Sehrope Sarkuni 21:42
Re: Max effective number of CPUs that Postgresql can handle? Christoph Moench-Tegeder 21:58
Re: Trainning and Certification Hans Schou 22:04
Re: Trainning and Certification Daniel Gustafsson 22:22
Re: Emitting JSON to file using COPY TO Joe Conway 22:38
Re: Emitting JSON to file using COPY TO David G. Johnston 22:56
Re: Emitting JSON to file using COPY TO Joe Conway 23:09
Re: Trainning and Certification Adrian Klaver 23:24
Re: Trainning and Certification roger popa 23:25
Re: Emitting JSON to file using COPY TO David G. Johnston 23:28
Re: Emitting JSON to file using COPY TO David G. Johnston 23:38
Re: Emitting JSON to file using COPY TO Joe Conway 23:45
Re: Emitting JSON to file using COPY TO Joe Conway 23:48

Dec. 7, 2023

Thread Author Time
Re: Emitting JSON to file using COPY TO David G. Johnston 00:39
Re: Emitting JSON to file using COPY TO Joe Conway 00:57
Re: Emitting JSON to file using COPY TO David G. Johnston 01:09
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 01:10
Re: Emitting JSON to file using COPY TO Joe Conway 01:14
Re: Emitting JSON to file using COPY TO David G. Johnston 01:21
Re: Emitting JSON to file using COPY TO Euler Taveira 02:42
Re: Emitting JSON to file using COPY TO Nathan Bossart 02:56
Fwd: Disable autocommit inside dbeaver arun chirappurath 03:45
Re: Fwd: Disable autocommit inside dbeaver Rob Sargent 03:49
Postgresql : pg_temp & pg_toast_temp Vishwanath Kummera 06:12
Syntax arun chirappurath 08:00
Re: PostgreSQL 12 error unrecognized configuration parameter zbx_tmp.wal_json_res Arne Henrik Segtnan 08:09
Re: Syntax Ron Johnson 11:14
Re: Emitting JSON to file using COPY TO Joe Conway 12:15
Re: Trainning and Certification Daniel Gustafsson 13:04
Re: Emitting JSON to file using COPY TO Andrew Dunstan 13:19
Re: Emitting JSON to file using COPY TO Daniel Verite 13:35
Re: Emitting JSON to file using COPY TO David G. Johnston 13:47
Re: Emitting JSON to file using COPY TO Joe Conway 13:52
Re: Emitting JSON to file using COPY TO Joe Conway 13:56
Re: Postgresql : pg_temp & pg_toast_temp Tom Lane 14:09
Re: Emitting JSON to file using COPY TO David G. Johnston 14:11
Re: Emitting JSON to file using COPY TO Joe Conway 15:07
write a sql block which will commit if both updates are successful else it will have to be rolled back arun chirappurath 19:37
Re: write a sql block which will commit if both updates are successful else it will have to be rolled back David G. Johnston 19:52
Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix Noel Jones 22:38

Dec. 8, 2023

Thread Author Time
Re: Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix Laurenz Albe 04:26
Disable script execution in server level when updating via grids arun chirappurath 06:16
Re: Disable script execution in server level when updating via grids Filip Sedlak 08:07
Re: Emitting JSON to file using COPY TO Dave Cramer 14:01
Re: Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix Noel Jones 15:00
running \copy through perl dbi ? David Gauthier 15:45
Re: running \copy through perl dbi ? David G. Johnston 15:56
Re: running \copy through perl dbi ? Adrian Klaver 16:01
Re: running \copy through perl dbi ? David G. Johnston 16:05
Inserting into foreign table with sequences and default values [email protected] 18:03
Re: running \copy through perl dbi ? Vincent Veyron 18:12
Re: Inserting into foreign table with sequences and default values Tom Lane 18:31
Re: Emitting JSON to file using COPY TO Daniel Verite 19:45
Re: Emitting JSON to file using COPY TO Daniel Verite 20:35
Re: Emitting JSON to file using COPY TO Joe Conway 21:26
Re: Store PDF files in PostgreDB Peter J. Holzer 22:31
Re: Inserting into foreign table with sequences and default values [email protected] 23:44

Dec. 9, 2023

Thread Author Time
Re: Inserting into foreign table with sequences and default values [email protected] 01:17
how can I fix my accent issues? Igniris Valdivia Baez 04:58
Re: how can I fix my accent issues? Laurenz Albe 06:01
Question on overall design veem v 11:13
Re: Emitting JSON to file using COPY TO Hannu Krosing 11:56
Re: how can I fix my accent issues? 📎 Igniris Valdivia Baez 15:41
Re: how can I fix my accent issues? Adrian Klaver 15:50
Re: how can I fix my accent issues? Igniris Valdivia Baez 15:54
Re: Question on overall design Ron Johnson 16:10
Re: how can I fix my accent issues? Adrian Klaver 16:21
Re: Question on overall design veem v 19:13
Re: Question on overall design Ron Johnson 19:58
Re: Question on overall design veem v 20:35
Re: Question on overall design Ron Johnson 20:57

Dec. 10, 2023

Thread Author Time
Assistance Needed: Error during PostgreSQL Configuration Ayush Vatsa 13:16
Re: Question on overall design veem v 13:45
Re: Question on overall design Ron Johnson 16:55
Re: running \copy through perl dbi ? Vincent Veyron 17:39
Re: running \copy through perl dbi ? Vincent Veyron 17:41
Re: [EXT]Re: running \copy through perl dbi ? Johnson, Bruce E - (bjohnson) 18:34
Re: [EXT]Re: running \copy through perl dbi ? Adrian Klaver 20:02

Dec. 11, 2023

Thread Author Time
Re: Question on overall design veem v 08:59
Re: Question on overall design Dominique Devienne 09:41
Re: running \copy through perl dbi ? Chris Travers 10:00
Re: Assistance Needed: Error during PostgreSQL Configuration Ian Lawrence Barwick 11:57
Re: Question on overall design Ron Johnson 14:08

Browse Archives

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