pgsql-general since 2023-03-19 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

March 19, 2023

Thread Author Time
Re: Getting error while upgrading postgres from version 12 to 13 shashidhar Reddy 02:26
Re: Getting error while upgrading postgres from version 12 to 13 Adrian Klaver 04:15
Re: Getting error while upgrading postgres from version 12 to 13 David G. Johnston 05:59
Re: Properly handle OOM death? Joe Conway 13:41

March 20, 2023

Thread Author Time
Re[2]: Getting error while upgrading postgres from version 12 to 13 abdulsayeed24 05:37
RE: Support logical replication of DDLs 📎 [email protected] 09:17
NULL pg_database.datacl Dominique Devienne 10:52
Re: pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 11:58
Re: NULL pg_database.datacl Erik Wienhold 12:18
Logical replication fails when adding multiple replicas Will Roper 12:46
Re: NULL pg_database.datacl Dominique Devienne 12:50
Oracle to PostgreSQL Migration Inzamam Shafiq 12:57
Re: NULL pg_database.datacl Erik Wienhold 13:18
Re: NULL pg_database.datacl Dominique Devienne 13:41
Re: pg_upgrade Only the install user can be defined in the new cluster David G. Johnston 13:57
Re: pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 14:02
Re: pg_upgrade Only the install user can be defined in the new cluster David G. Johnston 14:08
Re: Oracle to PostgreSQL Migration Ron Johnson 14:15
Re: pg_upgrade Only the install user can be defined in the new cluster Thorsten Glaser 14:20
Re: Oracle to PostgreSQL Migration Thomas Kellerer 14:21
Re: Oracle to PostgreSQL Migration Jim Mlodgenski 14:24
Schemas and Search Path DAVID ROTH 16:07
Schema/user/role DAVID ROTH 16:12
Re: Schemas and Search Path Pavel Stehule 16:14
Re: Schemas and Search Path Ron Johnson 16:54
Re: Schema/user/role David G. Johnston 17:22
Re: Schema/user/role Bryn Llewellyn 18:57
Re: [PATCH] Introduce array_shuffle() and array_sample() Gregory Stark (as CFM) 19:34
Re: Schema/user/role Ron Johnson 19:35
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 20:46
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Adrian Klaver 22:38

March 21, 2023

Thread Author Time
Re: Oracle to PostgreSQL Migration Inzamam Shafiq 05:34
Re: Oracle to PostgreSQL Migration Inzamam Shafiq 05:36
Missing RHEL8 RPMS dev dyskolos 06:59
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Laurenz Albe 07:55
Re: Re[2]: Getting error while upgrading postgres from version 12 to 13 shashidhar Reddy 10:29
Re: Oracle to PostgreSQL Migration Umair Shahid 10:48
Re: Getting error while upgrading postgres from version 12 to 13 Adrian Klaver 14:39
Re: Getting error while upgrading postgres from version 12 to 13 shashidhar Reddy 15:13
Re: Oracle to PostgreSQL Migration Marc Millas 15:42
Re: Getting error while upgrading postgres from version 12 to 13 Adrian Klaver 15:43
Re: Re[2]: Getting error while upgrading postgres from version 12 to 13 Geoff Winkless 16:06
Re: Re[2]: Getting error while upgrading postgres from version 12 to 13 Geoff Winkless 16:11
Is there psql cluster or replication Vince McMahon 23:46
Re: Is there psql cluster or replication Ian Lawrence Barwick 23:52

March 22, 2023

Thread Author Time
RE: Logical replication fails when adding multiple replicas [email protected] 01:49
Re: Oracle to PostgreSQL Migration paramjib baruah 05:27
Postgresql professional certification MS A 07:05
Re: Logical replication fails when adding multiple replicas Will Roper 09:25
For temporary tables; truncate vs on commit delete all Jim Vanns 11:59
Re: For temporary tables; truncate vs on commit delete all Laurenz Albe 13:55
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 19:09
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Laurenz Albe 22:27
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Adrian Klaver 22:45

March 23, 2023

Thread Author Time
Re: Support logical replication of DDLs 📎 Ajin Cherian 03:52
Re: Logical replication fails when adding multiple replicas Kyotaro Horiguchi 08:17
Convert pg_constraint.conkey array to same-order array of column names Dominique Devienne 11:12
Re: Support logical replication of DDLs vignesh C 13:36
Re: Postgresql professional certification Magnus Hagander 14:02
Re: Convert pg_constraint.conkey array to same-order array of column names Adrian Klaver 15:20
How to install vacuumlo on a client? Zwettler Markus (OIZ) 16:54
Re: How to install vacuumlo on a client? Adrian Klaver 16:59
Re: Logical replication fails when adding multiple replicas Will Roper 17:43
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 19:49

March 24, 2023

Thread Author Time
Re: Oracle to PostgreSQL Migration Inzamam Shafiq 08:00
Re: Convert pg_constraint.conkey array to same-order array of column names Dominique Devienne 10:28
Re: Convert pg_constraint.conkey array to same-order array of column names Alvaro Herrera 10:51
PostgreSQL vs MariaDB Inzamam Shafiq 11:07
Re: Convert pg_constraint.conkey array to same-order array of column names Dominique Devienne 12:07
Re: Oracle to PostgreSQL Migration Christophe Pettus 14:02
Re: PostgreSQL vs MariaDB Ben Chobot 14:08
Re: PostgreSQL vs MariaDB Jeffrey Walton 14:49
Re: PostgreSQL vs MariaDB Dominique Devienne 15:41
Re: PostgreSQL vs MariaDB Sumit Sengupta 16:17
Re: PostgreSQL vs MariaDB Thomas Kellerer 16:27
Re: Convert pg_constraint.conkey array to same-order array of column names Adrian Klaver 16:40
Re: Convert pg_constraint.conkey array to same-order array of column names Dominique Devienne 16:44
Re: Convert pg_constraint.conkey array to same-order array of column names Adrian Klaver 17:22
Re: PostgreSQL vs MariaDB Miles Elam 21:18
psql \copy with multi-line query Rob Sargent 23:04
Re: psql \copy with multi-line query David G. Johnston 23:14
Re: psql \copy with multi-line query Rob Sargent 23:25

March 25, 2023

Thread Author Time
Re: PostgreSQL vs MariaDB Inzamam Shafiq 06:15
Re: PostgreSQL vs MariaDB Ron 06:43
Re: PostgreSQL vs MariaDB Achilleas Mantzios 15:44
Binding Postgres to port 0 for testing Markus Pilman 17:01
Re: Binding Postgres to port 0 for testing Thorsten Glaser 18:03
Re: Binding Postgres to port 0 for testing Erik Wienhold 18:10
Re: Binding Postgres to port 0 for testing Markus Pilman 19:10
Re: Binding Postgres to port 0 for testing Erik Wienhold 21:09

March 26, 2023

Thread Author Time
Re: Support logical replication of DDLs vignesh C 12:38
Re: Support logical replication of DDLs 📎 vignesh C 14:06
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 20:16
Re: Support logical replication of DDLs Tom Lane 21:21

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

Browse Archives

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