pgsql-general - October 2022

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

Oct. 1, 2022

Thread Author Time
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 00:59
Singleton SELECT inside cursor loop Ron 06:29
Example code Re: Singleton SELECT inside cursor loop 📎 Ron 07:22
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Peter J. Holzer 11:22
Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Peter J. Holzer 12:05
Re: Example code Re: Singleton SELECT inside cursor loop Peter J. Holzer 12:20
Re: Example code Re: Singleton SELECT inside cursor loop Christoph Moench-Tegeder 12:21
Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Julien Rouhaud 12:24
Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Peter J. Holzer 12:42
Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Tom Lane 16:12
Re: Example code Re: Singleton SELECT inside cursor loop Ron 17:13
Re: Example code Re: Singleton SELECT inside cursor loop Ron 17:25
Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Bryn Llewellyn 18:57
Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Tom Lane 19:19
Re: Example code Re: Singleton SELECT inside cursor loop Christoph Moench-Tegeder 19:54
Re: Example code Re: Singleton SELECT inside cursor loop Ron 20:42

Oct. 2, 2022

Thread Author Time
Re: Example code Re: Singleton SELECT inside cursor loop 📎 Ron 04:21
Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Bryn Llewellyn 05:33
Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts) Tom Lane 06:21
C99's brain-dead jacktby jacktby 11:54
what is brain-dead about C99 inline functions? jacktby jacktby 17:05
postgresql 15 for RHEL RPMs available? Michael Nolan 20:50
Re: postgresql 15 for RHEL RPMs available? Steve Baldwin 20:54
Re: postgresql 15 for RHEL RPMs available? Michael Nolan 20:58
Re: postgresql 15 for RHEL RPMs available? Tom Lane 21:05
Re: postgresql 15 for RHEL RPMs available? Daniel Gustafsson 21:09
Re: postgresql 15 for RHEL RPMs available? Michael Nolan 21:31

Oct. 3, 2022

Thread Author Time
Please explain what's c99 brain dead? 📎 jacktby jacktby 11:13
Incorrect resource manager data checksum in record with zfs and compression John Bolliger 19:41
PGSQL Phriday #001 - Two truths and a lie about PostgreSQL Ryan Booz 20:26

Oct. 4, 2022

Thread Author Time
Re: Incorrect resource manager data checksum in record with zfs and compression Michael Paquier 00:54
Re: Incorrect resource manager data checksum in record with zfs and compression John Bolliger 01:01
fully qualified domain names and .pgpass Ron 17:02
Re: fully qualified domain names and .pgpass Alvaro Herrera 17:33
Re: fully qualified domain names and .pgpass Adrian Klaver 17:34
Re: fully qualified domain names and .pgpass Jeffrey Walton 19:21
Postgres calendar? Bruce Momjian 21:02
Re: Postgres calendar? Fabrízio de Royes Mello 21:11
Re: fully qualified domain names and .pgpass Ron 23:58

Oct. 5, 2022

Thread Author Time
Re: Postgres calendar? Joshua Drake 02:36
Re: Postgres calendar? Adam Brusselback 03:52
Re: Postgres calendar? Julien Rouhaud 03:59
RE: Streaming wal from primiry terminating Lahnov, Igor 09:53
Re: Postgres calendar? Peter Eisentraut 13:39
Number of updated rows with LibPQ Dominique Devienne 14:38
Re: Number of updated rows with LibPQ Laurenz Albe 16:09
Replication between Master PostgreSQL database version 9.6.1 and Standby/Slave PostgreSQL database version 10.17. Kaushal Shriyan 16:32
Re: Replication between Master PostgreSQL database version 9.6.1 and Standby/Slave PostgreSQL database version 10.17. Christophe Pettus 17:31
Re: Number of updated rows with LibPQ Tom Lane 18:17
Re: Postgres calendar? Josef Šimánek 21:39

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

Browse Archives

Prev | Next