pgsql-general since 2022-07-25 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

July 25, 2022

Thread Author Time
Re: Was my question inappropriate for postgres? Adrian Klaver 00:04
Re: Was my question inappropriate for postgres? Gavin Flower 00:15
Re: Was my question inappropriate for postgres? Adrian Klaver 00:19
Re: Was my question inappropriate for postgres? Mladen Gogala 00:27
Re: Was my question inappropriate for postgres? Mladen Gogala 00:31
Re: Was my question inappropriate for postgres? Gavin Flower 00:32
Re: Was my question inappropriate for postgres? Gavin Flower 00:35
Re: Was my question inappropriate for postgres? Adrian Klaver 00:43
Re: Was my question inappropriate for postgres? Adrian Klaver 00:49
Re: Was my question inappropriate for postgres? Mladen Gogala 01:14
Re: Was my question inappropriate for postgres? Adrian Klaver 04:36
Re: Support logical replication of DDLs Amit Kapila 06:13
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 07:34
Re: Was my question inappropriate for postgres? Alicja Kucharczyk 08:17
Password reset link / 'less' does not exit in psql version 13.4 Michael J. Baars 10:01
Re: Password reset link / 'less' does not exit in psql version 13.4 Francisco Olarte 11:06
Re: Was my question inappropriate for postgres? Mladen Gogala 12:42
Re: Password reset link / 'less' does not exit in psql version 13.4 Adrian Klaver 14:55
Re: Password reset link / 'less' does not exit in psql version 13.4 Michael J. Baars 16:03
Re: Password reset link / 'less' does not exit in psql version 13.4 Adrian Klaver 16:13
Re: Password reset link / 'less' does not exit in psql version 13.4 Michael J. Baars 16:23
Re: Password reset link / 'less' does not exit in psql version 13.4 Adrian Klaver 16:41
Re: Password reset link / 'less' does not exit in psql version 13.4 Michael J. Baars 16:55
Re: Password reset link / 'less' does not exit in psql version 13.4 Adrian Klaver 17:19
PL/pgSQL: « arr[j].a := v » works fine in PG Version 14.4, fails to compile in Version 11.2. Which version brought the fix? Bryn Llewellyn 17:34
Re: PL/pgSQL: « arr[j].a := v » works fine in PG Version 14.4, fails to compile in Version 11.2. Which version brought the fix? David G. Johnston 17:43
Re: Password reset link / 'less' does not exit in psql version 13.4 Adrian Klaver 17:53
Re: PL/pgSQL: « arr[j].a := v » works fine in PG Version 14.4, fails to compile in Version 11.2. Which version brought the fix? Bryn Llewellyn 18:43
Re: Password reset link / 'less' does not exit in psql version 13.4 Alvaro Herrera 20:40
Streaming Replication, can't select row in backup without specifying collation Kelly Burkhart 22:36
Re: Streaming Replication, can't select row in backup without specifying collation Adrian Klaver 22:43

July 26, 2022

Thread Author Time
[No subject] Rama Krishnan 13:27
Re: Adrian Klaver 15:04
Re: Rama Krishnan 15:15
Re: Adrian Klaver 15:22
Re: Ron 16:29
Re: Adrian Klaver 17:48

July 27, 2022

Thread Author Time
Re: hubert depesz lubaczewski 06:08
monitor health of native logical replication Rory Campbell-Lange 10:52
Feature request: psql --idle Wiwwo Staff 12:49
Re: Feature request: psql --idle Mateusz Henicz 14:06
Re: Feature request: psql --idle Julien Rouhaud 14:07
Performance issue on GIN index with gin_trgm_ops index column Lars Vonk 15:39
Re: Feature request: psql --idle Michael Nolan 15:48
Re: Alicja Kucharczyk 18:19

July 28, 2022

Thread Author Time
RE: Support logical replication of DDLs 📎 [email protected] 03:48
Re: Feature request: psql --idle Wiwwo Staff 09:23
Feature request(?): Proxy User Wiwwo Staff 09:29
xmin of slot is not moving | hot standby feedback sending old xmin. T T 09:35
pg_dump query failed karol.malinowski 10:08
Re: pg_dump query failed David G. Johnston 11:59
Re: Feature request(?): Proxy User Mateusz Henicz 12:17
Re: pg_dump query failed Ron 13:47
Re: pg_dump query failed Tom Lane 13:51
Re: Feature request(?): Proxy User Alicja Kucharczyk 14:02
Re: Was my question inappropriate for postgres? Peter J. Holzer 18:03
Syntax error when combining --set and --command has me stumped Ron 19:40
Re: Syntax error when combining --set and --command has me stumped David G. Johnston 19:47
Re: Syntax error when combining --set and --command has me stumped Ron 19:50
Re: Syntax error when combining --set and --command has me stumped Adrian Klaver 23:36

July 29, 2022

Thread Author Time
« The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Bryn Llewellyn 01:04
Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Christophe Pettus 01:23
Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Bryn Llewellyn 01:49
Re: Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Tom Lane 02:04
Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Christophe Pettus 02:09
Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Bryn Llewellyn 02:57
Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Pavel Stehule 04:25
Re: Syntax error when combining --set and --command has me stumped Gianni Ceccarelli 09:05
Unable to start replica after failover Lahnov, Igor 15:01
Re: « The PL/pgSQL interpreter parses the function's source text and produces an internal binary instruction tree... » Bryn Llewellyn 17:10

July 30, 2022

Thread Author Time
Re: Logical replication versus pglogical on PostgreSQL 14 Christian Barthel 06:05

July 31, 2022

Thread Author Time
Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 22:40
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Rob Sargent 22:42
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 23:53

Aug. 1, 2022

Thread Author Time
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Tom Lane 00:02
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Adrian Klaver 00:04
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 00:25
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 00:27
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 00:30
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Ron 02:38
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Adrian Klaver 03:06
Re: Support logical replication of DDLs Peter Smith 04:18
Is Client connections via ca.crt only possible? Rejo Oommen 08:12
a database can be created but not droped Matthias Apitz 09:22
Re: a database can be created but not droped Julien Rouhaud 09:27
Re: a database can be created but not droped Frank Streitzig 09:30
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 11:11
"set autocommit on" in golang client query Rory Campbell-Lange 13:10
Re: "set autocommit on" in golang client query Guillaume Lelarge 13:18
Inconsistent permission enforcement for schemas Marcin Barczyński 15:48
Re: Inconsistent permission enforcement for schemas Tom Lane 16:49

Aug. 2, 2022

Thread Author Time
RE: Support logical replication of DDLs 📎 [email protected] 03:20
Re: Creation of FK without enforcing constraint for existing data [email protected] 07:14
Re: Creation of FK without enforcing constraint for existing data Gavan Schneider 07:43
Strange collation names ("hu_HU.UTF-8") Durumdara 12:18
Re: Syntax error when combining --set and --command has me stumped Ron 13:07
Re: Strange collation names ("hu_HU.UTF-8") Tom Lane 13:43
ICU is not supported in this build. install from source code. jian he 14:38
Copying records from TABLE_A to TABLE_B (in the same database) Ron 18:37
Re: Copying records from TABLE_A to TABLE_B (in the same database) Rob Sargent 18:41
Re: Copying records from TABLE_A to TABLE_B (in the same database) Adrian Klaver 18:41
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 18:42
Re: Copying records from TABLE_A to TABLE_B (in the same database) Thomas Kellerer 18:51
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 18:54
Re: Copying records from TABLE_A to TABLE_B (in the same database) Rob Sargent 18:59
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 19:01
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 19:02
Re: Copying records from TABLE_A to TABLE_B (in the same database) Rob Sargent 19:08
Re: Copying records from TABLE_A to TABLE_B (in the same database) Peter J. Holzer 19:41

Aug. 3, 2022

Thread Author Time
Re: Strange collation names ("hu_HU.UTF-8") Thomas Munro 02:49
Re: ICU is not supported in this build. install from source code. jian he 08:32
BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas PG Bug reporting form 10:09
Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Juan José Santamaría Flecha 11:13
Why is my table continuousely written? Peter 11:36
"Missing" column in Postgres logical replication update message Kevin Martin 13:50
Re: "Missing" column in Postgres logical replication update message Adrian Klaver 14:47
Re: "Missing" column in Postgres logical replication update message Adrian Klaver 15:12
Why is my table continuousely written? -> XID issue? Peter 15:15
Re: "Missing" column in Postgres logical replication update message Kevin Martin 15:19
Re: "Missing" column in Postgres logical replication update message Tom Lane 15:28
Re: ICU is not supported in this build. install from source code. Daniel Verite 15:46
Re: "Missing" column in Postgres logical replication update message Kevin Martin 16:31
Upgrading from 12.3 to 12.11 zaphod61 17:16
Re: Upgrading from 12.3 to 12.11 David G. Johnston 17:18
Re: Upgrading from 12.3 to 12.11 Christophe Pettus 17:28
Re: Upgrading from 12.3 to 12.11 Adrian Klaver 17:57
Re: Upgrading from 12.3 to 12.11 zaphod61 18:44
Re: Upgrading from 12.3 to 12.11 Adrian Klaver 18:51
Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Poornima Venkatesan 19:17
Re: Upgrading from 12.3 to 12.11 Adrian Klaver 19:42
Re: Upgrading from 12.3 to 12.11 zaphod61 19:58
Re: Is Client connections via ca.crt only possible? Thomas Guyot 21:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 22:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Tom Lane 23:05

Aug. 4, 2022

Thread Author Time
Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Ron 00:30
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Adrian Klaver 01:02
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Ron 01:13
Re: Is Client connections via ca.crt only possible? Rejo Oommen 01:37
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Julien Rouhaud 02:13
Re: Is Client connections via ca.crt only possible? Thomas Guyot 02:22
RE: Support logical replication of DDLs 📎 [email protected] 02:51
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Adrian Klaver 04:45
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 05:46
How to choose new master from slaves.? Sacheen Birhade 07:43
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Francisco Olarte 07:51
Re: Unable to start replica after failover Kyotaro Horiguchi 08:30
Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Mateusz Henicz 08:32
Re: Behavior of identity columns [email protected] 08:52
Index only scans for expressional indices when querying for the expression Danny Shemesh 09:59
Re: How to choose new master from slaves.? Ron 10:22
Re: Behavior of identity columns Francisco Olarte 10:32
Re: Index only scans for expressional indices when querying for the expression David G. Johnston 12:28
Re: Index only scans for expressional indices when querying for the expression Danny Shemesh 12:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 12:34
Re: Index only scans for expressional indices when querying for the expression Tom Lane 13:38
Allow user to connect to replicas only Wiwwo Staff 13:42
Re: Allow user to connect to replicas only hubert depesz lubaczewski 13:56
Re: Index only scans for expressional indices when querying for the expression Danny Shemesh 14:03
Re: Index only scans for expressional indices when querying for the expression Tom Lane 14:17
follower never to become master Marco Lechner 15:44
sequence id overflow ERROR using timescaledb abrahim abrahao 20:47
Re: PostgreSQL 14.4 ERROR: out of memory issues Joe Conway 21:15
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Jan Wieck 23:57

Aug. 5, 2022

Thread Author Time
Re: sequence id overflow ERROR using timescaledb Julien Rouhaud 02:37
Re: Support logical replication of DDLs Peter Smith 06:03
Expr. extended stats are skipped with equality operator Danny Shemesh 09:50
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 15:47

Aug. 6, 2022

Thread Author Time
Re: PostgreSQL 14.4 ERROR: out of memory issues Peter J. Holzer 08:25
Re: How to choose new master from slaves.? Peter J. Holzer 08:40
Re: How to choose new master from slaves.? Ron 20:06
Re: How to choose new master from slaves.? Peter J. Holzer 20:45
Re: How to choose new master from slaves.? Ron 21:13

Aug. 7, 2022

Thread Author Time
Question about locking Frank Millman 05:30
Re: Question about locking Ron 05:54
Re: Question about locking Frank Millman 06:22
Re: Expr. extended stats are skipped with equality operator Tomas Vondra 17:23
Re: Expr. extended stats are skipped with equality operator Tom Lane 17:28
Re: Expr. extended stats are skipped with equality operator Tomas Vondra 17:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 19:47

Aug. 8, 2022

Thread Author Time
tablesample clause doesnt support to be applied to subquery. Wind 07:52
Re: tablesample clause doesnt support to be applied to subquery. rob stone 08:05
RE: 20220722-pg_dump: error: invalid number of parents 0 for table Techsupport 09:29
pg_restore remap schema Fabrice Chapuis 16:27
Re: pg_restore remap schema Guillaume Lelarge 18:16
Re: pg_restore remap schema Tom Lane 18:22
Re: pg_restore remap schema Marcos Pegoraro 19:26
Re: Support logical replication of DDLs Zheng Li 20:22
Re: 20220722-pg_dump: error: invalid number of parents 0 for table Saul Perdomo 23:55

Aug. 9, 2022

Thread Author Time
Re: pg_restore remap schema Fabrice Chapuis 06:39
Creating A GIN index on JSONB column (large database) Taylor Smith 14:04
Re: Creating A GIN index on JSONB column (large database) Rob Sargent 14:39
Re: Creating A GIN index on JSONB column (large database) Taylor Smith 14:45
Re: Creating A GIN index on JSONB column (large database) Rob Sargent 14:50
Re: Creating A GIN index on JSONB column (large database) Taylor Smith 15:29
Re: Creating A GIN index on JSONB column (large database) Ron 16:46
Re: Creating A GIN index on JSONB column (large database) Ron 16:53

Aug. 10, 2022

Thread Author Time
index row size 2720 exceeds btree version 4 Daulat 04:57
pkg: two postgresql clients ml 07:25
Re: index row size 2720 exceeds btree version 4 Albrecht Dreß 08:53
Re: pkg: two postgresql clients Peter 10:15

Browse Archives

Prev | Next