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

July 20, 2022

Thread Author Time
Re: postgis Marc Millas 03:07
Batch process Rama Krishnan 05:08
Re: Migrating from Oracle - Implicit Casting Issue Karthik K L V 05:42
Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence Sebastien Flaesch 06:44
Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence Thomas Kellerer 06:56
Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence Francisco Olarte 07:09
RE: Proposed Translations of Updated Code of Conduct Policy Lucie Šimečková 08:01
Re: postgis Ron 08:25
Re: Batch process Ron 08:28
Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence Sebastien Flaesch 09:15
operator does not exist: text = bytea Karthik K L V 09:32
Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence Karsten Hilbert 09:33
Re: operator does not exist: text = bytea Karthik K L V 09:48
Re: operator does not exist: text = bytea hubert depesz lubaczewski 11:59
Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity Achilleas Mantzios 12:27
RE: Support logical replication of DDLs 📎 [email protected] 12:28
Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity Achilleas Mantzios 12:28
Re: operator does not exist: text = bytea Karthik K L V 12:59
Paging through table one row at a ttime H 13:09
Re: postgis Marc Millas 13:26
Re: postgis Ron 13:51
Re: operator does not exist: text = bytea Tom Lane 13:59
Re: postgis Marc Millas 14:07
Re: postgis jian he 14:16
Re: postgis Marc Millas 14:21
Re: Batch process Adrian Klaver 14:52
Re: postgis David G. Johnston 14:57
Re: Batch process Adrian Klaver 15:07
Re: Batch process Rama Krishnan 15:26
Re: Batch process Rob Sargent 15:30
Re: postgis Adrian Klaver 15:36
Re: postgis David G. Johnston 15:55
Re: postgis Adrian Klaver 16:14
Re: postgis Adrian Klaver 16:16
Re: postgis Imre Samu 16:21
Re: postgis David G. Johnston 16:21
Re: postgis David G. Johnston 16:31
Re: postgis Imre Samu 17:26
Re: Batch process Adrian Klaver 17:39
plan for function returning table combined with condition Thierry Henrio 17:51
Re: Batch process Ron 18:16
Re: Batch process Adrian Klaver 18:32
Re: plan for function returning table combined with condition Tom Lane 18:39
Re: Batch process Ron 18:56
Re: Batch process Adrian Klaver 19:03
Re: Patroni & PostgreSQL issue Abdul Sayeed 19:19
Re: postgis Marc Millas 21:33
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 22:26

July 21, 2022

Thread Author Time
RE: [External]Re: Patroni & PostgreSQL issue Menon, Deepak (Deepak) 04:05
Unable to archive logs in standby server Meera Nair 07:16
Re: More than one Cluster on single server (single instance) Daulat 08:15
Re: plan for function returning table combined with condition Thierry Henrio 08:33
Re: [PATCH] Introduce array_shuffle() and array_sample() Dean Rasheed 08:41
Re: More than one Cluster on single server (single instance) Daulat 10:01
Re: [PATCH] Introduce array_shuffle() and array_sample() Martin Kalcher 11:15
Re: [PATCH] Introduce array_shuffle() and array_sample() Dean Rasheed 12:25
Re: Unable to archive logs in standby server Guillaume Lelarge 12:31
Re: [PATCH] Introduce array_shuffle() and array_sample() Martin Kalcher 15:43
Unable to archive logs in standby server Meera Nair 16:42
FK Constraint sort order with pg_dump 📎 Christian Barthel 17:25
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 17:29
Re: FK Constraint sort order with pg_dump Adrian Klaver 17:49
Re: FK Constraint sort order with pg_dump David G. Johnston 17:54
Re: FK Constraint sort order with pg_dump Christian Barthel 17:59
Re: FK Constraint sort order with pg_dump Adrian Klaver 18:36
Re: FK Constraint sort order with pg_dump 📎 Tom Lane 20:46
Re: could not link file in wal restore lines Zsolt Ero 22:28

July 22, 2022

Thread Author Time
Is psqlodbc_13_02 compatible to M365? Taka Taka 00:40
Re: [PATCH] Introduce array_shuffle() and array_sample() Dean Rasheed 07:59
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 09:31
Re: [PATCH] Introduce array_shuffle() and array_sample() Dean Rasheed 11:04
Re: Paging through table one row at a ttime H 12:28
Re: Paging through table one row at a ttime Rob Sargent 13:05
Re: Paging through table one row at a ttime Bruce Momjian 13:14
Re: Paging through table one row at a ttime H 14:33
Re: Paging through table one row at a ttime Bruce Momjian 14:39
How does postgres sort large strings? Sergey Burladyan 14:46
20220722-pg_dump: error: invalid number of parents 0 for table Techsupport 15:20
Re: 20220722-pg_dump: error: invalid number of parents 0 for table Adrian Klaver 15:52
Re: [PATCH] Introduce array_shuffle() and array_sample() Joe Conway 16:49
Re: How does postgres sort large strings? Francisco Olarte 17:31
Re: Support logical replication of DDLs 📎 Zheng Li 21:18

July 23, 2022

Thread Author Time
RE: 20220722-pg_dump: error: invalid number of parents 0 for table Techsupport 04:27
Logical replication versus pglogical on PostgreSQL 14 Rory Campbell-Lange 09:09
Strange behavior between timestamp and date comparison Ludwig Isaac Lim 10:04
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 12:20
Re: 20220722-pg_dump: error: invalid number of parents 0 for table Adrian Klaver 14:54
Re: 20220722-pg_dump: error: invalid number of parents 0 for table Adrian Klaver 15:33
Re: Support logical replication of DDLs Joe Conway 15:33
Re: Support logical replication of DDLs Zheng Li 16:23

July 24, 2022

Thread Author Time
Logging the query executed on the server Igor Korot 05:25
Re: Logging the query executed on the server Steve Baldwin 05:51
Re: Logging the query executed on the server Igor Korot 06:29
Re: Logging the query executed on the server Steve Baldwin 07:13
Queries in another user's tables xavier 07:37
Re: [PATCH] Introduce array_shuffle() and array_sample() Fabien COELHO 08:15
Re: Queries in another user's tables Pavel Stehule 09:19
Re: Strange behavior between timestamp and date comparison Rory Campbell-Lange 15:29
Re: Strange behavior between timestamp and date comparison Adrian Klaver 15:33
Re: Queries in another user's tables Adrian Klaver 16:29
Re: Queries in another user's tables (SOLVED) xavier 16:50
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 19:29
Re: [PATCH] Introduce array_shuffle() and array_sample() Fabien COELHO 19:42
Was my question inappropriate for postgres? Taka Taka 23:56

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

Browse Archives

Prev | Next