pgsql-general - April 2022

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 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

April 1, 2022

Thread Author Time
Does PGDG apt repository support ARM64? Daniele Varrazzo 01:22
Re: Does PGDG apt repository support ARM64? Adrian Klaver 04:07
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 06:27
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 06:48
Re: Locking a table read-only temporarilty Laurenz Albe 07:04
weird issue with occasional stuck queries 📎 spiral 07:06
Re: Does PGDG apt repository support ARM64? Magnus Hagander 14:28
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 14:51
Re: Does PGDG apt repository support ARM64? Magnus Hagander 15:00
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 15:08
Re: Does PGDG apt repository support ARM64? Magnus Hagander 15:22
LISTEN - ERROR: could not access status of transaction 3021015672 Aleš Zelený 15:43
Re: Does PGDG apt repository support ARM64? Adrian Klaver 18:04
Re: weird issue with occasional stuck queries Adam Scott 22:53

April 2, 2022

Thread Author Time
How long does iteration over 4-5 million rows usually take? Shaozhong SHI 01:34
How long does iteration over 4-5 million rows usually take? Shaozhong SHI 01:35
Re: How long does iteration over 4-5 million rows usually take? Adrian Klaver 01:47
Re: How long does iteration over 4-5 million rows usually take? Ron 02:18
Re: weird issue with occasional stuck queries spiral 12:23
Re: How long does iteration over 4-5 million rows usually take? Rob Sargent 13:21
Aw: Re: How long does iteration over 4-5 million rows usually take? Karsten Hilbert 13:46
Re: Re: How long does iteration over 4-5 million rows usually take? Shaozhong SHI 14:16
Re: Re: How long does iteration over 4-5 million rows usually take? Benedict Holland 14:34
Re: How long does iteration over 4-5 million rows usually take? Steve Midgley 16:38
Re: weird issue with occasional stuck queries Adam Scott 19:09

April 3, 2022

Thread Author Time
Re: weird issue with occasional stuck queries overland 02:08

April 4, 2022

Thread Author Time
PostgreSQL JSON Dave Ekhaus 01:47
Re: PostgreSQL JSON David G. Johnston 01:57
gist segmentation fault 📎 Arup Nanda 08:35
Transaction and SQL errors Sebastien Flaesch 11:33
Re: Transaction and SQL errors Karsten Hilbert 11:37
Re: Transaction and SQL errors David Rowley 11:44
Select .... where id not in (....) returns 0 incorrectly J. Roeleveld 12:08
Re: Transaction and SQL errors Sebastien Flaesch 12:38
Re: Transaction and SQL errors Sebastien Flaesch 12:41
Re: Select .... where id not in (....) returns 0 incorrectly Ravi Krishna 12:44
Re: Select .... where id not in (....) returns 0 incorrectly Jeremy Smith 12:50
Re: Select .... where id not in (....) returns 0 incorrectly J. Roeleveld 13:21
Re: Transaction and SQL errors J. Roeleveld 13:26
Re: Transaction and SQL errors David G. Johnston 13:47
Re: gist segmentation fault Tom Lane 14:12
Trigger functions and FDW tables Michael Nolan 14:18
Re: Trigger functions and FDW tables Laurenz Albe 14:23
Re: gist segmentation fault Arup Nanda 14:45
Re: PostgreSQL on focal and llvm version Christoph Berg 14:56
how to find out field size? Shaozhong SHI 15:28
Re: how to find out field size? Adrian Klaver 15:37
Re: Trigger functions and FDW tables Michael Nolan 16:15
Re: Transaction and SQL errors Sebastien Flaesch 16:20
Re: Select .... where id not in (....) returns 0 incorrectly David Rowley 20:47
Load Balancer with PostgreSQL Lucas 23:14
Where is the best place to read for the paper around database? BeginnerC 23:34

April 5, 2022

Thread Author Time
JSON question Dave Ekhaus 04:45
Re: Select .... where id not in (....) returns 0 incorrectly J. Roeleveld 05:37
Re: Serializable read only deferrable- implications Michael Lewis 17:01
Re: Select .... where id not in (....) returns 0 incorrectly Mladen Gogala 23:25

April 6, 2022

Thread Author Time
Re: Select .... where id not in (....) returns 0 incorrectly Peter J. Holzer 06:19
Cascade view drop permission checks [email protected] 06:46
Re: Cascade view drop permission checks David G. Johnston 07:13
Re: Transaction and SQL errors Gilles Darold 08:26
Re: Transaction and SQL errors Sebastien Flaesch 08:56
Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) 📎 W.P. 08:57
Re: Cascade view drop permission checks [email protected] 10:04
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Laurenz Albe 10:37
PostgreSQL 10.20 crashes / Antivirus Thomas, Richard 10:59
Re: Support logical replication of DDLs Ajin Cherian 11:37
Re: Cascade view drop permission checks David G. Johnston 12:16
Re: Cascade view drop permission checks Tom Lane 13:48
Re: Cascade view drop permission checks David G. Johnston 14:20
Re: PostgreSQL 10.20 crashes / Antivirus Adrian Klaver 14:41
RE: PostgreSQL 10.20 crashes / Antivirus Thomas, Richard 14:55
Re: PostgreSQL 10.20 crashes / Antivirus Adrian Klaver 15:17
Re: PostgreSQL 10.20 crashes / Antivirus Adrian Klaver 15:20
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 16:41
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Ron 16:54
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Laura Smith 17:20
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 18:04
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Ray O'Donnell 18:06
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Adrian Klaver 18:09
Per-Table vacuum_freeze_min_age Chris Bisnett 22:13
Re: Per-Table vacuum_freeze_min_age Tom Lane 22:22
Re: Per-Table vacuum_freeze_min_age Adrian Klaver 22:24
What have I done!?!?!? :-) Perry Smith 22:25
Re: Per-Table vacuum_freeze_min_age Chris Bisnett 22:28
Re: Per-Table vacuum_freeze_min_age Adrian Klaver 22:31
Re: What have I done!?!?!? :-) David G. Johnston 22:41
Re: Per-Table vacuum_freeze_min_age Chris Bisnett 22:45
Re: What have I done!?!?!? :-) Lionel Bouton 23:05
Re: What have I done!?!?!? :-) Perry Smith 23:15

April 7, 2022

Thread Author Time
Resources on modeling ordered hierachies? Tim Uckun 05:45
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 06:23
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Laurenz Albe 06:48
Reg. GET STACKED DIAGNOSTICS values to be stored in a single variable Maheswaran R 10:00
Re: Support logical replication of DDLs Amit Kapila 10:16
Re: Support logical replication of DDLs Amit Kapila 10:19
Re: Reg. GET STACKED DIAGNOSTICS values to be stored in a single variable Pavel Stehule 10:44
How to get updated order data Andrus 13:16
Re: What have I done!?!?!? :-) Jan Wieck 15:10
Re: Resources on modeling ordered hierachies? Peter J. Holzer 16:55
Re: Resources on modeling ordered hierachies? Rob Sargent 18:12
psql removes dashed comments Boris Zentner 18:25
Re: psql removes dashed comments Adrian Klaver 18:29
Re: psql removes dashed comments David G. Johnston 18:41
Re: psql removes dashed comments David G. Johnston 18:48
Re: psql removes dashed comments Boris Zentner 19:22
Re: psql removes dashed comments Tom Lane 20:27

April 8, 2022

Thread Author Time
Re: What have I done!?!?!? :-) Nikolay Samokhvalov 05:57
Could not read block 0 in file friend.have_00 07:01
PostgreSQL : error hint for LATERAL join PALAYRET Jacques 08:29
Re: Could not read block 0 in file Vijaykumar Jain 09:46
Re: Could not read block 0 in file Magnus Hagander 09:54
Re: Could not read block 0 in file Vijaykumar Jain 10:01
Re: Could not read block 0 in file Ron 10:01
Re: Could not read block 0 in file Vijaykumar Jain 10:22
Re: Support logical replication of DDLs Amit Kapila 11:00
Re: Support logical replication of DDLs Amit Kapila 11:13
Re: Support logical replication of DDLs Alvaro Herrera 11:34
Re: How to get updated order data Laurenz Albe 12:26
Re: What have I done!?!?!? :-) Jan Wieck 12:47
Re: What have I done!?!?!? :-) Magnus Hagander 12:58
Re: How to get updated order data Magnus Hagander 13:07
Re: What have I done!?!?!? :-) Jan Wieck 13:07
Re: What have I done!?!?!? :-) Magnus Hagander 13:10
Re: Support logical replication of DDLs Robert Haas 13:12
Re: What have I done!?!?!? :-) Perry Smith 13:22
Re: What have I done!?!?!? :-) Magnus Hagander 13:27
Re: What have I done!?!?!? :-) Perry Smith 13:27
Re: What have I done!?!?!? :-) Magnus Hagander 13:28
Re: PostgreSQL : error hint for LATERAL join David G. Johnston 13:36
Re: What have I done!?!?!? :-) Jan Wieck 13:58
Re: What have I done!?!?!? :-) Jan Wieck 14:01
Long running processes and commit writing to disk Shaozhong SHI 16:39
Long running processes and commit writing to disk Shaozhong SHI 16:39
RE: Long running processes and commit writing to disk Mike Sofen 16:52
Re: Long running processes and commit writing to disk Rob Sargent 17:05
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 17:18
FOR integer loop bug? Adrian Klaver 17:56
Re: FOR integer loop bug? Pavel Stehule 17:58
Re: Long running processes and commit writing to disk Ron 18:01
Re: FOR integer loop bug? Adrian Klaver 18:07
Re: FOR integer loop bug? Ron 18:23
Re: FOR integer loop bug? Adrian Klaver 19:27

April 9, 2022

Thread Author Time
Constraint ordering Perry Smith 14:42
Re: Constraint ordering David G. Johnston 15:01
Re: Constraint ordering Ron 15:05
Re: Constraint ordering Tom Lane 15:07

April 11, 2022

Thread Author Time
LDAP - Postgres server running on windows Joshua Price 04:57
Re: Support logical replication of DDLs Amit Kapila 05:00
Re: Support logical replication of DDLs Amit Kapila 05:04
Re: PostgreSQL : error hint for LATERAL join PALAYRET Jacques 08:00
Declarative partitioning and partition pruning/check Mats Taraldsvik 12:07
Re: Support logical replication of DDLs Euler Taveira 12:46
DBlink extension and behavior of dblink_get_connections() Pankaj Gupta 13:00
Re: PostgreSQL : error hint for LATERAL join Tom Lane 14:20
Re: PostgreSQL : error hint for LATERAL join David G. Johnston 16:05
Re: Support logical replication of DDLs Zheng Li 16:42
Re: Support logical replication of DDLs Zheng Li 17:31
Re: Support logical replication of DDLs Zheng Li 17:36
How easy is it to lose permissions in 'public' schema? Rob Sargent 23:10

April 12, 2022

Thread Author Time
Re: How easy is it to lose permissions in 'public' schema? Adrian Klaver 00:28
Re: How easy is it to lose permissions in 'public' schema? Tom Lane 00:34
Re: How easy is it to lose permissions in 'public' schema? Adrian Klaver 00:51
Re: How easy is it to lose permissions in 'public' schema? Rob Sargent 01:34
Re: Transaction and SQL errors Sebastien Flaesch 09:48
Major release of advanced PostgreSQL driver written in C++ Dmitry Igrishin 10:19
[email protected] not getting linked with Homebrew - trying to install postgresql cecile rougnaux 10:33
Re: Support logical replication of DDLs Amit Kapila 10:55
Re: Major release of advanced PostgreSQL driver written in C++ Dominique Devienne 10:59
Re: Support logical replication of DDLs Amit Kapila 11:12
Re: Major release of advanced PostgreSQL driver written in C++ Dmitry Igrishin 11:35
Re: [email protected] not getting linked with Homebrew - trying to install postgresql Tom Lane 14:26
Re: [email protected] not getting linked with Homebrew - trying to install postgresql Dan Davis 15:29
Re: [email protected] not getting linked with Homebrew - trying to install postgresql Adrian Klaver 15:35
Re: alter function/procedure depends on extension 📎 David G. Johnston 15:36
Re: alter function/procedure depends on extension Tom Lane 15:49
Re: alter function/procedure depends on extension David G. Johnston 15:55
Feedback about hybrid SAN snap and rsync'd approach for large systemcloning Jerry Sievers 23:07

April 13, 2022

Thread Author Time
Re: Support logical replication of DDLs Zheng Li 00:19
Re: Support logical replication of DDLs Amit Kapila 03:47
Re: [email protected] not getting linked with Homebrew - trying to install postgresql Adrian Ho 06:16
Re: Feedback about hybrid SAN snap and rsync'd approach for large systemcloning Laurenz Albe 08:39
RE: [email protected] not getting linked with Homebrew - trying to install postgresql cecile rougnaux 09:07
Re: Support logical replication of DDLs Dilip Kumar 09:07
Re: Support logical replication of DDLs Amit Kapila 09:50
Re: Support logical replication of DDLs 📎 Zheng Li 17:22

April 14, 2022

Thread Author Time
Is this a reasonable use for advisory locks? Perryn Fowler 07:10
Re: Is this a reasonable use for advisory locks? Steve Baldwin 08:38
Re: Is this a reasonable use for advisory locks? Perryn Fowler 09:05
Re: Support logical replication of DDLs Dilip Kumar 09:26
Re: Is this a reasonable use for advisory locks? Steve Baldwin 09:47
Re: Is this a reasonable use for advisory locks? Nick Cleaton 12:31
Re: Support logical replication of DDLs Euler Taveira 14:15
ERROR: XX000: cache lookup failed for type 75083631 Jan Beseda 15:04
What do you guys use for issue tracking, CI/CD and team management? any nice open source options? Achilleas Mantzios 15:19
Re: ERROR: XX000: cache lookup failed for type 75083631 Tom Lane 17:24
Re: Support logical replication of DDLs Zheng Li 20:31

April 15, 2022

Thread Author Time
Re: Support logical replication of DDLs 📎 Zheng Li 02:08
Re: Is this a reasonable use for advisory locks? Perryn Fowler 08:41
Require details that can we see the password history to a User account in PostgreSQL Database. Sonai muthu raja M 09:11
Re: Require details that can we see the password history to a User account in PostgreSQL Database. Adrian Klaver 15:59

Browse Archives

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