pgsql-general - July 2021

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

July 1, 2021

Thread Author Time
Re: Ubuntu 14.04 (trusty) Postgres 13 deb package Bhavesh Mistry 00:40
Re: Connecting to Postgresql without IP address Ben Madin 00:45
Re: Ubuntu 14.04 (trusty) Postgres 13 deb package Adrian Klaver 02:41
Re: Connecting to Postgresql without IP address [email protected] 06:33
Damaged (during upgrade?) table, how to repair? W.P. 08:12
Must be superuser to create subscriptions - Any way I can avoid using superuser Avi Weinberg 08:43
Damaged (during upgrade?) table, how to repair? W.P. 08:56
Insert/Dump/Restore table with generated columns zickzack 10:06
Re: Insert/Dump/Restore table with generated columns David Rowley 13:14
Greatest of a list of columns? Ron 13:26
Re: Greatest of a list of columns? Pavel Stehule 13:27
Re: Greatest of a list of columns? Pavel Stehule 13:28
Re: Damaged (during upgrade?) table, how to repair? Laurenz Albe 14:19
EXPLAIN with anonymous DO block? Ron 16:16
Re: EXPLAIN with anonymous DO block? Michael Lewis 16:21
Re: EXPLAIN with anonymous DO block? Tom Lane 16:27
Re: EXPLAIN with anonymous DO block? David G. Johnston 16:28
Re: EXPLAIN with anonymous DO block? Pavel Luzanov 16:48
Re: Damaged (during upgrade?) table, how to repair? W.P. 19:56
Re: Damaged (during upgrade?) table, how to repair? Adrian Klaver 20:27

July 2, 2021

Thread Author Time
Re: PGDLLIMPORT: patch or not to patch Craig Ringer 02:17
Re: Damaged (during upgrade?) table, how to repair? W.P. 04:24
[No subject] Atul Kumar 12:24
Re: Igor Korot 15:05
Re: Damaged (during upgrade?) table, how to repair? Adrian Klaver 15:16
[No subject] Tom Lane 15:22
Re: Damaged (during upgrade?) table, how to repair? W.P. 17:18
Re: Damaged (during upgrade?) table, how to repair? Adrian Klaver 19:05

July 3, 2021

Thread Author Time
Re: Overlapping timestamptz ranges with priority Ray O'Donnell 15:13
Doubt on pgbouncer Rama Krishnan 15:35
Re: Doubt on pgbouncer Bruce Momjian 15:51
Re: Overlapping timestamptz ranges with priority Ray O'Donnell 16:32
Re: Doubt on pgbouncer Rama Krishnan 17:21
Re: Doubt on pgbouncer Ben Chobot 17:49
Re: Overlapping timestamptz ranges with priority Adrian Klaver 17:59
Re: Overlapping timestamptz ranges with priority Ray O'Donnell 19:16
Re: Overlapping timestamptz ranges with priority Adrian Klaver 20:13
Re: Overlapping timestamptz ranges with priority Ray O'Donnell 20:31

July 4, 2021

Thread Author Time
Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes Avi Weinberg 10:23
Re: Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes Vijaykumar Jain 15:53
Re: Damaged (during upgrade?) table, how to repair? W.P. 16:33
Re: Damaged (during upgrade?) table, how to repair? Adrian Klaver 17:35
Re: Damaged (during upgrade?) table, how to repair? Adrian Klaver 17:48
Re: Damaged (during upgrade?) table, how to repair? W.P. 18:59
Re: Damaged (during upgrade?) table, how to repair? Adrian Klaver 19:10
Re: Damaged (during upgrade?) table, how to repair? W.P. 19:29
Re: Damaged (during upgrade?) table, how to repair? W.P. 19:30
Re: Damaged (during upgrade?) table, how to repair? Adrian Klaver 20:19

July 5, 2021

Thread Author Time
Re: Doubt on pgbouncer Rama Krishnan 00:07
Re: postgresql version 13 repo question Yi Sun 00:58
Re: Atul Kumar 06:06
Re: Atul Kumar 06:12
RE: Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes Avi Weinberg 08:59
number of wal file is not reduced. Atul Kumar 09:48
Re: number of wal file is not reduced. hubert depesz lubaczewski 10:51
wal_keep_segments and max_wal_size Atul Kumar 11:15
Re: number of wal file is not reduced. Atul Kumar 11:18
Re: Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes Vijaykumar Jain 12:02
The Curious Case of the Table-Locking UPDATE Query 📎 Emiliano Saenz 23:22

July 6, 2021

Thread Author Time
Re: The Curious Case of the Table-Locking UPDATE Query Adrian Klaver 00:34
Re: Damaged (during upgrade?) table, how to repair? Sam Gendler 05:04
Re: The Curious Case of the Table-Locking UPDATE Query hubert depesz lubaczewski 09:24
When to REINDEX a serial key? Ron 09:35
Re: When to REINDEX a serial key? David Rowley 09:52
Question about how to handle numeric (decimal) data types while using libpq Sudheer H R 11:04
Re: Question about how to handle numeric (decimal) data types while using libpq Dmitry Igrishin 11:48
Re: Question about how to handle numeric (decimal) data types while using libpq Sudheer H R 12:02
Re: When to REINDEX a serial key? Ron 12:19
Re: When to REINDEX a serial key? Peter Eisentraut 12:25
Re: Question about how to handle numeric (decimal) data types while using libpq Peter Eisentraut 12:29
Re: When to REINDEX a serial key? Rob Sargent 14:06
Re: Planning time grows exponentially with levels of nested views Dean Rasheed 17:32
Re: Planning time grows exponentially with levels of nested views Tom Lane 17:52

July 7, 2021

Thread Author Time
Need suggestions about live migration from PG 9.2 to PG 13 📎 Lucas 01:22
pg_upgrade as a way of cloning an instance? Luca Ferrari 06:53
Re: pg_upgrade as a way of cloning an instance? Peter Eisentraut 08:22
Re: pg_upgrade as a way of cloning an instance? Luca Ferrari 08:30
Re: Need suggestions about live migration from PG 9.2 to PG 13 Magnus Hagander 08:43
Re: wal_keep_segments and max_wal_size Kyotaro Horiguchi 08:45
Does psqlodbc_10_03_0000-x86(32bit) support PostgreSQL 12.6 64bit? 管竚 10:38
Re: Does psqlodbc_10_03_0000-x86(32bit) support PostgreSQL 12.6 64bit? Diego 14:18
Re: Doubt on pgbouncer Merlin Moncure 21:39

July 8, 2021

Thread Author Time
Re: pg_upgrade as a way of cloning an instance? Bruce Momjian 00:30
Re: Does psqlodbc_10_03_0000-x86(32bit) support PostgreSQL 12.664bit? 管竚 03:15
Logical Replication Configuration for 11 sites Bi-directional logical replication Avi Weinberg 08:35
On partitioning, PKs and FKs Wiwwo Staff 08:42
optimization issue Atul Kumar 08:51
Re: On partitioning, PKs and FKs Ron 11:30
Re: On partitioning, PKs and FKs Michael Lewis 12:23
Re: optimization issue Michael Lewis 12:30
Re: Re: Insert/Dump/Restore table with generated columns zickzack 14:01
Re: Insert/Dump/Restore table with generated columns Tom Lane 14:12
Re: On partitioning, PKs and FKs Wiwwo Staff 15:15
Re: On partitioning, PKs and FKs 📎 Alban Hertroys 15:23
Re: Have I found an interval arithmetic bug? Zhihong Yu 17:22
Re: The Curious Case of the Table-Locking UPDATE Query 📎 Emiliano Saenz 17:28
Re: The Curious Case of the Table-Locking UPDATE Query 📎 Emiliano Saenz 17:35
Re: The Curious Case of the Table-Locking UPDATE Query hubert depesz lubaczewski 17:42
Re: optimization issue Atul Kumar 18:55
Re: The Curious Case of the Table-Locking UPDATE Query Emiliano Saenz 19:09
pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works Christopher Causer 19:50
Re: The Curious Case of the Table-Locking UPDATE Query Adrian Klaver 19:54
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works David G. Johnston 20:02
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works Tom Lane 20:09
Re: On partitioning, PKs and FKs Ron 20:09
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works David G. Johnston 20:19
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works David G. Johnston 20:24
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works Tom Lane 20:24
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works David G. Johnston 20:29
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works Tom Lane 20:29
What to look for when excessively long commits Steve Baldwin 20:35
Re: pg_dump's restore gives "operator does not exist: public.iprange = public.iprange" but copy paste works David G. Johnston 20:54

July 9, 2021

Thread Author Time
Re: optimization issue rob stone 03:16
Re: Need suggestions about live migration from PG 9.2 to PG 13 📎 Lucas 04:09
Re: On partitioning, PKs and FKs Wiwwo Staff 05:59
Re: On partitioning, PKs and FKs David G. Johnston 06:16
Happy Birthday PostgreSQL! 25 Years! THX! Elstermann, Mike 06:39
after psqlodbc upgrade - Which change solves the error: -2147217887 gzh 07:09
Removing a subscription that does not exist Jeff Ross 16:49
Re: optimization issue Kenneth Marshall 18:27
How to debug a connection that's "active" but hanging? Jurrie Overgoor 18:58
Why can't I drop a tablespace? Phil Endecott 19:04

July 10, 2021

Thread Author Time
Re: optimization issue rob stone 08:07
Re: How to debug a connection that's "active" but hanging? Vijaykumar Jain 08:26
Re: Why can't I drop a tablespace? Phil Endecott 15:43
Re: Why can't I drop a tablespace? Ron 16:13

July 11, 2021

Thread Author Time
Re: optimization issue Atul Kumar 07:05
libicu global support Jakub Jedelsky 21:52
Undocumented array_val[generate_series(...)] functionality? David G. Johnston 23:52

July 12, 2021

Thread Author Time
Re: Undocumented array_val[generate_series(...)] functionality? Rob Sargent 00:31
Re: Undocumented array_val[generate_series(...)] functionality? David Rowley 00:42
Re: Undocumented array_val[generate_series(...)] functionality? David G. Johnston 00:58
Re: Undocumented array_val[generate_series(...)] functionality? David Rowley 01:06
Re: Removing a subscription that does not exist Kyotaro Horiguchi 01:38
Re: Undocumented array_val[generate_series(...)] functionality? David G. Johnston 01:39
Re: Why can't I drop a tablespace? Laurenz Albe 05:35
Re: What to look for when excessively long commits Laurenz Albe 05:39
Re: Undocumented array_val[generate_series(...)] functionality? Dean Rasheed 07:10
Re: pg_upgrade as a way of cloning an instance? Luca Ferrari 09:38
Re: Why can't I drop a tablespace? Phil Endecott 13:43
Re: Removing a subscription that does not exist Jeff Ross 14:24
Re: Undocumented array_val[generate_series(...)] functionality? Tom Lane 14:27
Re: Undocumented array_val[generate_series(...)] functionality? David G. Johnston 14:42
RE: 3867653, EMM1 cluster issue on 23rd May--core generated --design feedback M Tarkeshwar Rao 15:06
Re: Why can't I drop a tablespace? Tom Lane 15:13
Re: Undocumented array_val[generate_series(...)] functionality? Tom Lane 16:14
Use of '&' as table prefix in query Rich Shepard 17:25
Re: Use of '&' as table prefix in query Tom Lane 17:36
Re: How to debug a connection that's "active" but hanging? Jurrie Overgoor 17:37
Re: Use of '&' as table prefix in query Rob Sargent 17:42
Re: Use of '&' as table prefix in query Rich Shepard 17:45
Re: How to debug a connection that's "active" but hanging? Tom Lane 17:46
Re: Use of '&' as table prefix in query Rich Shepard 17:47
Re: Use of '&' as table prefix in query Adrian Klaver 17:48
Re: Use of '&' as table prefix in query Adrian Klaver 17:50
Re: Use of '&' as table prefix in query Rob Sargent 17:51
Re: Use of '&' as table prefix in query Rich Shepard 18:02
Re: Use of '&' as table prefix in query Rich Shepard 18:04
Re: Use of '&' as table prefix in query [RESOLVED] Rich Shepard 18:13
Re: How to debug a connection that's "active" but hanging? Vijaykumar Jain 18:56
Re: How to debug a connection that's "active" but hanging? Jurrie Overgoor 20:56
Re: How to debug a connection that's "active" but hanging? Tom Lane 21:21

July 13, 2021

Thread Author Time
pg_wal lifecycle Luca Ferrari 07:07
Re: libicu global support Peter Eisentraut 13:37
Re: pg_wal lifecycle Peter Eisentraut 13:43
Need to check each element of an array satisfies a foreign key constraint David Gauthier 14:00
Re: Need to check each element of an array satisfies a foreign key constraint David G. Johnston 14:07
Re: Need to check each element of an array satisfies a foreign key constraint David Gauthier 14:46
psycopg2 mail list subscription issues Rich Shepard 17:29
Re: psycopg2 mail list subscription issues Diego 17:57
Json:- Accepting 'integer' value shaurya jain 18:38
Re: psycopg2 mail list subscription issues Rich Shepard 18:53
Re: Json:- Accepting 'integer' value Tom Lane 19:10
Re: psycopg2 mail list subscription issues Tom Lane 19:23
Re: psycopg2 mail list subscription issues Rich Shepard 19:27
Re: psycopg2 mail list subscription issues Stephen Frost 19:32
Re: Need to check each element of an array satisfies a foreign key constraint Ken Tanzer 19:44

July 14, 2021

Thread Author Time
PostgreSQL 12 on AWS Graviton2 ARM problem with IOPS 📎 Glauco Torres 00:35
PostgreSQL 9.2 high replication lag 📎 Lucas 01:09
Re: PostgreSQL 9.2 high replication lag 📎 Lucas 03:01
Re: PostgreSQL 9.2 high replication lag David G. Johnston 03:14
Re: PostgreSQL 9.2 high replication lag Laurenz Albe 05:30
Re: Need to check each element of an array satisfies a foreign key constraint Laurenz Albe 05:32
statistic target and sample rate Luca Ferrari 08:26
Re: pg_wal lifecycle Luca Ferrari 08:43
returning setof from insert ? Laura Smith 11:22
Re: returning setof from insert ? Magnus Hagander 12:14
Re: returning setof from insert ? Thomas Kellerer 12:14
Re: Why can't I drop a tablespace? Phil Endecott 12:17
Re: returning setof from insert ? Laura Smith 13:18
Re: statistic target and sample rate Tom Lane 14:30
ERROR: cannot freeze committed xmax Sasha Aliashkevich 14:36
Re: Have I found an interval arithmetic bug? Zhihong Yu 16:03
Problem upgrading from Postgresql 9.5 Adam Norwood 16:12
How to display stored image as bytea or as large objects? Csanyi Pal 19:56
Re: How to display stored image as bytea or as large objects? Ho John Lee 20:17
looping over multirange segments? Ben Chobot 23:19

July 15, 2021

Thread Author Time
Re: How to display stored image as bytea or as large objects? Csanyi Pal 04:12
Re: How to display stored image as bytea or as large objects? Ho John Lee 04:47
Re: How to debug a connection that's "active" but hanging? Jurrie Overgoor 08:30

Browse Archives

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