pgsql-general - January 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)

Browse Archives

Prev | Next

Jan. 1, 2024

Thread Author Time
Re: Read write performance check Hao Zhang 19:07

Jan. 2, 2024

Thread Author Time
Import csv to temp table arun chirappurath 12:02
Testing - Please ignore/delete this message Arbol One 13:12
Re: Import csv to temp table Ron Johnson 13:49
Re: Testing - Please ignore/delete this message Hilary Cotter 14:13
Re: Testing - Please ignore/delete this message Ray O'Donnell 14:17
Re: Testing - Please ignore/delete this message David G. Johnston 14:20
Re: Import csv to temp table Daniel Verite 14:51
New SET privilege for pg_has_role() in v16+ Dominique Devienne 15:24
Re: Import csv to temp table Adrian Klaver 16:06
Re: New SET privilege for pg_has_role() in v16+ Adrian Klaver 16:09
Re: New SET privilege for pg_has_role() in v16+ David G. Johnston 16:11
Re: New SET privilege for pg_has_role() in v16+ Dominique Devienne 16:15
Re: New SET privilege for pg_has_role() in v16+ Dominique Devienne 16:21
Re: New SET privilege for pg_has_role() in v16+ David G. Johnston 16:33
Re: New SET privilege for pg_has_role() in v16+ Adrian Klaver 16:40
Re: New SET privilege for pg_has_role() in v16+ Adrian Klaver 16:42
Re: Import csv to temp table Adrian Klaver 20:16

Jan. 3, 2024

Thread Author Time
Re: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" Michael Paquier 01:42
unable to resgiter witnes node in repmgr Vijaykumar Patil 05:25
encoding option when database backup Taek Oh 06:59
Re: encoding option when database backup rob stone 07:19
Sample data generator for performance testing arun chirappurath 07:23
Re: encoding option when database backup Taek Oh 13:14
Re: encoding option when database backup Adrian Klaver 16:19
Re: Sample data generator for performance testing Adrian Klaver 17:10
Re: Sample data generator for performance testing arun chirappurath 17:24
Re: Sample data generator for performance testing Adrian Klaver 17:33
Re: Sample data generator for performance testing arun chirappurath 17:50
Re: Sample data generator for performance testing Jeremy Schneider 17:56
Re: Sample data generator for performance testing arun chirappurath 18:02
Re: Sample data generator for performance testing Adrian Klaver 18:31

Jan. 4, 2024

Thread Author Time
PostgreSQL 11 packages gone from reporpms? PGUser2020 08:42
Re: PostgreSQL 11 packages gone from reporpms? PGUser2020 13:49
Re: PostgreSQL 11 packages gone from reporpms? Devrim Gündüz 14:45
Re: PostgreSQL 11 packages gone from reporpms? PGUser2020 20:05

Jan. 5, 2024

Thread Author Time
Re: Import csv to temp table Paolo Saudin 05:44
Re: Import csv to temp table Ryan Kelly 06:02
Filled Postgres server as Docker image Bernd Graf 10:31
Re: Filled Postgres server as Docker image Matthias Apitz 11:15
Hard max_stack_depth / WIN32_STACK_RLIMIT PostgreSQL Windows Query Paul Turton 12:07
Re: Hard max_stack_depth / WIN32_STACK_RLIMIT PostgreSQL Windows Query Tom Lane 15:26

Jan. 6, 2024

Thread Author Time
Re: Filled Postgres server as Docker image Justin Clift 08:36

Jan. 8, 2024

Thread Author Time
Unable to install postgresql and pgadmin Innocent Ememe 08:23
Point-In-Time Recovery issue - Timeline file lost Carlos Augusto Ferreira de Oliveira 11:23
How to \ef a function ? David Gauthier 16:26
Re: How to \ef a function ? Adrian Klaver 16:40
Re: Unable to install postgresql and pgadmin Adrian Klaver 16:42
Re: How to \ef a function ? Tom Lane 16:47
Re: How to \ef a function ? Tom Lane 17:12
Re: Emitting JSON to file using COPY TO Dean Rasheed 19:36
Re: Emitting JSON to file using COPY TO Joe Conway 20:40

Jan. 9, 2024

Thread Author Time
Make NUM_XLOGINSERT_LOCKS configurable 1111hqshj 03:22
postgresql custom variable in pg_settings table Yi Sun 07:38
Re: postgresql custom variable in pg_settings table Achilleas Mantzios - cloud 08:18
Order of multicolumn gist index Paul van der Linden 10:28
ERROR: invalid byte sequence for encoding UTF8: 0x00 Kiran K V 12:18
Re: postgresql custom variable in pg_settings table jian he 14:38
Re: ERROR: invalid byte sequence for encoding UTF8: 0x00 Laurenz Albe 15:13
Re: ERROR: invalid byte sequence for encoding UTF8: 0x00 Tom Lane 15:48
Re: Unable to install postgresql and pgadmin Adrian Klaver 16:00

Jan. 10, 2024

Thread Author Time
slightly unexpected result Torsten Förtsch 11:29
failed to setup barman backup when Posgres is running in Podman Container duc hiep ha 13:58
Re: slightly unexpected result Bruce Momjian 15:45
Re: failed to setup barman backup when Posgres is running in Podman Container kaido vaikla 15:57
Re: slightly unexpected result David G. Johnston 16:06
Re: slightly unexpected result Bruce Momjian 16:18
pgAdmin 8.1 install David Barron 18:47
Re: pgAdmin 8.1 install Adrian Klaver 18:55
RE: pgAdmin 8.1 install David Barron 18:58
Re: pgAdmin 8.1 install Adrian Klaver 19:14
RE: pgAdmin 8.1 install David Barron 19:37
Re: pgAdmin 8.1 install Adrian Klaver 19:40
Re: pgAdmin 8.1 install Craig McIlwee 20:17
RE: pgAdmin 8.1 install David Barron 20:20
Re: pgAdmin 8.1 install Adrian Klaver 20:50
RE: pgAdmin 8.1 install David Barron 21:06
Postgres 13 streaming replication standby not sending password, 'fe_sendauth: no password supplied' Keaney, Will 22:51
Re: Postgres 13 streaming replication standby not sending password, 'fe_sendauth: no password supplied' Ron Johnson 23:22

Jan. 11, 2024

Thread Author Time
Re: Postgres 13 streaming replication standby not sending password, 'fe_sendauth: no password supplied' Laurenz Albe 08:55
Time zone offset in to_char() Alban Hertroijs 15:06
Aw: Time zone offset in to_char() Karsten Hilbert 15:11
Aw: Time zone offset in to_char() Karsten Hilbert 15:14
Re: Time zone offset in to_char() michael 15:25
Re: Time zone offset in to_char() Alban Hertroijs 15:56
Re: Time zone offset in to_char() Alban Hertroijs 16:04
Re: Time zone offset in to_char() Adrian Klaver 16:43
Re: Time zone offset in to_char() Adrian Klaver 16:48
Re: Time zone offset in to_char() Adrian Klaver 17:27
Re: Time zone offset in to_char() Daniel Verite 18:39
Re: Time zone offset in to_char() Alban Hertroys 19:04
Re: Time zone offset in to_char() Alban Hertroys 19:13
Refresh Materialized View Issue Jeremiah Bauer 20:31
Re: Refresh Materialized View Issue Ron Johnson 20:37
Re: Refresh Materialized View Issue Jeremiah Bauer 20:50
Re: Time zone offset in to_char() Adrian Klaver 21:09
Re: Time zone offset in to_char() Adrian Klaver 21:15
Re: Refresh Materialized View Issue Ron Johnson 21:40
undefined symbol when installing pgcrypto on 16.1 Michael Nolan 22:46
Re: undefined symbol when installing pgcrypto on 16.1 Tom Lane 22:58
Re: Time zone offset in to_char() Jim Nasby 23:32
RE: Postgres 13 streaming replication standby not sending password, 'fe_sendauth: no password supplied' Keaney, Will 23:44
Re: Time zone offset in to_char() Adrian Klaver 23:46
Re: Time zone offset in to_char() Tom Lane 23:53

Jan. 12, 2024

Thread Author Time
Re: Refresh Materialized View Issue Jim Nasby 00:15
What should I expect when creating many logical replication slots? Antonin Bas 00:17
Re: Time zone offset in to_char() Jim Nasby 00:20
Re: Time zone offset in to_char() Jim Nasby 00:26
Software Bill of Materials (SBOM) Кристина Валентей 06:19
Re: Time zone offset in to_char() Alban Hertroijs 08:51
Re: Time zone offset in to_char() Alban Hertroijs 10:01
How much size saved by updating column to NULL ? Sébastien TANIERE 10:53
Re: [EXTERNAL]Re: Refresh Materialized View Issue Jeremiah Bauer 12:34
Re: How much size saved by updating column to NULL ? David G. Johnston 13:58
Issue with loading unicode characters with copy command Kiran K V 15:23
Re: How much size saved by updating column to NULL ? Ron Johnson 15:48
Re: How much size saved by updating column to NULL ? Tom Lane 16:20
Support for arm64 windows is absent - Would be nice to have! David Hussey 17:12
Re: Time zone offset in to_char() Adrian Klaver 17:14
Re: Issue with loading unicode characters with copy command Adrian Klaver 17:18
Re: Support for arm64 windows is absent - Would be nice to have! Dominique Devienne 17:19
Re: Time zone offset in to_char() Adrian Klaver 17:32
Re: Issue with loading unicode characters with copy command Kiran K V 17:47
Re: [EXTERNAL]Re: Refresh Materialized View Issue Jim Nasby 19:11
How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? David Ventimiglia 19:34
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Adrian Klaver 19:48
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Francisco Olarte 19:50
Re: Support for arm64 windows is absent - Would be nice to have! NAVSYSTEMS LTD 22:04
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Adrian Klaver 23:23

Jan. 13, 2024

Thread Author Time
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? David Ventimiglia 05:23
COBOL PRECOMPILER for PostGreSQL 📎 Chuck Haatvedt 05:39
Re: COBOL PRECOMPILER for PostGreSQL Tom Lane 06:08
Re: Software Bill of Materials (SBOM) Julian Coccia 11:10
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Adrian Klaver 16:29
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? David Ventimiglia 16:48
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Adrian Klaver 17:54
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Ron Johnson 19:04
multiple missing providers from pgdg-common Joseph G 19:26
Re: multiple missing providers from pgdg-common Devrim Gündüz 20:40
Re: multiple missing providers from pgdg-common Joseph G 21:07
Re: multiple missing providers from pgdg-common Joseph G 21:23
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? David Ventimiglia 21:34
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Ron Johnson 22:53
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? Karsten Hilbert 23:01
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? David Ventimiglia 23:07
Re: How to redirect output from PostgreSQL pg_recvlogical to a file or a pipe? David Ventimiglia 23:10

Jan. 14, 2024

Thread Author Time
Help with "Create Extension unaccent" Lan Xu 05:52
Re: Help with "Create Extension unaccent" Ian Lawrence Barwick 11:09
Why scan all columns when we select distinct c1? Yongtao Huang 11:17
Re: Why scan all columns when we select distinct c1? Ron Johnson 14:51
Re: Why scan all columns when we select distinct c1? Andreas Kretschmer 15:31
Re: Why scan all columns when we select distinct c1? Tom Lane 15:46
Re: Help with "Create Extension unaccent" Adrian Klaver 16:50
data migration using EXTENSION tds_fdw Eyüp Liste 18:55

Jan. 15, 2024

Thread Author Time
Re: Why scan all columns when we select distinct c1? Yongtao Huang 01:32
Moving to Postgresql database veem v 04:16
Add support for data change delta tables PavelTurk 10:00
Re: Add support for data change delta tables Pavel Stehule 10:05
Re: Add support for data change delta tables PavelTurk 10:11
Re: Add support for data change delta tables Pavel Stehule 10:17
Re: multiple missing providers from pgdg-common Devrim Gündüz 10:20
Re: Add support for data change delta tables PavelTurk 10:27
Re: Add support for data change delta tables Pavel Stehule 10:40
Re: Add support for data change delta tables Thomas Kellerer 10:44
Postgres authorization ad groups Czajkowski Łukasz 11:25
Re: data migration using EXTENSION tds_fdw Adrian Klaver 16:10
Re: Add support for data change delta tables Adrian Klaver 16:16
Unable to find column arun chirappurath 16:16
Re: Unable to find column Ian Harding 16:29
Re: Unable to find column Adrian Klaver 16:33
Re: Unable to find column arun chirappurath 17:26
Help needed for the resolution of memory leak 📎 Sasmit Utkarsh 17:32
Re: Unable to find column Adrian Klaver 17:35
Re: Software Bill of Materials (SBOM) Кристина Валентей 18:34
RE: data migration using EXTENSION tds_fdw Eyüp Liste 19:03
Re: data migration using EXTENSION tds_fdw Adrian Klaver 19:17
Re: multiple missing providers from pgdg-common Joseph G 19:22
Re: Moving to Postgresql database Justin Clift 19:43
Re: Help needed for the resolution of memory leak Merlin Moncure 20:00
Re: Help with "Create Extension unaccent" Lan Xu 20:04
Re: Moving to Postgresql database Henrique Lima 20:06
Re: Help with "Create Extension unaccent" Adrian Klaver 21:25
After the last update Arbol One 21:33
Re: After the last update Adrian Klaver 21:48
Re: After the last update Arbol One 22:38
Re: After the last update Adrian Klaver 23:22

Jan. 16, 2024

Thread Author Time
Re: After the last update Arbol One 01:59
Re: After the last update David G. Johnston 02:11
Re: Emitting JSON to file using COPY TO 📎 jian he 03:46
Re: After the last update Adrian Klaver 05:32
Re: Emitting JSON to file using COPY TO jian he 07:45
Re: Moving to Postgresql database Dominique Devienne 08:06
/usr/local/sisis-pap/pgsql-15.1/bin/postmaster SIGSEGV in podman container on MacOS Matthias Apitz 10:24
Nested-Internal Functions Rossana Ocampos 12:15
postgres sql assistance 📎 arun chirappurath 12:34
Aw: Nested-Internal Functions Karsten Hilbert 12:53
Re: postgres sql assistance Raul Giucich 13:00
Re: Nested-Internal Functions David G. Johnston 13:24
Re: postgres sql assistance Rob Sargent 14:34
Re: Nested-Internal Functions Laurenz Albe 14:41

Browse Archives

Prev | Next