pgsql-general since 2022-08-01 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. 1, 2022

Thread Author Time
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Tom Lane 00:02
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Adrian Klaver 00:04
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 00:25
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 00:27
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 00:30
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Ron 02:38
Re: Connecting to postgres on OSX from Swift using PostgresClientKit Adrian Klaver 03:06
Re: Support logical replication of DDLs Peter Smith 04:18
Is Client connections via ca.crt only possible? Rejo Oommen 08:12
a database can be created but not droped Matthias Apitz 09:22
Re: a database can be created but not droped Julien Rouhaud 09:27
Re: a database can be created but not droped Frank Streitzig 09:30
Re: Connecting to postgres on OSX from Swift using PostgresClientKit howardnews 11:11
"set autocommit on" in golang client query Rory Campbell-Lange 13:10
Re: "set autocommit on" in golang client query Guillaume Lelarge 13:18
Inconsistent permission enforcement for schemas Marcin Barczyński 15:48
Re: Inconsistent permission enforcement for schemas Tom Lane 16:49

Aug. 2, 2022

Thread Author Time
RE: Support logical replication of DDLs 📎 [email protected] 03:20
Re: Creation of FK without enforcing constraint for existing data [email protected] 07:14
Re: Creation of FK without enforcing constraint for existing data Gavan Schneider 07:43
Strange collation names ("hu_HU.UTF-8") Durumdara 12:18
Re: Syntax error when combining --set and --command has me stumped Ron 13:07
Re: Strange collation names ("hu_HU.UTF-8") Tom Lane 13:43
ICU is not supported in this build. install from source code. jian he 14:38
Copying records from TABLE_A to TABLE_B (in the same database) Ron 18:37
Re: Copying records from TABLE_A to TABLE_B (in the same database) Rob Sargent 18:41
Re: Copying records from TABLE_A to TABLE_B (in the same database) Adrian Klaver 18:41
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 18:42
Re: Copying records from TABLE_A to TABLE_B (in the same database) Thomas Kellerer 18:51
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 18:54
Re: Copying records from TABLE_A to TABLE_B (in the same database) Rob Sargent 18:59
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 19:01
Re: Copying records from TABLE_A to TABLE_B (in the same database) Ron 19:02
Re: Copying records from TABLE_A to TABLE_B (in the same database) Rob Sargent 19:08
Re: Copying records from TABLE_A to TABLE_B (in the same database) Peter J. Holzer 19:41

Aug. 3, 2022

Thread Author Time
Re: Strange collation names ("hu_HU.UTF-8") Thomas Munro 02:49
Re: ICU is not supported in this build. install from source code. jian he 08:32
BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas PG Bug reporting form 10:09
Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Juan José Santamaría Flecha 11:13
Why is my table continuousely written? Peter 11:36
"Missing" column in Postgres logical replication update message Kevin Martin 13:50
Re: "Missing" column in Postgres logical replication update message Adrian Klaver 14:47
Re: "Missing" column in Postgres logical replication update message Adrian Klaver 15:12
Why is my table continuousely written? -> XID issue? Peter 15:15
Re: "Missing" column in Postgres logical replication update message Kevin Martin 15:19
Re: "Missing" column in Postgres logical replication update message Tom Lane 15:28
Re: ICU is not supported in this build. install from source code. Daniel Verite 15:46
Re: "Missing" column in Postgres logical replication update message Kevin Martin 16:31
Upgrading from 12.3 to 12.11 zaphod61 17:16
Re: Upgrading from 12.3 to 12.11 David G. Johnston 17:18
Re: Upgrading from 12.3 to 12.11 Christophe Pettus 17:28
Re: Upgrading from 12.3 to 12.11 Adrian Klaver 17:57
Re: Upgrading from 12.3 to 12.11 zaphod61 18:44
Re: Upgrading from 12.3 to 12.11 Adrian Klaver 18:51
Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Poornima Venkatesan 19:17
Re: Upgrading from 12.3 to 12.11 Adrian Klaver 19:42
Re: Upgrading from 12.3 to 12.11 zaphod61 19:58
Re: Is Client connections via ca.crt only possible? Thomas Guyot 21:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 22:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Tom Lane 23:05

Aug. 4, 2022

Thread Author Time
Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Ron 00:30
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Adrian Klaver 01:02
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Ron 01:13
Re: Is Client connections via ca.crt only possible? Rejo Oommen 01:37
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Julien Rouhaud 02:13
Re: Is Client connections via ca.crt only possible? Thomas Guyot 02:22
RE: Support logical replication of DDLs 📎 [email protected] 02:51
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Adrian Klaver 04:45
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 05:46
How to choose new master from slaves.? Sacheen Birhade 07:43
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Francisco Olarte 07:51
Re: Unable to start replica after failover Kyotaro Horiguchi 08:30
Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Mateusz Henicz 08:32
Re: Behavior of identity columns [email protected] 08:52
Index only scans for expressional indices when querying for the expression Danny Shemesh 09:59
Re: How to choose new master from slaves.? Ron 10:22
Re: Behavior of identity columns Francisco Olarte 10:32
Re: Index only scans for expressional indices when querying for the expression David G. Johnston 12:28
Re: Index only scans for expressional indices when querying for the expression Danny Shemesh 12:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 12:34
Re: Index only scans for expressional indices when querying for the expression Tom Lane 13:38
Allow user to connect to replicas only Wiwwo Staff 13:42
Re: Allow user to connect to replicas only hubert depesz lubaczewski 13:56
Re: Index only scans for expressional indices when querying for the expression Danny Shemesh 14:03
Re: Index only scans for expressional indices when querying for the expression Tom Lane 14:17
follower never to become master Marco Lechner 15:44
sequence id overflow ERROR using timescaledb abrahim abrahao 20:47
Re: PostgreSQL 14.4 ERROR: out of memory issues Joe Conway 21:15
Re: Purpose of DEFERRABLE _and_ INITIALLY DEFERRED foreign key constraint checking? Jan Wieck 23:57

Aug. 5, 2022

Thread Author Time
Re: sequence id overflow ERROR using timescaledb Julien Rouhaud 02:37
Re: Support logical replication of DDLs Peter Smith 06:03
Expr. extended stats are skipped with equality operator Danny Shemesh 09:50
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 15:47

Aug. 6, 2022

Thread Author Time
Re: PostgreSQL 14.4 ERROR: out of memory issues Peter J. Holzer 08:25
Re: How to choose new master from slaves.? Peter J. Holzer 08:40
Re: How to choose new master from slaves.? Ron 20:06
Re: How to choose new master from slaves.? Peter J. Holzer 20:45
Re: How to choose new master from slaves.? Ron 21:13

Aug. 7, 2022

Thread Author Time
Question about locking Frank Millman 05:30
Re: Question about locking Ron 05:54
Re: Question about locking Frank Millman 06:22
Re: Expr. extended stats are skipped with equality operator Tomas Vondra 17:23
Re: Expr. extended stats are skipped with equality operator Tom Lane 17:28
Re: Expr. extended stats are skipped with equality operator Tomas Vondra 17:31
Re: PostgreSQL 14.4 ERROR: out of memory issues Aleš Zelený 19:47

Aug. 8, 2022

Thread Author Time
tablesample clause doesnt support to be applied to subquery. Wind 07:52
Re: tablesample clause doesnt support to be applied to subquery. rob stone 08:05
RE: 20220722-pg_dump: error: invalid number of parents 0 for table Techsupport 09:29
pg_restore remap schema Fabrice Chapuis 16:27
Re: pg_restore remap schema Guillaume Lelarge 18:16
Re: pg_restore remap schema Tom Lane 18:22
Re: pg_restore remap schema Marcos Pegoraro 19:26
Re: Support logical replication of DDLs Zheng Li 20:22
Re: 20220722-pg_dump: error: invalid number of parents 0 for table Saul Perdomo 23:55

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

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