pgsql-general since 2023-07-10 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 10, 2023

Thread	Author	Time
Re: INSERT UNIQUE row?	Adrian Klaver	00:04
Re: INSERT UNIQUE row?	Adrian Klaver	00:06
Re: INSERT UNIQUE row?	pf	02:25
Re: INSERT UNIQUE row?	pf	02:29
RE: Support logical replication of DDLs	Zhijie Hou (Fujitsu)	06:04
Re: Query regarding managing Replication	Ashok Patil	07:41
Re: INSERT UNIQUE row?	Erik Wienhold	07:43
Re: Query regarding managing Replication	Julien Rouhaud	08:02
search_path for replica-mode	André Kutepow	08:27
search_path for replica-mode	André Kutepow	10:21
Re: search_path for replica-mode	David G. Johnston	13:11
what causes new temp schemas to be created	Ted Toth	14:18
Re: what causes new temp schemas to be created	David G. Johnston	14:20
Re: what causes new temp schemas to be created	Ron	14:28
Re: Moving data from huge table slow, min() query on indexed column taking 38s	Dimitrios Apostolou	15:58
Prevent LSN pointer advancement in case of cursor exception (wal2json + pg_logical_slot_get_changes)	Mertez	16:11
Re: what causes new temp schemas to be created	Ted Toth	16:19
Re: what causes new temp schemas to be created	David G. Johnston	16:22
Re: what causes new temp schemas to be created	Ted Toth	17:03
Re: what causes new temp schemas to be created	Tom Lane	17:08
Re: Is anyone using db_user_namespace?	Nathan Bossart	17:45
Need Help On Upgrade	Johnathan Tiamoh	18:15
Trigger Function question	DAVID ROTH	18:20
Re: Trigger Function question	Christophe Pettus	18:23
Re: Trigger Function question	DAVID ROTH	18:29
Re: Trigger Function question	Christophe Pettus	18:31
Re: Trigger Function question	DAVID ROTH	18:37
Re: Trigger Function question	Christophe Pettus	18:38
Re: Trigger Function question	DAVID ROTH	18:42
Re: Trigger Function question	DAVID ROTH	18:46
Re: Trigger Function question	Marcos Pegoraro	18:51
Re: Trigger Function question	Christophe Pettus	18:52
Using "exit" to bring "goto" functionality.	Bryn Llewellyn	18:54
Re: Using "exit" to bring "goto" functionality.	Christophe Pettus	18:58
Re: Using "exit" to bring "goto" functionality.	DAVID ROTH	19:08
Re: Using "exit" to bring "goto" functionality.	Adrian Klaver	19:29
Re: Need Help On Upgrade	Adrian Klaver	19:38
Re: Need Help On Upgrade	Adrian Klaver	20:00
Re: Need Help On Upgrade	Johnathan Tiamoh	20:02
Re: Need Help On Upgrade	Johnathan Tiamoh	20:20
Re: Using "exit" to bring "goto" functionality.	Bryn Llewellyn	20:26
Re: Using "exit" to bring "goto" functionality.	Pavel Stehule	20:52
Re: Using "exit" to bring "goto" functionality.	Bryn Llewellyn	21:17
Re: Need Help On Upgrade	Adrian Klaver	22:36

July 11, 2023

Thread	Author	Time
Re: Need Help On Upgrade	Johnathan Tiamoh	00:38
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"	Kyotaro Horiguchi	01:14
Re: Is anyone using db_user_namespace?	Ian Lawrence Barwick	01:24
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"	Tom Lane	01:28
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"	Kyotaro Horiguchi	01:29
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"	David G. Johnston	01:59
Re: Need Help On Upgrade	Laurenz Albe	03:45
Re: pgbouncer best practices	Gurjeet Singh	06:47
Re: how to return data from insert into ... on conflict ... returning ... into	Gurjeet Singh	07:27
Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"	Kyotaro Horiguchi	07:30
BI Reports and Postgres	KK CHN	08:50
Re: search_path for replica-mode	André Kutepow	08:50
RE: Support logical replication of DDLs 📎	Zhijie Hou (Fujitsu)	11:01
Re: Need Help On Upgrade	Johnathan Tiamoh	14:16
Re: Need Help On Upgrade	Adrian Klaver	15:46
Re: Need Help On Upgrade	Johnathan Tiamoh	15:53
Re: Need Help On Upgrade	Adrian Klaver	16:19
Re: BI Reports and Postgres	Gurjeet Singh	17:54
Re: Moving data from huge table slow, min() query on indexed column taking 38s	Lorusso Domenico	19:31
Re: How to add function schema in search_path in option definitio	Lorusso Domenico	19:35
Re: How to add function schema in search_path in option definitio	Adrian Klaver	19:41
Re: Trigger Function question	Lorusso Domenico	19:41
Re: How to add function schema in search_path in option definitio	Lorusso Domenico	19:47
Re: How to add function schema in search_path in option definitio	Adrian Klaver	20:17
Re: How to add function schema in search_path in option definitio	David G. Johnston	20:50
Re: Need Help On Upgrade	Johnathan Tiamoh	21:45
Re: Need Help On Upgrade	Adrian Klaver	23:32
Re: Is anyone using db_user_namespace?	Nathan Bossart	23:39

July 12, 2023

Thread	Author	Time
Re: Need Help On Upgrade	Benedict Holland	01:31
psql -af > out, is possible to also have raise notice, raise info part.	jian he	03:52
Re: psql -af > out, is possible to also have raise notice, raise info part.	David G. Johnston	04:05
Re: psql -af > out, is possible to also have raise notice, raise info part.	jian he	04:27
Re: Need Help On Upgrade	Johnathan Tiamoh	04:39
[Beginner Question] Will the vxid replace xid?	Wen Yi	07:50
RE: How to add function schema in search_path in option definitio	Joel Rabinovitch	13:28
Re: Requesting Information for GSSAPI	Stephen Frost	18:54
Reset Postgresql users password	Johnathan Tiamoh	19:28
Re: Reset Postgresql users password	Gianni Ceccarelli	19:34
Re: Reset Postgresql users password	Mateusz Henicz	19:42
Re: Reset Postgresql users password	Gurjeet Singh	20:16
Re: Reset Postgresql users password	Johnathan Tiamoh	20:25
Re: Reset Postgresql users password	David G. Johnston	20:35
Re: How to add function schema in search_path in option definitio	Lorusso Domenico	20:45

July 13, 2023

Thread	Author	Time
create a temp table in SPI	黄宁	05:12
EDB to Postgres Migration	KK CHN	06:28
pg_restore mostly idle on restoring a large number of tables	Boris Sagadin	07:41
Re: EDB to Postgres Migration	Laurenz Albe	09:39
Re: create a temp table in SPI	Laurenz Albe	09:48
JOB | DBA (Tokyo)	James Tobin	10:23
Problem perhaps after upgrading to pgadmin4 7.4	Carl Erik Eriksson	11:20
Re: Problem perhaps after upgrading to pgadmin4 7.4	hubert depesz lubaczewski	11:52
Re: Problem perhaps after upgrading to pgadmin4 7.4	Carl Erik Eriksson	11:58
Re: Problem perhaps after upgrading to pgadmin4 7.4	Carl Erik Eriksson	13:48
Re: Problem perhaps after upgrading to pgadmin4 7.4	Erik Wienhold	17:53
Re: "PANIC: could not open critical system index 2662" - twice	Andres Freund	20:50

July 14, 2023

Thread	Author	Time
Re: Support logical replication of DDLs	Amit Kapila	10:33

July 15, 2023

Thread	Author	Time
Fwd: error in the example given for numeric data types	Priyank Rajvansh	06:38
Re: error in the example given for numeric data types	jian he	07:16
Re: error in the example given for numeric data types	Tom Lane	13:16
Installation Issue	Baskar Muthu	14:30
Re: pg_restore mostly idle on restoring a large number of tables	Ron	14:51
Rocky Linux 9 and postgres10	Daniel Gallo	16:37
Re: Rocky Linux 9 and postgres10	David G. Johnston	16:45
Re: Rocky Linux 9 and postgres10	Adrian Klaver	17:01
Re: error in the example given for numeric data types	Priyank Rajvansh	17:50
Re: pg_restore mostly idle on restoring a large number of tables	Tom Lane	17:56
Re: error in the example given for numeric data types	David G. Johnston	18:09
Re: Toasted column values during replication	Chandy G	20:42
Re: Rocky Linux 9 and postgres10	Daniel Gallo	21:11
Re: Fwd: error in the example given for numeric data types	Peter J. Holzer	21:19

July 16, 2023

Thread	Author	Time
Re: Installation Issue	Adrian Klaver	15:35

July 17, 2023

Thread	Author	Time
Re: create a temp table in SPI	黄宁	02:12
Re: Problem perhaps after upgrading to pgadmin4 7.4	Ron	02:23
Re: Rocky Linux 9 and postgres10	Ron	02:27
Re: Reset Postgresql users password	Ron	02:28
[Beginner Question]What is query jumbling?	Wen Yi	03:23
Re: Reset Postgresql users password	Wen Yi	03:27
Postgrsql blocked for more than 120 s	Bogdan Siara	05:40
Re: Reset Postgresql users password	Chris Travers	07:52
Query take a long time and use no index	basti	09:13
Re: [Beginner Question]What is query jumbling?	Tomas Vondra	10:59
Re: Query take a long time and use no index	Tomas Vondra	11:20
Re: Query take a long time and use no index	Tomas Vondra	11:21
Re: Query take a long time and use no index	Ron	13:03
How to grant read only functions execute permission to read only user	Yi Sun	14:11
Re: Installation Issue	Adrian Klaver	14:30
Re: How to grant read only functions execute permission to read only user	Tomas Vondra	15:43
Re: How to grant read only functions execute permission to read only user	David G. Johnston	15:49
Re: Installation Issue	Erik Wienhold	16:31
Re: Installation Issue	Carl Erik Eriksson	16:34
Re: Query take a long time and use no index	basti	18:19
Re: Is anyone using db_user_namespace?	Nathan Bossart	18:50
backup_manifest rename to backup_manifest.old after successful postgres start up	Gert Cuykens	23:53

July 18, 2023

Thread	Author	Time
Re: Support logical replication of DDLs	Masahiko Sawada	05:28
Re: Support logical replication of DDLs	Michael Paquier	05:37
suggestion about time based partitioning and hibernate	Luca Ferrari	06:18
Re: suggestion about time based partitioning and hibernate	Ron	06:47
RE: Support logical replication of DDLs 📎	Zhijie Hou (Fujitsu)	07:09
RE: suggestion about time based partitioning and hibernate	n.kobzarev	07:32
fsync data directory after DB crash	Pandora	08:50
Upgrade Failure	Johnathan Tiamoh	10:02
Re: Upgrade Failure	Laurenz Albe	10:12
Re: Upgrade Failure	Johnathan Tiamoh	10:14
Re: Upgrade Failure	Daniel Gustafsson	10:14
Re: Upgrade Failure	Johnathan Tiamoh	10:26
Re: Upgrade Failure	Daniel Gustafsson	10:38
Re: Query take a long time and use no index	David Rowley	11:28
Re: Query take a long time and use no index	David Rowley	11:34
Re: Upgrade Failure	Ron	14:44
Effects of dropping a large table	Devin Ivy	17:58
Re: Effects of dropping a large table	Rob Sargent	19:41

July 19, 2023

Thread	Author	Time
Re: fsync data directory after DB crash	Michael Paquier	00:41
Re: fsync data directory after DB crash	Thomas Munro	01:37
回复： fsync data directory after DB crash	Pandora	02:09
Fwd: Regarding Installation of PostgreSQL 📎	Sahil Sojitra	03:14
Pgoutput not capturing the generated columns	Rajendra Kumar Dangwal	03:53
Re: Effects of dropping a large table	Laurenz Albe	08:17
Need help setting up Windows authentication SSPI user mapping	Haidong Huang	14:56
Re: Fwd: Regarding Installation of PostgreSQL	Adrian Klaver	15:36
Re: suggestion about time based partitioning and hibernate	Alvaro Herrera	16:45
Re: Effects of dropping a large table	David Rowley	23:15
Re: Effects of dropping a large table	Rob Sargent	23:33

July 20, 2023

Thread	Author	Time
Nu-B here	Amn Ojee Uw	00:36
My 1st JDBC and PostgreSQL	Amn Ojee Uw	00:37
Re: Nu-B here	Tom Lane	00:54
Re: Nu-B here	Maciek Sakrejda	00:55
Re: My 1st JDBC and PostgreSQL	Tom Lane	00:58
Re: My 1st JDBC and PostgreSQL	Chuck Davis	01:11
Re: My 1st JDBC and PostgreSQL	Jeffrey Walton	01:52
Postgres SQL	Anthony Apollis	05:40
Re: Nu-B here	Alban Hertroys	06:32
How to improve the performance of my SQL query？	gzh	07:09
Re: Postgrsql blocked for more than 120 s	Bogdan Siara	07:38
Re: Postgres SQL	Maciek Sakrejda	08:00
Re: How to improve the performance of my SQL query？	Erik Wienhold	08:07
Re: How to improve the performance of my SQL query？	Peter J. Holzer	09:44
TSQL To Postgres - Unpivot/Union All	Anthony Apollis	11:29
Re:Re: How to improve the performance of my SQL query？	gzh	11:36
Re: How to improve the performance of my SQL query？	Laurenz Albe	11:58
Fwd: TSQL To Postgres - Unpivot/Union All	Anthony Apollis	12:17
Re: TSQL To Postgres - Unpivot/Union All	David G. Johnston	12:48
Re: TSQL To Postgres - Unpivot/Union All	Geoff Winkless	13:58
Re: How to improve the performance of my SQL query？	gzh	14:14
Fwd: TSQL To Postgres - Unpivot/Union All 📎	Anthony Apollis	14:28
Re: Nu-B here	Adrian Klaver	14:41
Re: How to improve the performance of my SQL query？	Laurenz Albe	14:48
Re: TSQL To Postgres - Unpivot/Union All	Geoff Winkless	14:51
Re: Fwd: TSQL To Postgres - Unpivot/Union All	Thomas Kellerer	15:07
Re: My 1st JDBC and PostgreSQL	Adrian Klaver	15:18
Re: Re: How to improve the performance of my SQL query？	jian he	15:20
Re: My 1st JDBC and PostgreSQL	Adrian Klaver	15:21
Re: suggestion about time based partitioning and hibernate	Luca Ferrari	15:31
Re: TSQL To Postgres - Unpivot/Union All	Anthony Apollis	15:47
Re: My 1st JDBC and PostgreSQL	Chuck Davis	16:44
Re: suggestion about time based partitioning and hibernate	Ron	16:52
pg_upgradecluster fails if pg_hba.conf contains "@file" entries	Albrecht Dreß	17:18

Browse Archives

Prev | Next