pgsql-general before 2024-01-01 00:00

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)

Browse Archives

Prev | Next

Dec. 7, 2023

Thread Author Time
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
Re: Assistance Needed: Error during PostgreSQL Configuration Tom Lane 14:50
Re: Assistance Needed: Error during PostgreSQL Configuration Ayush Vatsa 17:17
Re: how can I fix my accent issues? Igniris Valdivia Baez 18:54
Re: how can I fix my accent issues? Adrian Klaver 19:11

Dec. 12, 2023

Thread Author Time
Re: Question on overall design Chris Travers 03:33
Re: Question on overall design Ron Johnson 04:53
Re: how can I fix my accent issues? Laurenz Albe 09:50
Re: Assistance Needed: Error during PostgreSQL Configuration Ron Johnson 16:38
Re: Assistance Needed: Error during PostgreSQL Configuration Tom Lane 16:40
Re: Assistance Needed: Error during PostgreSQL Configuration Ayush Vatsa 17:55
Re: how can I fix my accent issues? Daniel Verite 19:42
Re: how can I fix my accent issues? 📎 Igniris Valdivia Baez 20:44
Check column result size in functions Marcos Pegoraro 22:13
Re: Check column result size in functions David G. Johnston 22:29
Re: how can I fix my accent issues? Laurenz Albe 22:56
Re: how can I fix my accent issues? Adrian Klaver 23:04
Re: how can I fix my accent issues? Adrian Klaver 23:14

Dec. 13, 2023

Thread Author Time
Re: how can I fix my accent issues? Adrian Klaver 00:00
Re: how can I fix my accent issues? Igniris Valdivia Baez 00:09
Re: how can I fix my accent issues? Adrian Klaver 05:19
How to Straming replication chatch up from archive marco.ptz 12:25
Re: how can I fix my accent issues? Igniris Valdivia Baez 14:42
Re: how can I fix my accent issues? Daniel Verite 16:11
Re: how can I fix my accent issues? Adrian Klaver 17:29
Increased storage size of jsonb in pg15 Sean Flaherty 22:07
Re: Increased storage size of jsonb in pg15 Adrian Klaver 22:21
Re: Increased storage size of jsonb in pg15 Sean Flaherty 23:49
Re: Increased storage size of jsonb in pg15 Adrian Klaver 23:56

Dec. 14, 2023

Thread Author Time
vacuumdb did not analyze all tables?= Ron Johnson 02:38
Re: How to Straming replication chatch up from archive Filip Sedlák 07:53
Re: Increased storage size of jsonb in pg15 Sean Flaherty 14:48
Re: how can I fix my accent issues? Igniris Valdivia Baez 15:19
Re: Increased storage size of jsonb in pg15 Adrian Klaver 16:16
Re: Increased storage size of jsonb in pg15 David G. Johnston 16:46
Re: vacuumdb did not analyze all tables?= Francisco Olarte 17:19
Re: vacuumdb did not analyze all tables?= Ron Johnson 18:10

Dec. 15, 2023

Thread Author Time
Re: vacuumdb did not analyze all tables?= pf 00:46
Re: vacuumdb did not analyze all tables?= David G. Johnston 00:50
Re: vacuumdb did not analyze all tables?= Ron Johnson 01:56
Re: Increased storage size of jsonb in pg15 Sean Flaherty 20:43
Re: Increased storage size of jsonb in pg15 Adrian Klaver 20:56

Dec. 17, 2023

Thread Author Time
Postgresql 15 client arm64 and Qt 5.15 Piergiorgio Valli 22:13
Re: Postgresql 15 client arm64 and Qt 5.15 Tom Lane 22:30

Dec. 18, 2023

Thread Author Time
Re: Postgresql 15 client arm64 and Qt 5.15 Ron Johnson 00:02
Re: Postgresql 15 client arm64 and Qt 5.15 Tom Lane 00:17
Re: Postgresql 15 client arm64 and Qt 5.15 Adrian Klaver 01:04
Re: Postgresql 15 client arm64 and Qt 5.15 Piergiorgio Valli 16:36

Dec. 19, 2023

Thread Author Time
Read write performance check veem v 06:36
Re: Read write performance check Ilya Kosmodemiansky 07:27
psql crash with custom build on RedHat 7 Dominique Devienne 12:39
Re: psql crash with custom build on RedHat 7 Thomas Munro 13:01
Re: psql crash with custom build on RedHat 7 Tom Lane 15:00
Re: psql crash with custom build on RedHat 7 Dominique Devienne 15:41
Re: psql crash with custom build on RedHat 7 Thomas Munro 18:58
Re: Read write performance check veem v 19:14
Re: Read write performance check Rob Sargent 20:35
Re: Read write performance check Peter J. Holzer 21:12

Dec. 20, 2023

Thread Author Time
Re: Read write performance check veem v 04:49
Re: Read write performance check Lok P 05:03
Re: Read write performance check veem v 05:09
Re: pgBackRest for a 50 TB database Abhishek Bhola 05:30
Re: psql crash with custom build on RedHat 7 Dominique Devienne 10:49

Dec. 21, 2023

Thread Author Time
How to generate random bigint Phillip Diffley 06:06
Re: How to generate random bigint Tom Lane 06:20
Re: How to generate random bigint Thomas Munro 06:50
Building Extension on Linux fails with relocation error 📎 Binaek Sarkar 08:28
Re: "invalid contrecord" error on replica Adrien Nayrat 10:36
Help understanding server-side logging (and more...) Dominique Devienne 11:05
Re: Help understanding server-side logging (and more...) Julien Rouhaud 11:55
Re: How to generate random bigint Peter J. Holzer 12:14
Re: Help understanding server-side logging (and more...) Peter J. Holzer 12:25
PostgreSQL 15.5 stops processing user queries Andrey Zhidenkov 12:32
Re: Read write performance check veem v 13:30
Changing a schema's name with function1 calling function2 📎 Wilma Wantren 13:39
Changing a schema's name with function1 calling function2 Wilma Wantren 13:47
Re: PostgreSQL 15.5 stops processing user queries Tom Lane 15:32
Unlogged partitionned tables and hot standbys Phil Florent 16:00
Re: Help understanding server-side logging (and more...) Adrian Klaver 16:13
Re: Changing a schema's name with function1 calling function2 Adrian Klaver 16:30
what do you do after pg_walreset ? Johnathan Tiamoh 23:53

Dec. 22, 2023

Thread Author Time
Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Kouber Saparev 08:55
Re: what do you do after pg_walreset ? Laurenz Albe 12:10
Re: Read write performance check Lok P 13:44
Re: what do you do after pg_walreset ? Johnathan Tiamoh 15:15
Re: Building Extension on Linux fails with relocation error Tom Lane 15:31
Re: Building Extension on Linux fails with relocation error Peter J. Holzer 16:52
Re: Building Extension on Linux fails with relocation error Tom Lane 17:29
Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren 23:09

Dec. 23, 2023

Thread Author Time
Re: Changing a schema's name with function1 calling function2 Adrian Klaver 00:09
Re: How to generate random bigint Phillip Diffley 00:36
Re: How to generate random bigint Junwang Zhao 02:19
Unable to start postgresql-14 Johnathan Tiamoh 06:48
Version 16.x search_path behavior change? Dennis 14:52
Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren 16:12
Re: Changing a schema's name with function1 calling function2 Adrian Klaver 16:31
Re: Unable to start postgresql-14 Adrian Klaver 16:35
Re: Unable to start postgresql-14 Johnathan Tiamoh 18:05
Re: Unable to start postgresql-14 Adrian Klaver 22:35

Dec. 24, 2023

Thread Author Time
Re: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Michael Paquier 01:36
Re: Version 16.x search_path behavior change? Tom Lane 15:43
Re: Unable to start postgresql-14 Johnathan Tiamoh 16:03
Re: Unable to start postgresql-14 Adrian Klaver 16:27
Re: Unable to start postgresql-14 Ron Johnson 16:28
Re: Changing a schema's name with function1 calling function2 Peter J. Holzer 21:43
Re: Changing a schema's name with function1 calling function2 Adrian Klaver 22:27

Dec. 25, 2023

Thread Author Time
Re: Changing a schema's name with function1 calling function2 Peter J. Holzer 14:37
Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren 17:29
Re: Changing a schema's name with function1 calling function2 Adrian Klaver 18:44
Re: Changing a schema's name with function1 calling function2 Christophe Pettus 18:46
Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer 21:01
Re: Query crash with 15.5 on debian bookworm/armv8 Adrian Klaver 21:06
Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer 21:51
Re: Query crash with 15.5 on debian bookworm/armv8 Adrian Klaver 21:59
Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer 22:07
Re: Query crash with 15.5 on debian bookworm/armv8 Adrian Klaver 22:33
Re: Query crash with 15.5 on debian bookworm/armv8 Tom Lane 22:53

Dec. 26, 2023

Thread Author Time
Logical replication stall on box type with REPLICA IDENTITY FULL due to lack of exact equality Laurence Parry 14:15
Intermittent Issue with WAL Segment Removal in Logical Replication Kaushik Iska 15:36
Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer 16:16
ERROR: missing chunk number 0 for toast value 1563962066 in pg_toast_2619 Johnathan Tiamoh 20:51
Re: ERROR: missing chunk number 0 for toast value 1563962066 in pg_toast_2619 Adrian Klaver 20:58
Re: PostgreSQL 15.5 stops processing user queries Andrey Zhidenkov 21:05
Re: Query crash with 15.5 on debian bookworm/armv8 Thomas Munro 22:15

Dec. 27, 2023

Thread Author Time
looking for mariadb-devel to install mysql_fdw_16 in AlmaLinux 9 Michael Nolan 02:02
Re: looking for mariadb-devel to install mysql_fdw_16 in AlmaLinux 9 Adrian Klaver 05:28
Re: Changing a schema's name with function1 calling function2 Kirk Wolak 06:41
Re: Read write performance check Kirk Wolak 07:29
Re: Intermittent Issue with WAL Segment Removal in Logical Replication Kaushik Iska 15:31
Re: Changing a schema's name with function1 calling function2 Adrian Klaver 15:40

Dec. 28, 2023

Thread Author Time
Re: Query crash with 15.5 on debian bookworm/armv8 Clemens Eisserer 11:41
Re: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Kouber Saparev 12:03
Re: Increased storage size of jsonb in pg15 📎 Sean Flaherty 17:13
Re: Increased storage size of jsonb in pg15 Adrian Klaver 18:23
Re: Increased storage size of jsonb in pg15 Sean Flaherty 20:41
Re: Increased storage size of jsonb in pg15 Adrian Klaver 20:47
Re: Intermittent Issue with WAL Segment Removal in Logical Replication Ron Johnson 22:24

Dec. 29, 2023

Thread Author Time
Re: Increased storage size of jsonb in pg15 Junwang Zhao 10:05
Need help ankit.singh 14:02
Re: Increased storage size of jsonb in pg15 Tom Lane 14:22
Re: Increased storage size of jsonb in pg15 Sean Flaherty 15:21
Re: Increased storage size of jsonb in pg15 Adrian Klaver 16:43
Re: Increased storage size of jsonb in pg15 Sean Flaherty 17:23
Re: Need help Adrian Klaver 19:15
Re: Need help Tom Lane 19:24
Re: Intermittent Issue with WAL Segment Removal in Logical Replication Tomas Vondra 21:16
Re: Intermittent Issue with WAL Segment Removal in Logical Replication Kaushik Iska 21:28

Dec. 30, 2023

Thread Author Time
Re: Intermittent Issue with WAL Segment Removal in Logical Replication Tomas Vondra 00:26
Re: Need help Adrian Klaver 05:36
Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren 16:01
Re: Need help Adrian Klaver 16:29
Re: Changing a schema's name with function1 calling function2 Adrian Klaver 18:05

Dec. 31, 2023

Thread Author Time
Re: Re: Changing a schema's name with function1 calling function2 Wilma Wantren 13:00

Browse Archives

Prev | Next