pgsql-general since 2022-06-26 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

June 26, 2022

Thread Author Time
Question about attention to [email protected] A Z 10:37
Re: Question about attention to [email protected] Laurenz Albe 11:22
Re: Question about attention to [email protected] Julien Rouhaud 13:15
Re: Question about attention to [email protected] Mladen Gogala 16:07
Re: Support logical replication of DDLs Alvaro Herrera 17:50
How can I set up Postgres to use given amount of RAM? W.P. 18:40
Re: How can I set up Postgres to use given amount of RAM? Zahid Rahman 22:49
Re: How can I set up Postgres to use given amount of RAM? Mladen Gogala 23:39

June 27, 2022

Thread Author Time
Re: Postgresql error : PANIC: could not locate a valid checkpoint record Michael Paquier 00:04
Re: Differences in Escaped bytea's when creating a plain pg_dump WR 06:44
Sv: How can I set up Postgres to use given amount of RAM? Andreas Joseph Krogh 06:50
Re: Differences in Escaped bytea's when creating a plain pg_dump WR 07:21
Re: Differences in Escaped bytea's when creating a plain pg_dump David G. Johnston 07:32
Table space not returned to the OS ? Florents Tselai 09:30
Re: Differences in Escaped bytea's when creating a plain pg_dump Wolfgang Rißler 09:31
Re: Table space not returned to the OS ? Magnus Hagander 09:38
Re: Table space not returned to the OS ? Thomas Boussekey 09:38
help for pg_wal issue Özge Özyavuz 09:50
Re: Table space not returned to the OS ? Florents Tselai 09:53
Re: Table space not returned to the OS ? Laurenz Albe 10:01
Re: Differences in Escaped bytea's when creating a plain pg_dump Daniel Verite 10:12
Re: help for pg_wal issue Laurenz Albe 10:28
Re: Question about attention to [email protected] Imre Samu 10:41
Re: Differences in Escaped bytea's when creating a plain pg_dump Wolfgang Rißler 11:00
Different sort result between PostgreSQL 8.4 and 12.5 gzh 11:30
Re: Different sort result between PostgreSQL 8.4 and 12.5 Magnus Hagander 11:33
Unique index prohibits partial aggregates Bos, Fred 11:49
Re: Table space not returned to the OS ? Magnus Hagander 14:33
Libpq question related to allocated resources Karl Denninger 16:35
Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") Bryn Llewellyn 19:36
Re: Unique index prohibits partial aggregates David Rowley 21:50

June 28, 2022

Thread Author Time
Re: Libpq question related to allocated resources Tom Lane 03:22
Re: Support logical replication of DDLs Amit Kapila 03:26
Re:Re: Different sort result between PostgreSQL 8.4 and 12.5 gzh 04:00
Re: help for pg_wal issue Kyotaro Horiguchi 07:28
Re: help for pg_wal issue Kyotaro Horiguchi 07:31
GIN index operator ?(jsonb,text) not working? jian he 08:55
Re: Support logical replication of DDLs Amit Kapila 12:13
Re: Libpq question related to allocated resources Karl Denninger 12:16
RE: Unique index prohibits partial aggregates Bos, Fred 12:45
Re: Support logical replication of DDLs vignesh C 16:47
Re: Unique index prohibits partial aggregates David Rowley 18:24

June 29, 2022

Thread Author Time
User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 01:41
Re: User's responsibility when using a chain of "immutable" functions? Christophe Pettus 02:02
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 02:22
Re: Support logical replication of DDLs Amit Kapila 03:06
Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 04:28
Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule 04:34
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 05:02
Re: User's responsibility when using a chain of "immutable" functions? Tom Lane 05:46
Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule 06:19
Re: User's responsibility when using a chain of "immutable" functions? Tom Lane 06:29
Re: User's responsibility when using a chain of "immutable" functions? Laurenz Albe 06:42
Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule 07:19
RE: Support logical replication of DDLs [email protected] 09:47
RE: Support logical replication of DDLs 📎 [email protected] 09:54
Re: Support logical replication of DDLs Amit Kapila 10:48
Re: User's responsibility when using a chain of "immutable" functions? Christophe Pettus 13:41
RE: help for pg_wal issue Özge Özyavuz 13:43
Question on pg_auto_failover extension DAN LU 14:14
Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 19:36
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 19:57

June 30, 2022

Thread Author Time
Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 00:03
Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston 00:51
Re: Support logical replication of DDLs Amit Kapila 06:14
Function inside query status Rama Krishnan 06:57
Re: Support logical replication of DDLs Amit Kapila 08:16
Fatel: unsupported frientend protocol error eswar reddy 11:10
Re: Fatel: unsupported frientend protocol error Laurenz Albe 12:17
Re: Fatel: unsupported frientend protocol error David G. Johnston 12:31
pg_amcheck warnings after upgrade to 14.4 Aleš Zelený 12:44
Re: Fatel: unsupported frientend protocol error Tom Lane 13:27
Re: Function inside query status Adrian Klaver 14:40
Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn 18:33

July 1, 2022

Thread Author Time
Re: Support logical replication of DDLs vignesh C 16:52

July 2, 2022

Thread Author Time
Re: Support logical replication of DDLs Amit Kapila 03:21
Re: Support logical replication of DDLs vignesh C 14:24
Re: Libpq question related to allocated resources Karl Denninger 18:30

July 3, 2022

Thread Author Time
plpgsql_check issue while upgrading from postgres version 12 to 13.7 shashidhar Reddy 09:39
Re: plpgsql_check issue while upgrading from postgres version 12 to 13.7 Pavel Stehule 12:20

July 4, 2022

Thread Author Time
Re: AIX and EAGAIN on open() Thomas Munro 02:44
Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery? Wen Yi 03:06
Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery? Adrian Klaver 03:31
Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery? Tom Lane 03:37
Postgresql 13.7 hangs down Bogdan Siara 08:33
Re: AIX and EAGAIN on open() Christoph Berg 09:29
Getting data from a record variable dynamically Rhys A.D. Stewart 23:02

July 5, 2022

Thread Author Time
Re: Getting data from a record variable dynamically David G. Johnston 01:03
Re: Getting data from a record variable dynamically Alban Hertroys 07:01
lifetime of the old CTID Matthias Apitz 07:51
- operator overloading not giving expected result Rajesh S 08:22
RE: Support logical replication of DDLs 📎 [email protected] 08:28
Re: lifetime of the old CTID Laurenz Albe 08:40
General Inquiry Cloete, F. (Francois) 08:49
Re: General Inquiry Tim Clarke 08:54
Re: lifetime of the old CTID Matthias Apitz 09:06
Re: lifetime of the old CTID Matthias Apitz 10:22
RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team 12:56
Re: lifetime of the old CTID Laurenz Albe 14:17
Re: lifetime of the old CTID Matthias Apitz 15:52
Re: lifetime of the old CTID Laurenz Albe 16:19
How to upgrade postgres version 8 to 13 shashidhar Reddy 16:54
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Tom Lane 16:59
Re: How to upgrade postgres version 8 to 13 Adrian Klaver 17:02
Re: How to upgrade postgres version 8 to 13 Adrian Klaver 17:52
Re: How to upgrade postgres version 8 to 13 shashidhar Reddy 17:56
Re: How to upgrade postgres version 8 to 13 Adrian Klaver 18:05
Seems to be impossible to set a NULL search_path Bryn Llewellyn 18:12
Re: How to upgrade postgres version 8 to 13 David G. Johnston 18:14
Re: Seems to be impossible to set a NULL search_path Adrian Klaver 18:18
Re: Seems to be impossible to set a NULL search_path Christophe Pettus 18:18
Re: Seems to be impossible to set a NULL search_path Pavel Stehule 18:24
Re: Seems to be impossible to set a NULL search_path Adrian Klaver 18:28
Re: How to upgrade postgres version 8 to 13 Michael Nolan 18:31
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Andrew Dunstan 18:52
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 19:05
Re: Seems to be impossible to set a NULL search_path Tom Lane 19:13
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Tom Lane 19:17
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Peter Geoghegan 19:41
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Peter Geoghegan 19:50
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Andrew Dunstan 21:25
Re: [UNVERIFIED SENDER] Re: pg_upgrade can result in early wraparound on databases with high transaction load Tom Lane 22:05
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 22:08
Re: Seems to be impossible to set a NULL search_path Adrian Klaver 23:33

July 6, 2022

Thread Author Time
Re: General Inquiry Kyotaro Horiguchi 00:49
Re: Seems to be impossible to set a NULL search_path David G. Johnston 01:16
Re: How to upgrade postgres version 8 to 13 shashidhar Reddy 01:20
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 03:55
RE: General Inquiry Cloete, F. (Francois) 05:28
Re: lifetime of the old CTID Matthias Apitz 05:35
Re: lifetime of the old CTID Christophe Pettus 05:44
Re: lifetime of the old CTID Andreas Kretschmer 05:54
Re: lifetime of the old CTID Andreas Kretschmer 05:58
Re: lifetime of the old CTID Matthias Apitz 06:18
Re: lifetime of the old CTID Laurenz Albe 06:41
Re: How to upgrade postgres version 8 to 13 Laurenz Albe 08:24
ADD COLUMN ts tsvector GENERATED too slow Florents Tselai 08:42
unable to understand query result Stefan Froehlich 09:31
Re: ADD COLUMN ts tsvector GENERATED too slow Peter Eisentraut 09:38
Re: unable to understand query result Peter Eisentraut 09:40
Re: lifetime of the old CTID Karsten Hilbert 09:45
Re: lifetime of the old CTID Karsten Hilbert 09:48
Re: ADD COLUMN ts tsvector GENERATED too slow Florents Tselai 09:48
Re: ADD COLUMN ts tsvector GENERATED too slow Florents Tselai 09:55
CPU is 100% azure rds postgreSQL-11 Pavan Kumar S 09:55
Re: unable to understand query result Stefan Froehlich 09:57
Re: ADD COLUMN ts tsvector GENERATED too slow Francisco Olarte 10:11
Re: ADD COLUMN ts tsvector GENERATED too slow Florents Tselai 10:35
Re: ADD COLUMN ts tsvector GENERATED too slow Florents Tselai 10:43
Re: ADD COLUMN ts tsvector GENERATED too slow Alvaro Herrera 11:33
Error when pasting function blocks into psql Ludwig Isaac Lim 12:24
Re: lifetime of the old CTID Matthias Apitz 12:26
Re: lifetime of the old CTID Alvaro Herrera 12:32
Re: lifetime of the old CTID Peter J. Holzer 13:53
Re: ADD COLUMN ts tsvector GENERATED too slow Francisco Olarte 14:32
Re: lifetime of the old CTID Matthias Apitz 14:32
Re: Seems to be impossible to set a NULL search_path David G. Johnston 15:33
Re: Seems to be impossible to set a NULL search_path Adrian Klaver 15:42
Re: lifetime of the old CTID Ilya Anfimov 15:56
Multiple Indexes DAVID ROTH 16:06
Why does pg_statio_user_tables report heap_blks_hit after index only scan? Aleksander Łukasz 16:33
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 16:48
Re: Seems to be impossible to set a NULL search_path Christophe Pettus 17:03
Re: Seems to be impossible to set a NULL search_path David G. Johnston 17:12
Re: Seems to be impossible to set a NULL search_path David G. Johnston 17:25
Re: lifetime of the old CTID Karsten Hilbert 17:45
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 18:50
Re: Multiple Indexes David Rowley 18:53
Re: lifetime of the old CTID Ron 19:33
Re: lifetime of the old CTID Matthias Apitz 19:51
Re: lifetime of the old CTID Christophe Pettus 19:56
Re: Seems to be impossible to set a NULL search_path David G. Johnston 20:08
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 20:13
Re: lifetime of the old CTID Adrian Klaver 20:15
Re: Seems to be impossible to set a NULL search_path David G. Johnston 20:26
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 20:47
Re: Seems to be impossible to set a NULL search_path Rob Sargent 21:10
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 22:15

July 7, 2022

Thread Author Time
Re: Seems to be impossible to set a NULL search_path David G. Johnston 03:20
Re: Seems to be impossible to set a NULL search_path Bryn Llewellyn 03:47
Re: database designs ERDs Zahid Rahman 03:59
About revoking large number of privileges; And the PUBLIC role. Dominique Devienne 07:47
postgresql generate ddl returns FK with `<?>()` in it Roman Gavrilov 13:05
Re: About revoking large number of privileges; And the PUBLIC role. Tom Lane 13:52
Re: About revoking large number of privileges; And the PUBLIC role. Dominique Devienne 14:36
Re: About revoking large number of privileges; And the PUBLIC role. Laurenz Albe 16:10

July 8, 2022

Thread Author Time
Re: Support logical replication of DDLs Peter Smith 02:26
Re: Seems to be impossible to set a NULL search_path Peter J. Holzer 09:04
Re: About revoking large number of privileges; And the PUBLIC role. Peter J. Holzer 09:24
postgresql bug ml 10:47
Re: - operator overloading not giving expected result Peter J. Holzer 10:59
Re: postgresql bug Laurenz Albe 11:00
Re: postgresql generate ddl returns FK with `<?>()` in it Peter J. Holzer 11:12
Re: postgresql generate ddl returns FK with `<?>()` in it Francisco Olarte 11:17
Re: postgresql bug Christoph Moench-Tegeder 11:24
Re: Error when pasting function blocks into psql Francisco Olarte 11:25
Re: CPU is 100% azure rds postgreSQL-11 Sunil Thakur 11:35
Re: - operator overloading not giving expected result Francisco Olarte 11:38
Re: - operator overloading not giving expected result Christoph Moench-Tegeder 12:46
Re: - operator overloading not giving expected result Tom Lane 14:13

Browse Archives

Prev | Next