pgsql-general since 2022-10-06 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 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 6, 2022

Thread Author Time
('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Bryn Llewellyn 00:16
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE David G. Johnston 00:31
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Tom Lane 01:20
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Adrian Klaver 04:31
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Christophe Pettus 04:51
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Bryn Llewellyn 05:04
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Bryn Llewellyn 05:48
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Bryn Llewellyn 05:58
Re: Support logical replication of DDLs Peter Smith 08:30
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Gavan Schneider 08:49
Aw: Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Karsten Hilbert 09:16
[Beginner Question]How to generate a call-graph for project? Wen Yi 12:16
Cannot convert partitioned table to a view Kouber Saparev 12:26
Re: Cannot convert partitioned table to a view Tom Lane 14:02
pg_restore creates public schema? Ron 14:24
Re: Postgres calendar? Gus Spier 14:49
Re: pg_restore creates public schema? Tom Lane 14:49
Re: pg_restore creates public schema? Ron 15:17
Re: pg_restore creates public schema? Tom Lane 15:20
Re: Support logical replication of DDLs 📎 Zheng Li 16:40
Re: pg_restore creates public schema? Ron 16:46
Re: pg_restore creates public schema? Christophe Pettus 16:48
Re: Support logical replication of DDLs Alvaro Herrera 17:16
Re: Replication between Master PostgreSQL database version 9.6.1 and Standby/Slave PostgreSQL database version 10.17. Kaushal Shriyan 17:20
Re: Replication between Master PostgreSQL database version 9.6.1 and Standby/Slave PostgreSQL database version 10.17. Christophe Pettus 17:32
Re: pg_restore creates public schema? Ron 17:44
Re: pg_restore creates public schema? Christophe Pettus 17:46
Re: pg_restore creates public schema? Adrian Klaver 19:32
Re: pg_restore creates public schema? Adrian Klaver 19:35
Re: pg_restore creates public schema? Ron 20:52
Re: pg_restore creates public schema? Ron 20:54
Re: pg_restore creates public schema? Ron 21:03
Re: Support logical replication of DDLs 📎 Zheng Li 21:30
Re: pg_restore creates public schema? Adrian Klaver 22:01
Re: pg_restore creates public schema? Adrian Klaver 22:04
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Bryn Llewellyn 22:24
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Bryn Llewellyn 22:53
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE David G. Johnston 23:01

Oct. 7, 2022

Thread Author Time
Re: Support logical replication of DDLs Ajin Cherian 00:01
Re: Support logical replication of DDLs 📎 Zheng Li 02:40
Re: Support logical replication of DDLs 📎 vignesh C 05:07
Re: pg_restore creates public schema? Ron 17:11
Re: Cannot convert partitioned table to a view Kouber Saparev 20:27
Re: pg_restore creates public schema? Alban Hertroys 20:31
Re: Cannot convert partitioned table to a view Tom Lane 20:33
Re: Cannot convert partitioned table to a view Kouber Saparev 20:44
Re: Cannot convert partitioned table to a view Tom Lane 21:03
Re: pg_restore creates public schema? Adrian Klaver 21:36

Oct. 8, 2022

Thread Author Time
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Bryn Llewellyn 00:16
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Adrian Klaver 00:27
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE Christophe Pettus 00:54
Re: ('dog$house' = quote_ident('dog$house')) is surprisingly FALSE David G. Johnston 02:10
Re: pg_restore creates public schema? Ron 03:14
Re: Cannot convert partitioned table to a view Ron 03:22
Re: pg_restore creates public schema? Adrian Klaver 15:02

Oct. 9, 2022

Thread Author Time
TF card for PGDATA Theodore M Rolle, Jr. 00:14
Re: TF card for PGDATA Christophe Pettus 02:00
Re: Cannot convert partitioned table to a view Kouber Saparev 07:10
Different execution plan between PostgreSQL 8.4 and 12.11 gzh 09:11
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Ron 09:56
recovery.conf and archive files Rita 11:53
Re: recovery.conf and archive files Guillaume Lelarge 12:45
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Tom Lane 16:02
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Mladen Gogala 16:05
Logical replication/publication question Mark Fletcher 16:56

Oct. 10, 2022

Thread Author Time
Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11 gzh 02:32
Re: Support logical replication of DDLs Peter Smith 02:38
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Tom Lane 02:45
Re: Support logical replication of DDLs 📎 Ajin Cherian 09:58
Same query, same data different plan Kostas Papadopoulos 12:56
Re: Same query, same data different plan Daevor The Devoted 13:03
Re: Same query, same data different plan Kostas Papadopoulos 13:05
Re: Same query, same data different plan Julien Rouhaud 13:12
Re: Same query, same data different plan Kostas Papadopoulos 13:15
Re: Same query, same data different plan Pavel Stehule 13:16
Re: Same query, same data different plan Kostas Papadopoulos 13:23
Re: Same query, same data different plan Imre Samu 13:24
Re: Same query, same data different plan Ron 13:44
Re: Same query, same data different plan Kostas Papadopoulos 14:04
Re: Same query, same data different plan Adrian Klaver 14:26
Re: Same query, same data different plan Tom Lane 14:53
Re: Same query, same data different plan Kostas Papadopoulos 15:12
Re: Same query, same data different plan Adrian Klaver 17:59
Playing with pgcrypto howardnews 22:25
Re: Playing with pgcrypto Erik Wienhold 22:52
Re: Playing with pgcrypto howardnews 23:17

Oct. 11, 2022

Thread Author Time
Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11 gzh 03:12
Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 Pavel Stehule 03:32
Re:Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 gzh 04:05
Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 Pavel Stehule 04:13
Re:Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 gzh 05:07
Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 Pavel Stehule 05:24
Re: Same query, same data different plan Kostas Papadopoulos 06:06
Re:Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 gzh 08:01
Re: Re: Re: Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 Pavel Stehule 08:21
Re: Different execution plan between PostgreSQL 8.4 and 12.11 gzh 09:17
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Josef Šimánek 09:52
Re: Different execution plan between PostgreSQL 8.4 and 12.11 David Rowley 09:59
Re: Re: Different execution plan between PostgreSQL 8.4 and 12.11 David Rowley 10:53
Re: Support logical replication of DDLs 📎 Ajin Cherian 13:30
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Tom Lane 13:59
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Bruce Momjian 14:30
Weird planner issue on a standby Guillaume Lelarge 15:51
Re: Weird planner issue on a standby Tom Lane 16:17
Re: Weird planner issue on a standby Alvaro Herrera 16:27
Re: Weird planner issue on a standby Guillaume Lelarge 17:42

Oct. 12, 2022

Thread Author Time
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Klint Gore 00:06
Re: Different execution plan between PostgreSQL 8.4 and 12.11 David Rowley 01:47
Re: Weird planner issue on a standby Julien Rouhaud 03:35
Re: Weird planner issue on a standby Ron 04:07
Re: Weird planner issue on a standby Tom Lane 05:03
Re: Support logical replication of DDLs Dilip Kumar 06:07
Re: Weird planner issue on a standby Peter Geoghegan 06:14
Re: Weird planner issue on a standby Peter Geoghegan 06:24
Re: Weird planner issue on a standby Guillaume Lelarge 06:39
Re: Weird planner issue on a standby Guillaume Lelarge 06:56
Does psqlodbc_11_01_0000-x64 support special characters? gzh 08:28
Re: Weird planner issue on a standby Guillaume Lelarge 08:51
Re: Different execution plan between PostgreSQL 8.4 and 12.11 gzh 10:30
Re:Does psqlodbc_11_01_0000-x64 support special characters? gzh 11:16
Re: Weird planner issue on a standby Laurenz Albe 13:43
Re: Weird planner issue on a standby Tom Lane 13:47
Re: Does psqlodbc_11_01_0000-x64 support special characters? Jeffrey Walton 14:01
Re: Weird planner issue on a standby Peter Geoghegan 16:12

Oct. 13, 2022

Thread Author Time
PGAdmin 4 fatal error after enabling the import logging Chun Fan Lin 00:14
Re: Different execution plan between PostgreSQL 8.4 and 12.11 Klint Gore 02:42
Re:Re: Does psqlodbc_11_01_0000-x64 support special characters? gzh 04:13
Re: Re: Does psqlodbc_11_01_0000-x64 support special characters? Jeffrey Walton 05:27
Problem with LATERAL Eagna 07:05
Re: Problem with LATERAL Julien Rouhaud 07:30
Re: Problem with LATERAL Eagna 08:04
Re: Problem with LATERAL Julien Rouhaud 08:34
Re: recovery.conf and archive files Rita 10:41
Re: Support logical replication of DDLs 📎 Ajin Cherian 12:46
Exponentiation confusion Adrian Klaver 16:20
Re: Exponentiation confusion Erik Wienhold 16:53
Re: PGAdmin 4 fatal error after enabling the import logging Ron 16:57
Re: Exponentiation confusion Peter J. Holzer 17:05
Re: Exponentiation confusion Tom Lane 17:16
pg_upgrade to 15 fails on Windows because of xml_is_well_formed() Thomas Kellerer 18:54
Re: pg_upgrade to 15 fails on Windows because of xml_is_well_formed() Tom Lane 19:01
Re: Exponentiation confusion Dean Rasheed 19:07
Re: Exponentiation confusion Tom Lane 19:12
Re: pg_upgrade to 15 fails on Windows because of xml_is_well_formed() Thomas Kellerer 19:45
Re: pg_upgrade to 15 fails on Windows because of xml_is_well_formed() Adrian Klaver 19:53
Re: Exponentiation confusion Erik Wienhold 20:07
How to return argument data type from sql function Andrus 20:16

Oct. 14, 2022

Thread Author Time
Re:Re: Re: Does psqlodbc_11_01_0000-x64 support special characters? gzh 05:43
does postgres has snapshot standby feature? milist ujang 09:20
Re: recovery.conf and archive files Guillaume Lelarge 09:27
Re: recovery.conf and archive files Rita 10:15
[libpq] OIDs of extension types? Of custom types? Dominique Devienne 11:39
Re: Number of updated rows with LibPQ Dominique Devienne 11:52
Re: Number of updated rows with LibPQ Guillaume Lelarge 12:26
Re: Number of updated rows with LibPQ Laurenz Albe 12:28
Re: [libpq] OIDs of extension types? Of custom types? Laurenz Albe 12:30
Re: does postgres has snapshot standby feature? Laurenz Albe 12:33
Re: does postgres has snapshot standby feature? Christoph Moench-Tegeder 13:08
Re: [libpq] OIDs of extension types? Of custom types? Dominique Devienne 13:42
Re: [libpq] OIDs of extension types? Of custom types? Tom Lane 14:35
Re: Number of updated rows with LibPQ Daniel Verite 14:39
Re: How to return argument data type from sql function Tom Lane 14:55
Re: [libpq] OIDs of extension types? Of custom types? Dominique Devienne 14:59
Re: Number of updated rows with LibPQ Dominique Devienne 15:05
Re: How to return argument data type from sql function Andrus 20:59
Re: How to return argument data type from sql function Tom Lane 21:24
Re: How to return argument data type from sql function David G. Johnston 21:27
Where to flag an issue with EDB's PG15 Windows installer? Anthony DeBarros 21:45
Re: How to return argument data type from sql function Andrus 21:48
Re: How to return argument data type from sql function Andrus 21:56
Re: How to return argument data type from sql function David G. Johnston 22:14
Re: How to return argument data type from sql function Tom Lane 22:19
Re: Where to flag an issue with EDB's PG15 Windows installer? Adrian Klaver 23:17

Oct. 15, 2022

Thread Author Time
Zheap Tech Problem 📎 jacktby 01:59
Re: Zheap Tech Problem Adrian Klaver 02:53
Re: Zheap Tech Problem Michael Paquier 03:15
Re: Attaching database Igor Korot 04:16
Re: Attaching database David G. Johnston 04:39
Re: Attaching database Igor Korot 04:46
Re: Attaching database David G. Johnston 04:53
Re: Attaching database Julien Rouhaud 06:06
Re: Attaching database Adrian Klaver 15:20
Re: Attaching database Adrian Klaver 15:51
Re: Attaching database Igor Korot 15:56
Re: Attaching database Adrian Klaver 16:10
Re: Attaching database Alex Theodossis 22:57

Oct. 17, 2022

Thread Author Time
A question about leakproof qiumingcheng 01:15
Re: A question about leakproof Julien Rouhaud 01:40
Re: A question about leakproof Tom Lane 01:54
回复：A question about leakproof qiumingcheng 02:50
Re: 回复：A question about leakproof Tom Lane 03:33
Re: 回复：A question about leakproof David G. Johnston 03:54
回复：回复：A question about leakproof qiumingcheng 05:17
Re: Support logical replication of DDLs 📎 vignesh C 06:11
About foreign data wrapper Rama Krishnan 06:14
Re: 回复：回复：A question about leakproof Laurenz Albe 07:19
回复：回复：回复：A question about leakproof qiumingcheng 08:24
Fedora 37 Kieran McCusker 12:33
Re: About foreign data wrapper Ian Lawrence Barwick 13:22
could not find shared library for Python jacktby 14:07

Browse Archives

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