pgsql-general since 2023-03-27 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)
Advanced Search

Browse Archives

Prev | Next

March 27, 2023

Thread Author Time
Re: Binding Postgres to port 0 for testing Michael Paquier 01:27
Re: Support logical replication of DDLs vignesh C 03:57
Re: Binding Postgres to port 0 for testing Markus Pilman 04:49
Re: Binding Postgres to port 0 for testing Michael Paquier 05:10
Re: Support logical replication of DDLs Amit Kapila 06:37
Re: Support logical replication of DDLs Amit Kapila 12:07
C function returning a tuple containing an array of tuples Alberto 21:03

March 28, 2023

Thread Author Time
Re: PostgreSQL vs MariaDB Thomas Guyot 03:44
RE: Support logical replication of DDLs [email protected] 04:12
Re: Support logical replication of DDLs Amit Kapila 05:40
Re: PostgreSQL vs MariaDB Achilleas Mantzios - cloud 06:10
RE: Support logical replication of DDLs [email protected] 06:22
Re: Oracle to PostgreSQL Migration Laurenz Albe 06:26
Using CTID system column as a "temporary" primary key Sebastien Flaesch 09:28
DB migration : Sybase to Postgres Sengottaiyan T 09:52
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 09:57
Re: Using CTID system column as a "temporary" primary key Geoff Winkless 10:20
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 10:24
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 10:39
Re: Using CTID system column as a "temporary" primary key Christophe Pettus 12:39
Plans for ON DELETE CASCADE? Which index is used, if at all? Dominique Devienne 12:45
Cluster table based on grand parent? Dominique Devienne 13:17
Re: Plans for ON DELETE CASCADE? Which index is used, if at all? Tom Lane 13:23
How are the SELECT queries reconstructed in pg_views Julius de Bruijn 13:43
Re: Plans for ON DELETE CASCADE? Which index is used, if at all? Dominique Devienne 13:55
Re: Plans for ON DELETE CASCADE? Which index is used, if at all? Adrian Klaver 14:22
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 14:23
Re: Cluster table based on grand parent? Adrian Klaver 14:26
Re: Support logical replication of DDLs Jonathan S. Katz 14:51
Patroni, slots, and expiring WALs Peter J. Holzer 14:55
Re: Patroni, slots, and expiring WALs Jeremy Smith 15:07
Re: Cluster table based on grand parent? Peter J. Holzer 15:08
Re: Patroni, slots, and expiring WALs Alexander Kukushkin 15:08
Re: Patroni, slots, and expiring WALs Peter J. Holzer 15:09
Re: Cluster table based on grand parent? Dominique Devienne 15:24
Re: Patroni, slots, and expiring WALs Peter J. Holzer 15:27
Re: Patroni, slots, and expiring WALs Peter J. Holzer 15:53
Re: Cluster table based on grand parent? Ron 16:05
Re: Cluster table based on grand parent? Dominique Devienne 16:28
Re: Using CTID system column as a "temporary" primary key Maciek Sakrejda 16:45
Re: Cluster table based on grand parent? Rob Sargent 16:49
Re: Cluster table based on grand parent? Ron 17:00
Re: Using CTID system column as a "temporary" primary key Kirk Wolak 18:24
Re: How are the SELECT queries reconstructed in pg_views Adrian Klaver 20:23
Re: How are the SELECT queries reconstructed in pg_views Adrian Klaver 20:26
Re: Support logical replication of DDLs Zheng Li 21:19

March 29, 2023

Thread Author Time
Re: Support logical replication of DDLs Amit Kapila 09:13
Re: Using CTID system column as a "temporary" primary key Laurenz Albe 11:08
Move from MySQL to PostgreSQL basti 12:57
Re: Move from MySQL to PostgreSQL Thomas Kellerer 13:34
libpq: empty arrays have rank 0 in binary results? whatever the type's rank? Dominique Devienne 13:37
Re: libpq: empty arrays have rank 0 in binary results? whatever the type's rank? Tom Lane 13:45
Re: libpq: empty arrays have rank 0 in binary results? whatever the type's rank? Dominique Devienne 14:02
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 14:19
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 14:23
Re: Using CTID system column as a "temporary" primary key Adrian Klaver 14:59
Re: Using CTID system column as a "temporary" primary key Laurenz Albe 15:53
Re: Using CTID system column as a "temporary" primary key Peter J. Holzer 16:43
Re: Support logical replication of DDLs Zheng Li 16:53
Do BRIN indexes support MIN/MAX? Andrey Klochkov 17:18
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 19:04
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 19:11
Re: Using CTID system column as a "temporary" primary key Adrian Klaver 19:15
Re: Using CTID system column as a "temporary" primary key Christophe Pettus 19:18
Re: Using CTID system column as a "temporary" primary key Adrian Klaver 19:23
Re: Do BRIN indexes support MIN/MAX? Vladimir Sitnikov 20:06
Re: Using CTID system column as a "temporary" primary key Alban Hertroys 20:15
Re: Using CTID system column as a "temporary" primary key Francisco Olarte 20:16
Re: Do BRIN indexes support MIN/MAX? Francisco Olarte 20:46
Re: Do BRIN indexes support MIN/MAX? Andrey Klochkov 21:03
COPY and custom datestyles. Or some other technique? Ron 23:24
Re: COPY and custom datestyles. Or some other technique? Adrian Klaver 23:31
Re: COPY and custom datestyles. Or some other technique? Adrian Klaver 23:40

March 30, 2023

Thread Author Time
Re: COPY and custom datestyles. Or some other technique? Thorsten Glaser 00:20
Re: COPY and custom datestyles. Or some other technique? Ron 01:44
Re: COPY and custom datestyles. Or some other technique? Ron 01:50
Get dead tuples data 任重 01:58
Re: COPY and custom datestyles. Or some other technique? David G. Johnston 02:06
Re: COPY and custom datestyles. Or some other technique? Ron 02:38
Re: COPY and custom datestyles. Or some other technique? David G. Johnston 03:03
Re: Do BRIN indexes support MIN/MAX? Vladimir Sitnikov 03:58
Re: Do BRIN indexes support MIN/MAX? Julien Rouhaud 04:02
Re: Do BRIN indexes support MIN/MAX? Tom Lane 04:18
Re: Do BRIN indexes support MIN/MAX? Vladimir Sitnikov 04:19
Re: Do BRIN indexes support MIN/MAX? David Rowley 04:44
Re: Do BRIN indexes support MIN/MAX? Vladimir Sitnikov 04:57
RE: Support logical replication of DDLs 📎 [email protected] 06:37
Re: Using CTID system column as a "temporary" primary key Sebastien Flaesch 06:54
RE: Support logical replication of DDLs 📎 [email protected] 07:59
Re: Using CTID system column as a "temporary" primary key Dominique Devienne 08:01
Multilang text search. Is this correct? Florents Tselai 08:15
Re: Using CTID system column as a "temporary" primary key Francisco Olarte 09:42
Re: Support logical replication of DDLs vignesh C 09:45
Re: Support logical replication of DDLs Amit Kapila 10:22
Re: Support logical replication of DDLs Amit Kapila 10:31
Re: Get dead tuples data David Rowley 10:55
Re: Support logical replication of DDLs vignesh C 11:08
Re: Using CTID system column as a "temporary" primary key Dominique Devienne 12:32
Re: Using CTID system column as a "temporary" primary key Laurenz Albe 15:13
libpq: COPY FROM STDIN BINARY of arrays Dominique Devienne 15:40
Re: libpq: COPY FROM STDIN BINARY of arrays Tom Lane 16:00
Re: Using CTID system column as a "temporary" primary key Peter J. Holzer 16:21
Re: Multilang text search. Is this correct? Tom Lane 18:28
Re: Do BRIN indexes support MIN/MAX? Andrey Klochkov 20:05
recovery long after startup Rébeli-Szabó Tamás 20:35
Re: recovery long after startup Tom Lane 20:42
Re: Support logical replication of DDLs Peter Smith 22:30

March 31, 2023

Thread Author Time
Question on creating keys on partitioned tables Siddharth Jain 00:05
Re: libpq: COPY FROM STDIN BINARY of arrays Dominique Devienne 12:34
Cannot terminate backend Arnaud Lesauvage 13:46
Re: Question on creating keys on partitioned tables Laurenz Albe 13:46
Re: Cannot terminate backend Laurenz Albe 13:55
RE: Cannot terminate backend Arnaud Lesauvage 14:41
Re: Question on creating keys on partitioned tables Siddharth Jain 15:53
Re: Cannot terminate backend Paul Ramsey 15:57
Re: Question on creating keys on partitioned tables Tom Lane 16:06
Re: Question on creating keys on partitioned tables Siddharth Jain 17:35
My tests show that a WITH HOLD cursor has subtly different semantics from a WITHOUT HOLD cursor Bryn Llewellyn 19:35
Re: My tests show that a WITH HOLD cursor has subtly different semantics from a WITHOUT HOLD cursor David G. Johnston 20:36
Re: My tests show that a WITH HOLD cursor has subtly different semantics from a WITHOUT HOLD cursor Bryn Llewellyn 21:53

April 1, 2023

Thread Author Time
​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account jian he 06:02

April 2, 2023

Thread Author Time
Support logical replication of DDLs Phil Florent 09:55
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 13:21
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Tom Lane 15:23
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 15:40
Re: PostgreSQL Joseph Kennedy 21:21
Very slow queries followed by checkpointer process killed with signal 9 Jason McLaurin 22:25
Re: Very slow queries followed by checkpointer process killed with signal 9 Tom Lane 23:43

April 3, 2023

Thread Author Time
What permissions are needed to drop a column from a table in postgres? Siddharth Jain 00:05
Re: What permissions are needed to drop a column from a table in postgres? David G. Johnston 00:10
Re: Very slow queries followed by checkpointer process killed with signal 9 Jason McLaurin 01:21
Re: Very slow queries followed by checkpointer process killed with signal 9 Tom Lane 01:40
Re: Support logical replication of DDLs Amit Kapila 04:07
Patroni vs pgpool II Inzamam Shafiq 06:33
RE: Cannot terminate backend Arnaud Lesauvage 07:12
Re: PostgreSQL Laurenz Albe 09:45
Re: Question on creating keys on partitioned tables Laurenz Albe 09:53
DEFINER / INVOKER conundrum Dominique Devienne 11:18
Re: Very slow queries followed by checkpointer process killed with signal 9 Joe Conway 12:33
Re: DEFINER / INVOKER conundrum Christoph Moench-Tegeder 12:59
Re: Very slow queries followed by checkpointer process killed with signal 9 Christoph Moench-Tegeder 13:06
Re: Patroni vs pgpool II Ron 13:13
RE: Support logical replication of DDLs Phil Florent 13:25
Re: DEFINER / INVOKER conundrum Erik Wienhold 14:55
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 15:11
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Tom Lane 15:26
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 15:36
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 16:21
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 16:37
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 19:00
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 20:17
Re: Oracle to PostgreSQL Migration Jonny Saxon 20:17
Re: [PATCH] Introduce array_shuffle() and array_sample() Gregory Stark (as CFM) 21:16
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Daniel Gustafsson 21:25
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 21:46
Re: [PATCH] Introduce array_shuffle() and array_sample() Daniel Gustafsson 21:52

April 4, 2023

Thread Author Time
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account jian he 01:50
RE: Support logical replication of DDLs 📎 [email protected] 03:13
RE: Support logical replication of DDLs [email protected] 03:21
Re: DEFINER / INVOKER conundrum walther 05:55
Re: DEFINER / INVOKER conundrum Erik Wienhold 08:46
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 09:01
Re: DEFINER / INVOKER conundrum Dominique Devienne 09:03
Re: Support logical replication of DDLs shveta malik 11:34
Re: Patroni vs pgpool II Jehan-Guillaume de Rorthais 12:25
Re: Patroni vs pgpool II cen 13:40
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 15:12
Re: Patroni vs pgpool II Tatsuo Ishii 23:00

April 5, 2023

Thread Author Time
Re: Patroni vs pgpool II Alexander Kukushkin 05:31
Re: Patroni vs pgpool II Tatsuo Ishii 07:38
Re: Patroni vs pgpool II Inzamam Shafiq 07:41
Re: Patroni vs pgpool II Tatsuo Ishii 07:50
PgOutput Replication Message Format - Differentiate between explicit NULL and Omitted Columns during Insert Pranav Hegde 09:09
Possible old and fixed bug in Postgres? Steve Rogerson 09:18
Re: Possible old and fixed bug in Postgres? Erik Wienhold 10:23
Re: Possible old and fixed bug in Postgres? Tom Lane 14:16
Re: PgOutput Replication Message Format - Differentiate between explicit NULL and Omitted Columns during Insert Tom Lane 14:24
Re: Possible old and fixed bug in Postgres? Steve Rogerson 15:02
Re: Possible old and fixed bug in Postgres? Ian Lawrence Barwick 15:04
Re: Possible old and fixed bug in Postgres? Tom Lane 15:07

April 6, 2023

Thread Author Time
UPSERT in Postgres Louis Tian 06:21
Proposal: Shared Work Mem Area Marco Fortina 10:51
Re: Proposal: Shared Work Mem Area Stephen Frost 12:43
R: Proposal: Shared Work Mem Area Marco Fortina 13:18
Re: Proposal: Shared Work Mem Area Marco Fortina 13:37
Re: R: Proposal: Shared Work Mem Area Stephen Frost 14:34
Re: Patroni vs pgpool II Jehan-Guillaume de Rorthais 15:41
"PANIC: could not open critical system index 2662" - twice Evgeny Morozov 16:41
PostgreSQL Mailing list public archives : search not working ... Imre Samu 17:45
Re: PostgreSQL Mailing list public archives : search not working ... Tom Lane 20:04
Re: UPSERT in Postgres Peter Geoghegan 20:58
Re: UPSERT in Postgres Adrian Klaver 21:00
Re: UPSERT in Postgres Benedict Holland 21:42
Re: PostgreSQL Mailing list public archives : search not working ... Imre Samu 22:27
Re: PostgreSQL Mailing list public archives : search not working ... Stephen Frost 23:47

April 7, 2023

Thread Author Time
Backup schema without data Atul Kumar 00:40
Re: [EXTERNAL]: Re: UPSERT in Postgres Louis Tian 00:49
Re: Backup schema without data Michael Loftis 00:53
Re: Backup schema without data Tom Lane 00:54
Re: Backup schema without data Brent Wood 00:59

Browse Archives

Prev | Next