pgsql-general since 2022-08-09 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. 9, 2022

Thread Author Time
Re: pg_restore remap schema Fabrice Chapuis 06:39
Creating A GIN index on JSONB column (large database) Taylor Smith 14:04
Re: Creating A GIN index on JSONB column (large database) Rob Sargent 14:39
Re: Creating A GIN index on JSONB column (large database) Taylor Smith 14:45
Re: Creating A GIN index on JSONB column (large database) Rob Sargent 14:50
Re: Creating A GIN index on JSONB column (large database) Taylor Smith 15:29
Re: Creating A GIN index on JSONB column (large database) Ron 16:46
Re: Creating A GIN index on JSONB column (large database) Ron 16:53

Aug. 10, 2022

Thread Author Time
index row size 2720 exceeds btree version 4 Daulat 04:57
pkg: two postgresql clients ml 07:25
Re: index row size 2720 exceeds btree version 4 Albrecht Dreß 08:53
Re: pkg: two postgresql clients Peter 10:15
Re: index row size 2720 exceeds btree version 4 Peter J. Holzer 13:49
Surprisingly forgiving behavior when a case expression is terminated with "end case" Bryn Llewellyn 18:59
Re: Surprisingly forgiving behavior when a case expression is terminated with "end case" Tom Lane 19:17
Re: Surprisingly forgiving behavior when a case expression is terminated with "end case" Adrian Klaver 19:18
Why is DEFAULT much faster than UPDATE? André Hänsel 23:02
Re: Why is DEFAULT much faster than UPDATE? Adrian Klaver 23:11
Re: Surprisingly forgiving behavior when a case expression is terminated with "end case" Bryn Llewellyn 23:12

Aug. 11, 2022

Thread Author Time
Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 01:53
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario David G. Johnston 03:07
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 05:05
Modelling a web CMS in Postgres ... a little advice needed Laura Smith 07:35
Aw: Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Karsten Hilbert 08:10
Fwd: Modelling a web CMS in Postgres ... a little advice needed Tony Shelver 09:49
Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed Laura Smith 10:00
Strategy for preparing a query containg dynamic case / when Theofilos Theofovos 10:11
Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed Laura Smith 12:30
Oddity that I don't understand Perry Smith 13:23
Re: Oddity that I don't understand Perry Smith 13:28
Re: Fwd: Modelling a web CMS in Postgres ... a little advice needed Tony Shelver 13:53
Re: Modelling a web CMS in Postgres ... a little advice needed Rob Sargent 13:59
Is ODBC list still alive? Igor Korot 14:11
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 16:28
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario David G. Johnston 17:07
Re: Postgres NOT IN vs NOT EXISTS optimization Bruce Momjian 20:12
Re: Strategy for preparing a query containg dynamic case / when Theofilos Theofovos 20:19
Re: Strategy for preparing a query containg dynamic case / when David G. Johnston 20:26
Re: Postgres NOT IN vs NOT EXISTS optimization Bruce Momjian 20:50
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 23:20

Aug. 12, 2022

Thread Author Time
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Julien Rouhaud 00:04
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 03:41
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario 📎 David G. Johnston 03:58
Re: Surprising results from current_role in a "security invoker" trigger function in a "cascade delete via FK" scenario Bryn Llewellyn 04:52
Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example Scott Simpson 10:16
Re: Support logical replication of DDLs Amit Kapila 10:32
Call for Volunteers - pgconf.nyc 2022 Andreas 'ads' Scherbaum 11:00
RE: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example Joel Rabinovitch 12:07
Scale 19x presentations Lawrence Layhee 16:30
Could not load server certificate file "server.crt": No such file or directory. howardnews 17:02
Re: Could not load server certificate file "server.crt": No such file or directory. Adrian Klaver 17:09
Is ODBC list dead? Igor Korot 17:27
Re: Could not load server certificate file "server.crt": No such file or directory. howardnews 17:53

Aug. 13, 2022

Thread Author Time
Re: Support logical replication of DDLs 📎 Ajin Cherian 15:26

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

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