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

Aug. 14, 2022

Thread Author Time
Re: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example 📎 hector vass 09:34

Aug. 15, 2022

Thread Author Time
ERROR: savepoint "jdbc_savepoint_532" does not exist FOUTE K. Jaurès 07:06
Re: ERROR: savepoint "jdbc_savepoint_532" does not exist Rob Sargent 07:16
limits, indexes, views and query planner Marc Mamin 08:30
Re: limits, indexes, views and query planner David Rowley 11:14
RE: Unable to start replica after failover Lahnov, Igor 12:09
Help regarding Multi Tenancy with PostgreSQL Gaurav Daunde 12:48
Can I get the number of results plus the results with a single query? Perry Smith 13:49
Re: Can I get the number of results plus the results with a single query? David G. Johnston 13:55
lateral join with union all jian he 15:52
Re: lateral join with union all David G. Johnston 16:36
Re: Can I get the number of results plus the results with a single query? Peter J. Holzer 18:16
Re: Can I get the number of results plus the results with a single query? Bryn Llewellyn 19:20
Re: ***SPAM*** Re: Can I get the number of results plus the results with a single query? Perry Smith 20:37
Re: ***SPAM*** Re: Can I get the number of results plus the results with a single query? Rob Sargent 22:13

Aug. 16, 2022

Thread Author Time
Re: Help regarding Multi Tenancy with PostgreSQL Abdul Qoyyuum 01:20
Re: ***SPAM*** Re: Can I get the number of results plus the results with a single query? Walter Dörwald 09:15
Re: ***SPAM*** Re: Can I get the number of results plus the results with a single query? David Rowley 09:58
RE: Support logical replication of DDLs 📎 [email protected] 11:57
Would it be possible to add functions to tab-completion in psql? hubert depesz lubaczewski 12:28
Re: Would it be possible to add functions to tab-completion in psql? Ron 12:42
Re: Would it be possible to add functions to tab-completion in psql? hubert depesz lubaczewski 13:01
Re: Would it be possible to add functions to tab-completion in psql? Ron 13:51
Re: Would it be possible to add functions to tab-completion in psql? Julien Rouhaud 13:55
Re: Would it be possible to add functions to tab-completion in psql? hubert depesz lubaczewski 13:59
Re: Would it be possible to add functions to tab-completion in psql? hubert depesz lubaczewski 14:02
Re: Would it be possible to add functions to tab-completion in psql? Tom Lane 14:10
Re: Would it be possible to add functions to tab-completion in psql? hubert depesz lubaczewski 14:14
Re: Would it be possible to add functions to tab-completion in psql? Bzm@g 14:37
Re: Can I get the number of results plus the results with a single query? Peter J. Holzer 20:42
Re: Can I get the number of results plus the results with a single query? Bryn Llewellyn 21:42
plpython questions Ted Toth 23:15
Re: plpython questions Bruce Momjian 23:21
Re: plpython questions Adrian Klaver 23:21
Re: plpython questions David G. Johnston 23:21
plpython/python string formatting Ted Toth 23:42
Re: plpython/python string formatting Adrian Klaver 23:55

Aug. 17, 2022

Thread Author Time
Re: plpython/python string formatting Adrian Klaver 00:23
Regarding availability of 32bit client drivers for postgresql 13/14 Aravind Phaneendra 03:46
Regarding availability of 32bit client drivers for postgresql 13/14 Aravind Phaneendra 03:47
Re: Regarding availability of 32bit client drivers for postgresql 13/14 Adrian Klaver 04:27
RE: Regarding availability of 32bit client drivers for postgresql 13/14 Aravind Phaneendra 04:53
Re: Regarding availability of 32bit client drivers for postgresql 13/14 Tatsuo Ishii 05:16
Re: Would it be possible to add functions to tab-completion in psql? Peter Eisentraut 05:33
Sub:column "" is of type bigint but expression is of type character varying Rama Krishnan 08:53
Re: Can I get the number of results plus the results with a single query? Peter J. Holzer 09:26
Postgres question ajay venki 09:32
i added Arabic Dictionary but how I know i'm using it Mohammed falih 11:33
Re: Regarding availability of 32bit client drivers for postgresql 13/14 Ron 11:45
Re: Postgres question hubert depesz lubaczewski 12:24
Re: Sub:column "" is of type bigint but expression is of type character varying JITEN KUMAR SHAH 12:27
Re: Postgres question ajay venki 12:39
Re: Postgres question Thomas Kellerer 15:01
Re: Sub:column "" is of type bigint but expression is of type character varying Adrian Klaver 15:07
Re: Sub:column "" is of type bigint but expression is of type character varying David G. Johnston 15:25
Re: i added Arabic Dictionary but how I know i'm using it Laurenz Albe 15:59
Setting up streaming replication on large database (20+ TB) for the first time Ivan N. Ivanov 20:06
Re: Setting up streaming replication on large database (20+ TB) for the first time Christophe Pettus 20:09
Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time Ivan N. Ivanov 20:13

Aug. 18, 2022

Thread Author Time
Different execution plan between PostgreSQL 8.2 and 12.5 gzh 03:01
Re: Different execution plan between PostgreSQL 8.2 and 12.5 Tom Lane 03:32
Re: Different execution plan between PostgreSQL 8.2 and 12.5 David Rowley 03:38
Re: Different execution plan between PostgreSQL 8.2 and 12.5 Adrian Klaver 04:18
Re: Setting up streaming replication on large database (20+ TB) for the first time Ron 05:53
Unable to Create or Drop Index Concurrently Abdul Qoyyuum 05:57
Re: Unable to Create or Drop Index Concurrently Christophe Pettus 06:05
Is it possible to keep indexes on different disk location? W.P. 06:39
Re: Setting up streaming replication on large database (20+ TB) for the first time Vijaykumar Jain 06:43
Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time Ivan N. Ivanov 07:32
Re: Is it possible to keep indexes on different disk location? hubert depesz lubaczewski 08:58
Re: Unable to Create or Drop Index Concurrently hubert depesz lubaczewski 09:00
Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time Vijaykumar Jain 09:10
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 09:50
ERROR: catalog is missing 3 attribute(s) for relid 150243 milist ujang 10:33
Data caching Anant ngo 10:42
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 11:59
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 12:07
Re: Re: Different execution plan between PostgreSQL 8.2 and 12.5 Torsten Krah 12:22
Re: [(catch-ext)] Re: [(catch-ext)] Re: Setting up streaming replication on large database (20+ TB) for the first time Ivan N. Ivanov 12:35
Re: Data caching Bruce Momjian 13:57
Re: Is it possible to keep indexes on different disk location? Laurenz Albe 14:46
Re: Different execution plan between PostgreSQL 8.2 and 12.5 Adrian Klaver 14:53
Fwd: Data caching Anant ngo 16:39
Re: Fwd: Data caching Adrian Klaver 19:49
Re: Is it possible to keep indexes on different disk location? W.P. 19:54
SIReadLock vs hot_standby_feedback Christophe Pettus 20:28
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 milist ujang 22:55

Aug. 19, 2022

Thread Author Time
Re: Is it possible to keep indexes on different disk location? Ron 00:48
Re: Unable to Create or Drop Index Concurrently Abdul Qoyyuum 02:46
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 Julien Rouhaud 04:02
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 milist ujang 04:27
Re: ERROR: catalog is missing 3 attribute(s) for relid 150243 Tom Lane 04:42
Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 04:42
Monitoring multixact members growth Vido Vlahinic 05:16
Re:Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 gzh 07:14
RE: Monitoring multixact members growth Vido Vlahinic 07:52
recovery_command has precedence over phisical slots? Giovanni Biscontini 14:54
High Availability PostgresDB on K8s Marco Schmucki 15:09
Re: High Availability PostgresDB on K8s Sumit Sengupta 15:51
Re: recovery_command has precedence over phisical slots? Laurenz Albe 16:37
Re: High Availability PostgresDB on K8s Jan Kohnert 18:09
Re: Monitoring multixact members growth Peter Geoghegan 19:15
Re: Monitoring multixact members growth Jeremy Schneider 23:31

Aug. 20, 2022

Thread Author Time
Support for dates before 4713 BC Watzinger, Alexander 14:05
With Recursive / Recursive View question Perry Smith 22:42

Aug. 21, 2022

Thread Author Time
Re: With Recursive / Recursive View question Christophe Pettus 00:38
Re: ***SPAM*** Re: With Recursive / Recursive View question Perry Smith 02:02
Re: ***SPAM*** Re: With Recursive / Recursive View question Perry Smith 02:48
Re: With Recursive / Recursive View question Peter J. Holzer 17:03
Re: Support for dates before 4713 BC Adrian Klaver 17:15
Re: Support for dates before 4713 BC Peter J. Holzer 17:54
Re: Support for dates before 4713 BC Tom Lane 18:04

Aug. 22, 2022

Thread Author Time
Re: Can I get the number of results plus the results with a single query? Wim Bertels 07:17
Re: Creating constraint dynamically [email protected] 07:29
Re: Creating constraint dynamically Wim Bertels 07:39
Re: Creating constraint dynamically JITEN KUMAR SHAH 08:23
Re: Creating constraint dynamically Francisco Olarte 08:45
Re: Support for dates before 4713 BC stefan eichert 10:14
Re: Creating constraint dynamically jian he 10:23
Re: Support for dates before 4713 BC Alvaro Herrera 10:42
Re: Support for dates before 4713 BC Tom Browder 10:59

Aug. 23, 2022

Thread Author Time
Re: Unable to start replica after failover Kyotaro Horiguchi 06:07
Re: Support for dates before 4713 BC Simon Riggs 09:25
Db log error eswar reddy 10:43
RE: Unable to start replica after failover Lahnov, Igor 12:31
Re: Support for dates before 4713 BC Peter J. Holzer 12:38
Re: Db log error Tom Lane 13:01
Re: Support for dates before 4713 BC Erik Wienhold 14:13
Possible values of DATESTYLE / PGDATESTYLE Sebastien Flaesch 17:08
Re: Possible values of DATESTYLE / PGDATESTYLE Christoph Moench-Tegeder 17:32
Re: Possible values of DATESTYLE / PGDATESTYLE Tom Lane 17:35
Corrupted Postgresql Microsoft Binaries Hillary Masha 18:58
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 19:27
Re: Setting up a server with previous day data Stephen Frost 19:43
Question regarding failover behavior Koen De Groote 23:09

Aug. 24, 2022

Thread Author Time
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 00:12
Re: Setting up a server with previous day data Ron 00:15
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario David G. Johnston 00:21
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 02:32
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario David G. Johnston 02:50
Re: recovery_command has precedence over phisical slots? Kyotaro Horiguchi 05:18
Re: Unable to start replica after failover Alexander Kukushkin 05:25
Re: Setting up a server with previous day data Peter J. Holzer 06:42
Re: recovery_command has precedence over phisical slots? Laurenz Albe 11:00
RE: Unable to start replica after failover Lahnov, Igor 11:37
Re: Setting up a server with previous day data Ron 13:51
Re: Question regarding failover behavior Koen De Groote 16:17
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 16:17
Re: recovery_command has precedence over phisical slots? Giovanni Biscontini 16:18
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 18:40
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 19:22
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 19:57
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 20:09
Two questions about "pg_constraint" Bryn Llewellyn 20:11
Re: Two questions about "pg_constraint" Adrian Klaver 20:17
Re: Two questions about "pg_constraint" Adrian Klaver 20:19
Re: Two questions about "pg_constraint" Adrian Klaver 20:29
Re: Two questions about "pg_constraint" Bryn Llewellyn 20:43
Re: Two questions about "pg_constraint" Tom Lane 20:57
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 21:01
Re: Corrupted Postgresql Microsoft Binaries Thomas Kellerer 21:23
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 21:24
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 21:36
Re: Two questions about "pg_constraint" Adrian Klaver 22:55
Greg Sabino Mullane ? Re: Two questions about "pg_constraint" Bryn Llewellyn 23:27

Aug. 25, 2022

Thread Author Time
pg_dump without setting search_path gzh 02:50
Re: pg_dump without setting search_path Tom Lane 03:07
Re:Re: pg_dump without setting search_path gzh 03:39
Re: pg_dump without setting search_path David G. Johnston 03:54
Re: pg_dump without setting search_path Adrian Klaver 04:19
Re: Unable to start replica after failover Alexander Kukushkin 05:23
Re:Re: pg_dump without setting search_path gzh 05:56
Re: Two questions about "pg_constraint" Bryn Llewellyn 06:50
Restriction on table partition expressions James Vanns 15:08
Re: Restriction on table partition expressions David Rowley 15:25
Re: Restriction on table partition expressions David Rowley 15:31
Information_schema.table_constraints Ravi Krishna 20:53
Re: Information_schema.table_constraints Adrian Klaver 22:03
Re: Information_schema.table_constraints Ravi Krishna 23:30

Aug. 26, 2022

Thread Author Time
Re: Two questions about "pg_constraint" Bryn Llewellyn 04:43
In a partition why 1st time encounter NULL then call minvfunc jian he 05:40
Re: Two questions about "pg_constraint" Christophe Pettus 05:49
Re: In a partition why 1st time encounter NULL then call minvfunc David G. Johnston 06:28
Re: Restriction on table partition expressions James Vanns 08:50
RE: Unable to start replica after failover Lahnov, Igor 11:43
How to select based on the condition of a column exists Shaozhong SHI 14:01
Re: How to select based on the condition of a column exists David G. Johnston 14:05
Re: Restriction on table partition expressions Ron 14:47
Re: Two questions about "pg_constraint" Bryn Llewellyn 22:33
Re: Two questions about "pg_constraint" Christophe Pettus 23:12

Aug. 27, 2022

Thread Author Time
Re: Two questions about "pg_constraint" Bryn Llewellyn 01:47
Re: Two questions about "pg_constraint" Christophe Pettus 02:02
Re: Two questions about "pg_constraint" Tom Lane 02:19
Re: Two questions about "pg_constraint" Bryn Llewellyn 17:57

Aug. 29, 2022

Thread Author Time
Re: Support logical replication of DDLs 📎 Ajin Cherian 06:14
questions about snapshot building logic Вадим Самохин 11:29
Re: Corrupted Postgresql Microsoft Binaries Hillary Masha 14:50
Re: Corrupted Postgresql Microsoft Binaries Adrian Klaver 15:09

Aug. 30, 2022

Thread Author Time
RE: Unable to archive logs in standby server Meera Nair 05:22
Re: Unable to start replica after failover Alexander Kukushkin 09:04

Browse Archives

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