pgsql-general since 2024-04-09 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

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
subquery plan rows = 1, but it's merge joined instead of index lookup 📎 ilya Basin 12:57
Re: (When) can a single SQL statement return multiple result sets? Tom Lane 14:07
Re: subquery plan rows = 1, but it's merge joined instead of index lookup Laurenz Albe 14:21
Question on trigger veem v 14:31
Re: subquery plan rows = 1, but it's merge joined instead of index lookup Ilya Basin 14:47
Re: Question on trigger Adrian Klaver 16:30

April 12, 2024

Thread Author Time
effect on planner of turning a subquery to a table, sql function returning table Thierry Henrio 10:33
Obsolete Linux downloads (Debian) instructions Laura Smith 10:43
Re: Obsolete Linux downloads (Debian) instructions Daniel Gustafsson 10:57
Re: effect on planner of turning a subquery to a table, sql function returning table David Rowley 10:58
Re: effect on planner of turning a subquery to a table, sql function returning table Thierry Henrio 11:27
Re: effect on planner of turning a subquery to a table, sql function returning table David Rowley 11:39
Re: effect on planner of turning a subquery to a table, sql function returning table Thierry Henrio 14:58

April 13, 2024

Thread Author Time
Re: Question on trigger veem v 07:03
Re: Question on trigger Adrian Klaver 16:14

April 14, 2024

Thread Author Time
Recursively trace all Foreign Key "referenced by" tables? 📎 Ron Johnson 02:35
constant crashing jack 14:24
Re: constant crashing Adrian Klaver 14:58
Re: constant crashing Tom Lane 15:05
re: constant crashing jack 16:20
Re: constant crashing Adrian Klaver 17:05
Re: constant crashing Tom Lane 17:13
Re: constant crashing Francisco Olarte 17:19
Re: constant crashing David G. Johnston 18:11
Re: constant crashing Vijaykumar Jain 19:18
re: constant crashing jack 19:22
Re: constant crashing Vijaykumar Jain 19:25
Re: constant crashing Tom Lane 19:30
re: constant crashing jack 19:44
Re: constant crashing Adrian Klaver 19:57
re: constant crashing jack 20:11
re: constant crashing jack 20:18
Re: constant crashing Adrian Klaver 20:28

April 15, 2024

Thread Author Time
Re: constant crashing Adrian Klaver 00:50
Re: constant crashing Tom Lane 01:29
Re: constant crashing jack 01:58
Re: constant crashing David Rowley 01:59
Re: constant crashing David G. Johnston 02:08
Failing streaming replication on PostgreSQL 14 Nicolas Seinlet 06:52
Re: constant crashing Francisco Olarte 08:24
efficiency random values / sequential ID values in indexes Sanjay Minni 10:04
Re: Failing streaming replication on PostgreSQL 14 Ron Johnson 12:36
Re: efficiency random values / sequential ID values in indexes Ron Johnson 12:48
Re: Failing streaming replication on PostgreSQL 14 Nicolas Seinlet 14:25
re: constant crashing hardware issue and thank you jack 14:45
No error message/code for commands after libpq pipeline abortion Jan Behrens 14:52
Re: (When) can a single SQL statement return multiple result sets? Peter Eisentraut 14:55
Re: (When) can a single SQL statement return multiple result sets? Jan Behrens 15:24
Re: Failing streaming replication on PostgreSQL 14 Alvaro Herrera 16:49
Re: (When) can a single SQL statement return multiple result sets? Merlin Moncure 22:16

April 16, 2024

Thread Author Time
Re: Failing streaming replication on PostgreSQL 14 📎 Nicolas Seinlet 07:56
Re: Obsolete Linux downloads (Debian) instructions Christoph Berg 10:48
Assistance needed for the query execution in non-public schema Sasmit Utkarsh 11:00
Re: Assistance needed for the query execution in non-public schema David Rowley 11:26
Re: Assistance needed for the query execution in non-public schema Laurenz Albe 11:28
Re: efficiency random values / sequential ID values in indexes Sanjay Minni 13:10
AWS RDS Postgres and the DBA: Which/how many aws permissions/access do we really need? Gus Spier 15:22
Re: Question on trigger veem v 19:39
Controlling resource utilization yudhi s 19:45
Re: Controlling resource utilization Juan Rodrigo Alejandro Burgos Mella 20:02
Re: Controlling resource utilization yudhi s 20:18
Re: Question on trigger Adrian Klaver 20:23
Re: Controlling resource utilization Juan Rodrigo Alejandro Burgos Mella 20:29

April 17, 2024

Thread Author Time
Re: Controlling resource utilization gparc 07:10
Re: Controlling resource utilization yudhi s 07:42
Re: Controlling resource utilization gparc 08:14
constant crashing hardware issue and thank you TAKE AWAY jack 13:06
Re: constant crashing hardware issue and thank you TAKE AWAY Madalin Ignisca 13:08
replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist Avi Weinberg 15:01
replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist Avi Weinberg 15:16
Re: Assistance needed for the query execution in non-public schema Sasmit Utkarsh 15:37
Re: constant crashing hardware issue and thank you TAKE AWAY Justin Clift 16:19
Performance degradation after upgrading from 9.5 to 14 Johnathan Tiamoh 17:13
Re: Performance degradation after upgrading from 9.5 to 14 Tomas Vondra 17:25
Re: Performance degradation after upgrading from 9.5 to 14 Christophe Pettus 17:28
Re: Performance degradation after upgrading from 9.5 to 14 Johnathan Tiamoh 17:32
Re: Performance degradation after upgrading from 9.5 to 14 Marcin Giedz 17:38
Re: replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist Justin 19:17

April 18, 2024

Thread Author Time
Why does it sort rows after a nested loop that uses already-sorted indexes? negora 11:00
Re: Why does it sort rows after a nested loop that uses already-sorted indexes? Tom Lane 14:53
Foreign Key error between two partitioned tables Michael Corey 17:47

April 19, 2024

Thread Author Time
SSPI Feature Request Buoro, John 01:53
Can you refresh a materialized view from a materialized view on another server? Michael Nolan 02:49
Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi 05:48
Re: Why does it sort rows after a nested loop that uses already-sorted indexes? negora 08:11
Re: SSPI Feature Request Justin Clift 10:05
Re: Not able to grant access on pg_signal_backend on azure flexible server Tom Lane 13:38
Re: Not able to grant access on pg_signal_backend on azure flexible server Adrian Klaver 14:20
Re: Can you refresh a materialized view from a materialized view on another server? Adrian Klaver 14:48
Re: Foreign Key error between two partitioned tables David Rowley 23:19

April 20, 2024

Thread Author Time
[help] Error in database import Tu Ho 03:58
Re: [help] Error in database import Ron Johnson 04:09
Re: [help] Error in database import Adrian Klaver 04:27
Re: Performance degradation after upgrading from 9.5 to 14 kaido vaikla 07:59
Logging statement having any threat? Lok P 14:02
Re: Logging statement having any threat? Adrian Klaver 16:32
Re: Logging statement having any threat? Adrian Klaver 16:35
I wrote a summary of lesser-known Postgres type system information Guyren Howe 17:04

April 21, 2024

Thread Author Time
error in trigger creation yudhi s 08:12
Re: error in trigger creation David G. Johnston 08:25
Re: error in trigger creation yudhi s 08:55
Re: Logging statement having any threat? Lok P 09:35
Re: error in trigger creation David G. Johnston 14:25
Re: error in trigger creation Tom Lane 14:43
Re: Logging statement having any threat? Adrian Klaver 16:17
Re: error in trigger creation yudhi s 18:09
Re: error in trigger creation David G. Johnston 18:18
Re: error in trigger creation yudhi s 18:20
Re: error in trigger creation David G. Johnston 18:32
Re: error in trigger creation yudhi s 18:57
Re: error in trigger creation Ron Johnson 20:04
query multiple schemas Norbert Sándor 20:12
Re: error in trigger creation yudhi s 20:15
Re: query multiple schemas Steve Baldwin 20:35
query multiple schemas David G. Johnston 20:41
Re: error in trigger creation Adrian Klaver 20:53
Re: query multiple schemas Tom Lane 21:11
Re: error in trigger creation Tom Lane 21:21
CLUSTER vs. VACUUM FULL Ron Johnson 22:07
Re: CLUSTER vs. VACUUM FULL Tom Lane 22:45

April 22, 2024

Thread Author Time
Re: CLUSTER vs. VACUUM FULL Ron Johnson 00:06
Re: CLUSTER vs. VACUUM FULL Ron Johnson 00:15
Re: error in trigger creation Adrian Klaver 00:47
Re: CLUSTER vs. VACUUM FULL David Rowley 01:34
Re: CLUSTER vs. VACUUM FULL Ron Johnson 02:50
Missing PG_MODULE_MAGIC error Abhishek Chanda 03:18
Re: Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi 05:10
Re: Not able to grant access on pg_signal_backend on azure flexible server David G. Johnston 05:20
Re: Not able to grant access on pg_signal_backend on azure flexible server Saksham Joshi 05:48
Re: Not able to grant access on pg_signal_backend on azure flexible server David G. Johnston 06:11
Re: Not able to grant access on pg_signal_backend on azure flexible server Bagesh Kumar Singh 07:20
Re: CLUSTER vs. VACUUM FULL Marcos Pegoraro 11:42
Re: Failing streaming replication on PostgreSQL 14 Nicolas Seinlet 11:50
Re: CLUSTER vs. VACUUM FULL Tom Lane 14:25
Re: CLUSTER vs. VACUUM FULL Ron Johnson 15:37
Re: CLUSTER vs. VACUUM FULL Adrian Klaver 15:51
adding a generated column to a table? Celia McInnis 16:05
Re: adding a generated column to a table? Adrian Klaver 16:16
Re: CLUSTER vs. VACUUM FULL David G. Johnston 16:29
Re: CLUSTER vs. VACUUM FULL Marcos Pegoraro 17:50

Browse Archives

Prev | Next