[go: up one dir, main page]

pgsql-general - July 2023

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 1, 2023

Thread Author Time
Re: psql and pgpass.conf on Windows Kirk Wolak 05:40
Re: psql and pgpass.conf on Windows Julien Rouhaud 06:06
[Beginner Question] How to print the call link graph? Wen Yi 07:10
Re: [Beginner Question] How to print the call link graph? Ron 15:26
Re: [Beginner Question] How to print the call link graph? Julien Rouhaud 16:08
Re: [EXT] Re: [Beginner Question] How to print the call link graph? Garfield Lewis 17:05
Re: [Beginner Question] How to print the call link graph? Erik Wienhold 19:44
Re: Adding SHOW CREATE TABLE Kirk Wolak 21:41

July 2, 2023

Thread Author Time
Re: [Beginner Question] How to print the call link graph? Wen Yi 11:06
[Beginner Question]What's the use of ResTarget? Wen Yi 11:19
Re: need explanation about an explain plan David Rowley 22:06
Re: need explanation about an explain plan Umut TEKİN 23:12

July 3, 2023

Thread Author Time
Re: Query regarding managing Replication Ashok Patil 08:37
Re: Query regarding managing Replication Julien Rouhaud 09:36
Re: psql and pgpass.conf on Windows Kirk Wolak 15:10

July 4, 2023

Thread Author Time
psql -c command parse "select $$hello$$" failed jian he 12:21
Re: psql -c command parse "select $$hello$$" failed Julien Rouhaud 12:36
Re: psql -c command parse "select $$hello$$" failed Erik Wienhold 12:45

July 5, 2023

Thread Author Time
Strange behaviour on function Lorusso Domenico 12:23
Re: Strange behaviour on function Erik Wienhold 13:53
Re: Strange behaviour on function Adrian Klaver 15:16
Re: Strange behaviour on function Erik Wienhold 15:33
Re: Strange behaviour on function Lorusso Domenico 19:56
Re: Strange behaviour on function Lorusso Domenico 20:03

July 6, 2023

Thread Author Time
Need help aarthi rajagopal 04:52
function to_char(unknown) is not unique at character 8 gzh 09:19
Re: function to_char(unknown) is not unique at character 8 Pavel Stehule 11:21
Re: function to_char(unknown) is not unique at character 8 Erik Wienhold 11:36
Re: function to_char(unknown) is not unique at character 8 gzh 11:38
Re: function to_char(unknown) is not unique at character 8 Pavel Stehule 11:54
Logical replication restarts Paula Berenguel 12:34
Re: Logical replication restarts Mateusz Henicz 12:44
Re: function to_char(unknown) is not unique at character 8 Ron 14:01
Re: function to_char(unknown) is not unique at character 8 Tom Lane 14:07
Re: function to_char(unknown) is not unique at character 8 gzh 14:15
Re: function to_char(unknown) is not unique at character 8 Pavel Stehule 14:16
Re: function to_char(unknown) is not unique at character 8 gzh 14:28
Re: function to_char(unknown) is not unique at character 8 Pavel Stehule 14:42
Moving data from huge table slow, min() query on indexed column taking 38s Dimitrios Apostolou 15:00
Re: Moving data from huge table slow, min() query on indexed column taking 38s Dimitrios Apostolou 16:11
Re: Need help Adrian Klaver 19:29
Re: Moving data from huge table slow, min() query on indexed column taking 38s Lorusso Domenico 21:42
[bug]? insert returning composite type fails Lorusso Domenico 21:52
Re: [bug]? insert returning composite type fails David G. Johnston 22:04
Re: [bug]? insert returning composite type fails Adrian Klaver 23:20

July 7, 2023

Thread Author Time
Re: function to_char(unknown) is not unique at character 8 gzh 02:20
Re: [bug]? insert returning composite type fails Lorusso Domenico 11:03
temp table security labels Ted Toth 12:43
Re: temp table security labels Ted Toth 13:05
track_activity_query_size max practical size? Ron 14:42
Re: track_activity_query_size max practical size? Adrian Klaver 14:51
Re: track_activity_query_size max practical size? Adrian Klaver 14:55
Re: track_activity_query_size max practical size? Ron 14:56
Re: track_activity_query_size max practical size? Ron 14:58
Re: track_activity_query_size max practical size? Adrian Klaver 15:13
Re: track_activity_query_size max practical size? Ron 15:27
Re: temp table security labels Ted Toth 15:44
Re: temp table security labels Ted Toth 15:52
Re: track_activity_query_size max practical size? Adrian Klaver 15:53
pgbouncer best practices Rita 16:23
Re: pgbouncer best practices Ben Chobot 16:37
Re: pgbouncer best practices Gurjeet Singh 18:09

July 8, 2023

Thread Author Time
Re: pgbouncer best practices Rita 11:27
Re: pgbouncer best practices Ben Chobot 13:46
How to add function schema in search_path in option definitio Lorusso Domenico 15:06
Re: How to add function schema in search_path in option definitio Adrian Klaver 15:31
Re: How to add function schema in search_path in option definitio Adrian Klaver 15:46
Re: How to add function schema in search_path in option definitio Lorusso Domenico 17:00
Re: How to add function schema in search_path in option definitio Adrian Klaver 21:10

July 9, 2023

Thread Author Time
Re: [Beginner Question]What's the use of ResTarget? Alvaro Herrera 10:59
Re: How to add function schema in search_path in option definitio Peter J. Holzer 11:01
now() literal in pg_input_is_valid jian he 12:13
Re: pgbouncer best practices Rita 13:27
Re: now() literal in pg_input_is_valid Tom Lane 14:22
Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" Avi Weinberg 14:22
Re: Support logical replication of DDLs Zheng Li 19:22
Re: How to add function schema in search_path in option definitio Lorusso Domenico 20:47
Re: How to add function schema in search_path in option definitio Adrian Klaver 21:21
INSERT UNIQUE row? pf 22:58
Re: INSERT UNIQUE row? Christophe Pettus 23:02
Re: INSERT UNIQUE row? David G. Johnston 23:42

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

Browse Archives

Prev | Next