pgsql-general since 2024-03-28 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

March 28, 2024

Thread Author Time
Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function Jeff Ross 00:53
Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function Jeff Ross 01:00
Re: After 10 -> 15 upgrade getting "cannot commit while a portal is pinned" on one python function Adrian Klaver 02:37
How to interpret 'depends on' errors in pg_restore? Fire Emerald 09:32
Inquiry on Participating in the Korean Translation Project for PostgreSQL Documentation 김명준 11:56
Re: Support logical replication of DDLs Andrey M. Borodin 12:00
Re: Support logical replication of DDLs Amit Kapila 12:03
Problems caused by type resolution for the unknown type rwxrw 12:03
Re: Problems caused by type resolution for the unknown type David G. Johnston 13:32
Re: How to interpret 'depends on' errors in pg_restore? Tom Lane 14:00
Re: Inquiry on Participating in the Korean Translation Project for PostgreSQL Documentation Adrian Klaver 14:22
Re: Inquiry on Participating in the Korean Translation Project for PostgreSQL Documentation Daniel Gustafsson 14:25
Re: Problems caused by type resolution for the unknown type Tom Lane 14:32
pg_rewind after promote Emond Papegaaij 14:52
Re: pg_rewind after promote Laurenz Albe 15:21
Re: could not open file "global/pg_filenode.map": Operation not permitted Nick Renders 15:47
Re: Inquiry on Participating in the Korean Translation Project for PostgreSQL Documentation Adrian Klaver 15:51
Re: How to interpret 'depends on' errors in pg_restore? Fire Emerald 15:57
Re: How to interpret 'depends on' errors in pg_restore? Tom Lane 16:03
Re: pg_rewind after promote Emond Papegaaij 16:17
Re: How to interpret 'depends on' errors in pg_restore? Adrian Klaver 16:19
Table level restore in postgres arun chirappurath 18:27
Re: Table level restore in postgres Adrian Klaver 19:09
Re: Table level restore in postgres Ron Johnson 19:41
Re: Inquiry on Participating in the Korean Translation Project for PostgreSQL Documentation Bruce Momjian 20:36
Grants and privileges issue sud 21:10
Re: Grants and privileges issue Adrian Klaver 21:13
Cron not running Lok P 21:28
Re: Grants and privileges issue sud 21:43
Re: Cron not running Ron Johnson 21:54
Re: pg_rewind after promote Laurenz Albe 22:01
Re: Grants and privileges issue Erik Wienhold 22:22

March 29, 2024

Thread Author Time
how to check if the license is expired. 黄宁 01:28
Re: could not open file "global/pg_filenode.map": Operation not permitted Thomas Munro 03:25
Please recommend postgresql.conf improvements for osm2pgsql loading Europe Alexander Farber 19:53
How to reference a DB with a period in its name ? David Gauthier 21:16
Re: How to reference a DB with a period in its name ? David G. Johnston 21:20
Re: How to reference a DB with a period in its name ? David G. Johnston 21:21
Re: How to reference a DB with a period in its name ? Christophe Pettus 21:24
PostgreSQL hardening best practice Jason Long 21:35
Re: How to reference a DB with a period in its name ? David Gauthier 21:36
Re: How to reference a DB with a period in its name ? negora 21:50
Re: PostgreSQL hardening best practice Flavious Kumfa 22:04
Re: How to reference a DB with a period in its name ? Rob Sargent 22:52

March 30, 2024

Thread Author Time
Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe Justin Clift 03:33
Access issue for system queries arun chirappurath 04:47
Re: Access issue for system queries Julien Rouhaud 05:06
Re: Access issue for system queries arun chirappurath 05:30
Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe Alexander Farber 10:04
RE: Query on Postgres SQL transaction Bandi, Venkataramana - Dell Team 10:14
Re: Query on Postgres SQL transaction Greg Sabino Mullane 10:44
Re: how to check if the license is expired. Ron Johnson 13:23
Re: How to reference a DB with a period in its name ? Jan Wieck 14:06
Re: Query on Postgres SQL transaction Adrian Klaver 15:35
Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe Alexander Farber 18:07

March 31, 2024

Thread Author Time
Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe Justin Clift 07:31
Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe hector vass 15:55
Re: how to check if the license is expired. Peter J. Holzer 16:59
Re: how to check if the license is expired. Christophe Pettus 20:09
Re: Feature request: pg_get_tabledef(text) Hans Schou 23:26

April 1, 2024

Thread Author Time
Re: Please recommend postgresql.conf improvements for osm2pgsql loading Europe Alexander Farber 00:37
Re: Emitting JSON to file using COPY TO 📎 jian he 12:00
Re: Not able to purge partition sud 20:11

April 2, 2024

Thread Author Time
Timestamp conversion Error in dynamic sql script sud 05:38
Re: Timestamp conversion Error in dynamic sql script Laurenz Albe 08:08
Re: Not able to purge partition Laurenz Albe 08:16
Getting wrong datetime in database using insert into table query. Saksham Joshi 08:58
Re: Getting wrong datetime in database using insert into table query. Sándor Daku 09:48
Re: Timestamp conversion Error in dynamic sql script Erik Wienhold 12:01
Re: Timestamp conversion Error in dynamic sql script Greg Sabino Mullane 14:16
Re: Getting wrong datetime in database using insert into table query. Adrian Klaver 14:43
Re: Timestamp conversion Error in dynamic sql script sud 20:08
Re: Timestamp conversion Error in dynamic sql script Erik Wienhold 20:57
What linux version to install ? David Gauthier 23:53

April 3, 2024

Thread Author Time
Re: What linux version to install ? Adrian Klaver 00:27
Query regarding new version of shared library with older binary M Tarkeshwar Rao 11:42
Re: could not open file "global/pg_filenode.map": Operation not permitted Nick Renders 14:11
Re: Timestamp conversion Error in dynamic sql script sud 20:09
Moving delta data faster yudhi s 20:38
Re: could not open file "global/pg_filenode.map": Operation not permitted Thomas Munro 20:56
Re: Moving delta data faster Adrian Klaver 21:11
Re: could not open file "global/pg_filenode.map": Operation not permitted Thomas Munro 21:14

April 4, 2024

Thread Author Time
Re: recovery.signal not being removed when recovery complete Michael Paquier 00:34
Re: Moving delta data faster yudhi s 03:54
Re: Moving delta data faster Adrian Klaver 04:46
Failure of postgres_fdw because of TimeZone setting Adnan Dautovic 05:23
Re: Moving delta data faster yudhi s 05:24
Re: Failure of postgres_fdw because of TimeZone setting Tom Lane 05:54
What permissions are required for e.g. EXPLAIN UPDATE ... Thomas Nyberg 10:38
Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function Roman Šindelář 13:42
Re: Failure of postgres_fdw because of TimeZone setting Adrian Klaver 15:15
Re: Moving delta data faster Adrian Klaver 15:34
Multiple COPY statements for one table vs one for ~half a billion records Carl L 18:03
Re: Multiple COPY statements for one table vs one for ~half a billion records Ron Johnson 18:15
Re: What permissions are required for e.g. EXPLAIN UPDATE ... Tom Lane 18:44
Re: Moving delta data faster yudhi s 20:42
Re: Moving delta data faster Greg Sabino Mullane 21:08

April 5, 2024

Thread Author Time
Re: Moving delta data faster Adrian Klaver 00:39
About postgres pg_upgrade Rama Krishnan 04:47
Re: About postgres pg_upgrade Daniel Gustafsson 07:41
Re: Failure of postgres_fdw because of TimeZone setting Adnan Dautovic 09:22
Re: Failure of postgres_fdw because of TimeZone setting Adnan Dautovic 09:39
Re: Failure of postgres_fdw because of TimeZone setting Tom Lane 14:13
Re: Failure of postgres_fdw because of TimeZone setting Adrian Klaver 15:05
Role Graph for PostgreSQL (v16+) v1-Beta David G. Johnston 20:02

April 6, 2024

Thread Author Time
Parallel GIN index? Andreas Joseph Krogh 10:09
Re: Moving delta data faster veem v 14:02
Re: Moving delta data faster yudhi s 15:47
Re: Moving delta data faster Adrian Klaver 16:55
Re: About postgres pg_upgrade Bruce Momjian 17:41
Re: Moving delta data faster yudhi s 20:04
Re: Moving delta data faster Adrian Klaver 20:55
pg_dumpall - restoration problem Tony Bazeley 23:05

April 7, 2024

Thread Author Time
Re: pg_dumpall - restoration problem Tom Lane 01:05
Query regarding functions of postgres Ayush Vatsa 12:04
Re: pg_dumpall - restoration problem- resolved Tony Bazeley 13:18
Re: Query regarding functions of postgres David G. Johnston 14:21
Re: Query regarding functions of postgres Tom Lane 15:18
Clarification on View Privileges and Operator Execution in PostgreSQL Ayush Vatsa 16:10
Re: Clarification on View Privileges and Operator Execution in PostgreSQL David G. Johnston 16:25
Re: Clarification on View Privileges and Operator Execution in PostgreSQL Ayush Vatsa 16:32
Re: Clarification on View Privileges and Operator Execution in PostgreSQL David G. Johnston 16:37
Re: Clarification on View Privileges and Operator Execution in PostgreSQL David G. Johnston 17:01
Re: Clarification on View Privileges and Operator Execution in PostgreSQL Ayush Vatsa 18:02
Re: Clarification on View Privileges and Operator Execution in PostgreSQL David G. Johnston 18:14
Re: Clarification on View Privileges and Operator Execution in PostgreSQL Ayush Vatsa 18:22

April 8, 2024

Thread Author Time
LwLocks contention (MultiXactOffsetControlLock/multixact_offset) when running logical replication initial snapshot Marko Sutic 12:48
What is referential_action? Ron Johnson 13:37
Re: What is referential_action? Christophe Pettus 13:39
Re: What is referential_action? David G. Johnston 13:41
Re: What is referential_action? Ron Johnson 13:44
Storing and comparing columns of cryptographic hashes? Josh Triplett 14:07
PEM install error mark bradley 14:24
Re: Storing and comparing columns of cryptographic hashes? Greg Sabino Mullane 14:43
Re: PEM install error Adrian Klaver 14:49
prepared statement "cu1" already exists (but it does not) Sebastien Flaesch 15:31
Re: prepared statement "cu1" already exists (but it does not) 📎 Sebastien Flaesch 16:25
Re: prepared statement "cu1" already exists (but it does not) Dominique Devienne 16:40
Re: prepared statement "cu1" already exists (but it does not) Tom Lane 17:36
Re: prepared statement "cu1" already exists (but it does not) 📎 Sebastien Flaesch 17:44

April 9, 2024

Thread Author Time
Regarding: Replication of TRUNCATE commands is not working Arvind Raghuwanshi 09:20
Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options Rajan Pandey 10:19
Re: Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options Laurenz Albe 10:36
Re: Regarding: Replication of TRUNCATE commands is not working Laurenz Albe 10:38
Re: Regarding: Replication of TRUNCATE commands is not working Arvind Raghuwanshi 12:07
Tracing libpq client: Only with PQtrace()? Sebastien Flaesch 12:50
Re: Tracing libpq client: Only with PQtrace()? Alvaro Herrera 14:09
Re: Regarding: Replication of TRUNCATE commands is not working Adrian Klaver 14:28
Re: Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options 📎 Rajan Pandey 14:36
Re: prepared statement "cu1" already exists (but it does not) Sebastien Flaesch 14:44
Re: Tracing libpq client: Only with PQtrace()? Greg Sabino Mullane 14:50
[Code: 0, SQL State: 0A000] when "typing" from pg_catalog Thiemo Kellner 14:59
Re: Tracing libpq client: Only with PQtrace()? Alvaro Herrera 15:01
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog Adrian Klaver 15:09
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog Thiemo Kellner 15:12
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog Adrian Klaver 15:18
Re: Tracing libpq client: Only with PQtrace()? Sebastien Flaesch 15:32
Issue with date/timezone conversion function Lok P 15:43
Re: Issue with date/timezone conversion function Adrian Klaver 15:56
Re: Issue with date/timezone conversion function Lok P 16:16
PL/pgSQL techniques better than bash for dynamic DO? Ron Johnson 16:33
Re: Moving delta data faster yudhi s 16:36
Re: prepared statement "cu1" already exists (but it does not) Tom Lane 16:36
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog Thiemo Kellner 16:48
Re: prepared statement "cu1" already exists (but it does not) Sebastien Flaesch 16:48
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog Thiemo Kellner 16:49
Re: Issue with date/timezone conversion function Adrian Klaver 16:58
Re: Issue with date/timezone conversion function Tom Lane 17:03
Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog Tom Lane 17:09
Re: PL/pgSQL techniques better than bash for dynamic DO? Pavel Stehule 17:10
Re: Issue with date/timezone conversion function Lok P 18:24
Re: Issue with date/timezone conversion function yudhi s 18:49
Re: Issue with date/timezone conversion function Adrian Klaver 22:35

April 10, 2024

Thread Author Time
Re: Storing and comparing columns of cryptographic hashes? Justin 00:06
Some advice need after a 20 year gap after Ingres/GUIs John Bateson 10:11
Re: Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options Rajan Pandey 10:24
mystery with postgresql.auto.conf Matthias Apitz 11:09
Re: mystery with postgresql.auto.conf Ian Lawrence Barwick 12:08
Re: mystery with postgresql.auto.conf Matthias Apitz 12:40
Re: mystery with postgresql.auto.conf Ian Lawrence Barwick 12:49
Re: Some advice need after a 20 year gap after Ingres/GUIs Francisco Prado 13:38
Re: mystery with postgresql.auto.conf Tom Lane 14:26
Re: mystery with postgresql.auto.conf Laurenz Albe 14:33
Re: Some advice need after a 20 year gap after Ingres/GUIs Dominique Devienne 14:48
Re: Some advice need after a 20 year gap after Ingres/GUIs Adrian Klaver 14:58
Re: mystery with postgresql.auto.conf Greg Sabino Mullane 16:34
Re: Failure of postgres_fdw because of TimeZone setting Adnan Dautovic 19:38
Re: Failure of postgres_fdw because of TimeZone setting Adnan Dautovic 19:48
Re: Failure of postgres_fdw because of TimeZone setting Adrian Klaver 20:04
Re: Failure of postgres_fdw because of TimeZone setting Tom Lane 20:21
Re: Failure of postgres_fdw because of TimeZone setting Tom Lane 20:31
Two server instances on one server Andreas Wagner 20:38
Re: Two server instances on one server Tom Lane 20:41
(When) can a single SQL statement return multiple result sets? Jan Behrens 21:22
Re: Failure of postgres_fdw because of TimeZone setting Adrian Klaver 21:25
Re: (When) can a single SQL statement return multiple result sets? Merlin Moncure 22:47
Re: (When) can a single SQL statement return multiple result sets? Tom Lane 23:02

April 11, 2024

Thread Author Time
Re: (When) can a single SQL statement return multiple result sets? Thomas Kellerer 05:25
Re: Two server instances on one server Andreas Wagner 07:07
RE: (When) can a single SQL statement return multiple result sets? Patrick FICHE 07:41

Browse Archives

Prev | Next