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

Oct. 1, 2023

Thread Author Time
Re: Gradual migration from integer to bigint? James Healy 03:16
Re: Gradual migration from integer to bigint? Tom Lane 03:37
Re: Gradual migration from integer to bigint? Ron 04:26
Re: cache lookup failed for function 0 📎 pf 05:57
Re: Gradual migration from integer to bigint? James Healy 08:18
Re: Gradual migration from integer to bigint? Ann Harrison 09:30
What changes to a table cannot be detected by a trigger? Phillip Diffley 13:35
Re: cache lookup failed for function 0 Tom Lane 14:32
Re: Gradual migration from integer to bigint? Ireneusz Pluta 17:04
Re: Gradual migration from integer to bigint? Ron 22:47

Oct. 2, 2023

Thread Author Time
Re: pg_agent jobs Giovanni Biscontini 07:50
Operating of synchronous master when no standby is available Sergey Cherukhin 08:54
Re: Operating of synchronous master when no standby is available Andreas Kretschmer 11:15
How to investigate deadlocks Matthias Apitz 11:27
Re: How to investigate deadlocks Andreas Kretschmer 11:36
Re: How to investigate deadlocks Andreas Kretschmer 11:39
Cancelling "vacuum full" in single user mode? Colin 't Hart 12:38
Cancelling "vacuum full" in single user mode? Colin 't Hart 12:39
specifying multiple options in URI psql behaviour? Wim Bertels 12:48
Re: Cancelling "vacuum full" in single user mode? Laurenz Albe 13:59
Re: How to investigate deadlocks Laurenz Albe 14:01
Re: How to investigate deadlocks Tom Lane 14:16
Re: specifying multiple options in URI psql behaviour? Tom Lane 14:21
Problems starting slave Douglas Reed 14:38
How to force "re-TOAST" after changing STORAGE or COMPRESSION? Dominique Devienne 14:42
Re: Operating of synchronous master when no standby is available Ron 14:59
Re: specifying multiple options in URI psql behaviour? Wim Bertels 15:21
Re: pg_agent jobs Adrian Klaver 16:10
pg_stat_statements IN problem byme 16:19
Trigger functions and parallelism Karl O. Pinc 16:49
Re: Trigger functions and parallelism Tom Lane 17:07
Re: pg_stat_statements IN problem Wim Bertels 18:50
Re: Trigger functions and parallelism Karl O. Pinc 19:23
Re: Operating of synchronous master when no standby is available MATSUO Takatoshi 22:13
Re: How to investigate deadlocks David G. Johnston 22:25
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? Michael Paquier 23:57

Oct. 3, 2023

Thread Author Time
Re: pgBackRest for a 50 TB database Abhishek Bhola 00:08
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? rob stone 01:33
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? Laurenz Albe 04:31
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? Michael Paquier 04:45
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? Dominique Devienne 07:08
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? Michael Paquier 07:15
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? Laurenz Albe 07:17
Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? Dominique Devienne 07:29
Re: pg_stat_statements IN problem byme 08:05
Re: pg_stat_statements IN problem David Rowley 08:22
Re: Operating of synchronous master when no standby is available Sergey Cherukhin 08:51
Re: pg_stat_statements IN problem Laurenz Albe 08:54
Re: pg_stat_statements IN problem byme 09:03
Re: pg_stat_statements IN problem David Rowley 09:19
Peer authentication failed ??? Amn Ojee Uw 09:55
Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf' Harry Green 09:59
Re: Operating of synchronous master when no standby is available MATSUO Takatoshi 10:22
Re: Peer authentication failed ??? David G. Johnston 12:35
Re: Operating of synchronous master when no standby is available Sergey Cherukhin 12:40
Re: Problems starting slave Ron 13:33
Re: specifying multiple options in URI psql behaviour? Ron 13:35
Re: Peer authentication failed ??? Peter J. Holzer 13:37
Re: pgBackRest for a 50 TB database Stephen Frost 13:39
Re: Problems starting slave Douglas Reed 14:37
Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf' Adrian Klaver 14:57
Re: Problems starting slave Ron 15:08
Logical Replication vs. Free Replication Slots Don Seiler 15:27
Re: Logical Replication vs. Free Replication Slots Don Seiler 16:41
Strange error trying to import with Ora2PG Johnson, Bruce E - (bjohnson) 17:32
Re: Strange error trying to import with Ora2PG Adrian Klaver 21:27

Oct. 4, 2023

Thread Author Time
Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Lincoln Swaine-Moore 02:32
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Steve Crawford 03:36
Re: pgBackRest for a 50 TB database Abhishek Bhola 04:11
Re: pgBackRest for a 50 TB database KK CHN 05:44
Re: Peer authentication failed ??? Amn Ojee Uw 09:28
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Marian Wendt 10:27
Re: [EXT]Re: Strange error trying to import with Ora2PG Johnson, Bruce E - (bjohnson) 13:24
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Tom Lane 14:11
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Marian Wendt 14:55
Re: [EXT]Re: Strange error trying to import with Ora2PG Adrian Klaver 15:38
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Lincoln Swaine-Moore 15:58
Re: [EXT]Re: Strange error trying to import with Ora2PG Johnson, Bruce E - (bjohnson) 16:04
I'm using both window and agg, is this expected sorting behavior? jinser 16:05
Re: I'm using both window and agg, is this expected sorting behavior? Tom Lane 16:32
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Tom Lane 16:54
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Lincoln Swaine-Moore 17:10
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Tom Lane 17:22
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Lincoln Swaine-Moore 17:35
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Tom Lane 17:40
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Lincoln Swaine-Moore 17:45
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Steve Crawford 19:00
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Alban Hertroys 19:06
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Lincoln Swaine-Moore 19:16
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Lincoln Swaine-Moore 19:30
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Brent Wood 19:48
Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones Alban Hertroys 21:10
Multiple inserts with two levels of foreign keys Dow Drake 23:59

Oct. 5, 2023

Thread Author Time
Re: Multiple inserts with two levels of foreign keys Ron 01:25
Re: Multiple inserts with two levels of foreign keys Dow Drake 01:50
Re: Multiple inserts with two levels of foreign keys Ron 01:57
Re: Multiple inserts with two levels of foreign keys Dow Drake 02:15
Re: Multiple inserts with two levels of foreign keys Ron 02:31
Index scan is not pushed down to union all subquery Lauri Kajan 06:14
Re: pgBackRest for a 50 TB database Abhishek Bhola 07:09
Re: Index scan is not pushed down to union all subquery Marian Wendt 09:13
Re: Index scan is not pushed down to union all subquery Marian Wendt 09:20
Re: Index scan is not pushed down to union all subquery Marian Wendt 09:33
Re: Multiple inserts with two levels of foreign keys Alvaro Herrera 09:39
Re: Index scan is not pushed down to union all subquery Dominique Devienne 09:44
Ask about Foreign Table Plug-in on Windows Server. Anuwat Sagulmontreechai 10:39
Re: Gradual migration from integer to bigint? Nick Cleaton 12:25
Re: pgBackRest for a 50 TB database Stephen Frost 13:19
Re: Index scan is not pushed down to union all subquery Lauri Kajan 13:25
Re: Multiple inserts with two levels of foreign keys Dow Drake 14:33
How to make a map in pg kernel? jacktby jacktby 14:33
Re: Multiple inserts with two levels of foreign keys Ron 14:59
Re: Ask about Foreign Table Plug-in on Windows Server. Laurenz Albe 19:43
No yum repo for CentOS 7 and postgres 16? Jeff Ross 20:55
No yum repo for CentOS 7 and postgres 16? David G. Johnston 21:46
Re: No yum repo for CentOS 7 and postgres 16? Jeff Ross 22:02

Oct. 6, 2023

Thread Author Time
RE: Ask about Foreign Table Plug-in on Windows Server. Anuwat Sagulmontreechai 06:31
why generated columsn cannot be used in COPY TO? Luca Ferrari 11:53
Re: why generated columsn cannot be used in COPY TO? Andreas Kretschmer 12:20
Re: why generated columsn cannot be used in COPY TO? Ron 13:16
Re: why generated columsn cannot be used in COPY TO? Tom Lane 13:47
Re: why generated columsn cannot be used in COPY TO? Andreas Kretschmer 14:04
Re: How to make a map in pg kernel? Artur Zakirov 14:38
Re: why generated columsn cannot be used in COPY TO? Rob Sargent 14:55
Re: why generated columsn cannot be used in COPY TO? David G. Johnston 15:03
Re: why generated columsn cannot be used in COPY TO? Dominique Devienne 15:06
Re: why generated columsn cannot be used in COPY TO? Ron 15:45
Re: why generated columsn cannot be used in COPY TO? Adrian Klaver 15:53
Re: why generated columsn cannot be used in COPY TO? David G. Johnston 16:08
Re: why generated columsn cannot be used in COPY TO? Ron 16:17
Re: why generated columsn cannot be used in COPY TO? Tom Lane 16:37
Re: Restoring default privileges on objects Laurenz Albe 20:16
Re: Restoring default privileges on objects 📎 Laurenz Albe 20:18
Re: why generated columsn cannot be used in COPY TO? David G. Johnston 20:28
Re: Restoring default privileges on objects Laurenz Albe 20:28
Re: Gradual migration from integer to bigint? Bruce Momjian 21:11

Oct. 7, 2023

Thread Author Time
Monitoring logical replication Shaheed Haque 15:31
psql trying twice to connect to local DB Steve Baldwin 22:44
Re: psql trying twice to connect to local DB Steve Baldwin 23:13
Re: psql trying twice to connect to local DB Tom Lane 23:14

Oct. 8, 2023

Thread Author Time
Re: psql trying twice to connect to local DB Ron 02:39
Re: Multiple inserts with two levels of foreign keys Peter J. Holzer 09:02
Re: Multiple inserts with two levels of foreign keys Dow Drake 21:01

Oct. 9, 2023

Thread Author Time
Re: Index scan is not pushed down to union all subquery Lauri Kajan 07:36
GIST index and ORDER BY Michał Kłeczek 10:39

Oct. 10, 2023

Thread Author Time
Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version David HJ 03:49
Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version Laurenz Albe 06:22
Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version Julien Rouhaud 06:32
Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version Tatsuo Ishii 06:53
Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version Laurenz Albe 09:26
Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version Tom Lane 14:37
A question about possible recovery inconsistency 📎 Eugen Konkov 15:46

Oct. 11, 2023

Thread Author Time
Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version Peter Eisentraut 05:53
Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version Tom Lane 05:56
Subject: FATAL: cache lookup failed for relation 1247 Israr Khan 06:05
Re: A question about possible recovery inconsistency Laurenz Albe 07:45
Can not drop partition if exist foreign keys 📎 Олег Самойлов 11:08
Re: Can not drop partition if exist foreign keys Alvaro Herrera 11:17
Re: Can not drop partition if exist foreign keys Laurenz Albe 11:20
moving data with pg_dump/pg_restore between database with different locale Zwettler Markus (OIZ) 11:34
No Data Being Inserted Anthony Apollis 11:46
Re: No Data Being Inserted Ron 12:39
Re: Subject: FATAL: cache lookup failed for relation 1247 Tom Lane 14:24
Re: A question about possible recovery inconsistency Eugen Konkov 14:52
Re: No Data Being Inserted Adrian Klaver 15:14
log wal file transfer in error logs Atul Kumar 16:45
Re: moving data with pg_dump/pg_restore between database with different locale Laurenz Albe 16:49
Re: log wal file transfer in error logs Laurenz Albe 16:51
Re: A question about possible recovery inconsistency Ron 17:07
Re: log wal file transfer in error logs Atul Kumar 17:50
Re: log wal file transfer in error logs Ron 17:59
Postgresql HA cluster Jason Grammenos 18:01
Assitance needed for the resolution of memory leak Sasmit Utkarsh 19:15
Re: Assitance needed for the resolution of memory leak Adrian Klaver 19:36
Re: Assitance needed for the resolution of memory leak Sasmit Utkarsh 20:26
Re: Assitance needed for the resolution of memory leak Tom Lane 20:37
Re: Assitance needed for the resolution of memory leak Sasmit Utkarsh 21:19

Oct. 12, 2023

Thread Author Time
Re: Assitance needed for the resolution of memory leak Ron 00:05
Re: A question about possible recovery inconsistency Ron 00:14
logs are not getting logged in error logs Atul Kumar 00:24
Re: logs are not getting logged in error logs Adrian Klaver 00:35
Change error code severity for syslog? Abhishek Bhola 00:42
Re: Change error code severity for syslog? Michael Paquier 00:59
Question About PostgreSQL Extensibility Sepideh Eidi 06:09
Re: log wal file transfer in error logs Laurenz Albe 07:18
List users privileges for whole cluster/all databases in the cluster Jana Mihalidesová 13:32
Re: Question About PostgreSQL Extensibility Laurenz Albe 13:43
Re: List users privileges for whole cluster/all databases in the cluster Priancka Chatz 14:05
Re: List users privileges for whole cluster/all databases in the cluster Tom Lane 14:25
Re: List users privileges for whole cluster/all databases in the cluster Dominique Devienne 14:49
Re: Can not drop partition if exist foreign keys 📎 Олег Самойлов 14:56
Re: Postgresql HA cluster Олег Самойлов 15:07
Re: Question About PostgreSQL Extensibility Ilya Kosmodemiansky 15:08

Oct. 13, 2023

Thread Author Time
Re: Question About PostgreSQL Extensibility Chris Travers 05:05
Re: Can not drop partition if exist foreign keys Laurenz Albe 06:05
psql \du no more showing "member of" column Luca Ferrari 11:39
RE: Postgresql HA cluster Jason Grammenos 12:02
Re: psql \du no more showing "member of" column hubert depesz lubaczewski 13:04
Re: psql \du no more showing "member of" column Ian Lawrence Barwick 13:06
Re: Postgresql HA cluster Jehan-Guillaume de Rorthais 13:10

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 31