pgsql-general - January 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)
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 28 29 30 31

Jan. 1, 2022

Thread Author Time
Re: a very naive question about table names in Postgres Dave Cramer 11:48
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Adrian Klaver 16:41
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Magnus Hagander 16:57

Jan. 2, 2022

Thread Author Time
Visibility of data from table inherits function ourdiaspora 12:23
Re: Visibility of data from table inherits function David G. Johnston 15:50
Re: Visibility of data from table inherits function Francisco Olarte 15:54
Re: Visibility of data from table inherits function ourdiaspora 19:41
Re: Visibility of data from table inherits function Adrian Klaver 19:55
Re: Visibility of data from table inherits function Achilleas Mantzios 21:37

Jan. 3, 2022

Thread Author Time
Re: Visibility of data from table inherits function Francisco Olarte 08:04
VACUUM FULL missing chunk number 0 for toast value Yi Sun 09:28
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq 14:58
Re: VACUUM FULL missing chunk number 0 for toast value Tom Lane 16:18
postgres_fdw FAST "where id in (140,144,148)" SLOW: "where id in (select 140 as id union select 144 union select 148)" Avi Weinberg 16:26

Jan. 4, 2022

Thread Author Time
restoring a single database from a pg_dumpall dump file Matthias Apitz 08:30
Re: md5 issues Postgres14 on OL7 Michael Paquier 11:52
Re: restoring a single database from a pg_dumpall dump file Tom Lane 15:01
Refresh ONE publication out of the Two Publications the Subscription has Avi Weinberg 15:47
Re: md5 issues Postgres14 on OL7 Tom Lane 17:54
Re: Tab-completion error...? Theodore M Rolle, Jr. 18:22
Re: Refresh ONE publication out of the Two Publications the Subscription has Achilleas Mantzios 18:29
Re: Tab-completion error...? Tom Lane 18:32
Re: As a Linux distro, how to package multiple postgres major versions? Chocimier 21:15
Re: md5 issues Postgres14 on OL7 Christoph Moench-Tegeder 21:16
Re: Tab-completion error...? Theodore M Rolle, Jr. 23:04
Re: Tab-completion error...? Tom Lane 23:15
Re: As a Linux distro, how to package multiple postgres major versions? Adrian Klaver 23:18

Jan. 5, 2022

Thread Author Time
Re: md5 issues Postgres14 on OL7 Michael Paquier 05:51
Re: md5 issues Postgres14 on OL7 Tom Lane 06:08
Re: md5 issues Postgres14 on OL7 Michael Paquier 07:09
Postgis - geography function Sameer TWAYANA 08:48
Can we use sql language to create a function in Postgres? Shaozhong SHI 11:04
Re: Can we use sql language to create a function in Postgres? Ray O'Donnell 11:08
Re: Can we use sql language to create a function in Postgres? Ray O'Donnell 11:10
Re: Can we use sql language to create a function in Postgres? hubert depesz lubaczewski 11:12
Re: Can we use sql language to create a function in Postgres? Shaozhong SHI 11:22
Re: Can we use sql language to create a function in Postgres? Shaozhong SHI 11:26
Re: Can we use sql language to create a function in Postgres? hubert depesz lubaczewski 11:34
How best to create and use associative array type in Postgres? Shaozhong SHI 12:10
Create and access a dictionary type Shaozhong SHI 13:17
Re: Postgis - geography function Tomas Vondra 13:20
Re: Create and access a dictionary type Tomas Vondra 13:22
Re: Create and access a dictionary type Shaozhong SHI 13:36
Replicate consistent snapshot to a second PG instance using FDWs Thomas Michael Engelke 14:12
Re: How best to create and use associative array type in Postgres? Tom Lane 14:54
Re: How best to create and use associative array type in Postgres? Shaozhong SHI 16:11
Re: How best to create and use associative array type in Postgres? Tom Lane 16:24
Re: Create and access a dictionary type Ron 16:24
Re: Create and access a dictionary type Tomas Vondra 16:35
Re: Create and access a dictionary type Tomas Vondra 16:37
Re: Create and access a dictionary type Ron 16:57
Re: Create and access a dictionary type Rob Sargent 16:59
Re: Can we use sql language to create a function in Postgres? Merlin Moncure 17:42
Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Dominique Devienne 18:05
Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Rob Sargent 18:10
Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Tom Lane 18:26
Re: Trouble DROP'ing a ROLE, despite REVOKE'ing its privileges Tom Lane 19:04
Re: How best to create and use associative array type in Postgres? Shaozhong SHI 20:26
Re: How best to create and use associative array type in Postgres? Adrian Klaver 20:34

Jan. 6, 2022

Thread Author Time
How to write such a query? Igor Korot 06:39
Re: How to write such a query? Amul Sul 06:46
Re: How to write such a query? Ron 07:00
Re: How to write such a query? David G. Johnston 07:00
Re: How to write such a query? Igor Korot 07:06
Re: How to write such a query? Igor Korot 07:07
Re: How to write such a query? Ron 07:11
Re: How to write such a query? Igor Korot 07:14
Re: How to write such a query? Ron 07:14
Re: How to write such a query? Dmitry Igrishin 08:17
Re: md5 issues Postgres14 on OL7 📎 Michael Paquier 08:20
Getting json-value as varchar Andreas Joseph Krogh 12:28
Re: Getting json-value as varchar Thomas Markus 12:31
Re: Getting json-value as varchar Andreas Joseph Krogh 12:36
Recommended storage hardware Levente Birta 12:53
pg_dump parameter Augusto Mossambani 12:57
Re: Getting json-value as varchar David G. Johnston 13:13
Sv: Recommended storage hardware Andreas Joseph Krogh 13:17
Re: Getting json-value as varchar Andreas Joseph Krogh 13:20
Re: Getting json-value as varchar Thomas Markus 13:25
Re: Getting json-value as varchar David G. Johnston 13:29
Re: Getting json-value as varchar Andreas Joseph Krogh 13:33
Re: Getting json-value as varchar Pavel Stehule 13:42
Re: Getting json-value as varchar Andreas Joseph Krogh 13:48
Re: pg_dump parameter David G. Johnston 14:37
Re: Getting json-value as varchar Thomas Kellerer 14:39
Re: md5 issues Postgres14 on OL7 📎 Tom Lane 16:40

Jan. 7, 2022

Thread Author Time
Re: md5 issues Postgres14 on OL7 📎 Michael Paquier 02:14
Patroni pkg_resources.DistributionNotFound Dennis 13:11
Re: pg_dump parameter Rébeli-Szabó Tamás 15:56
The postgres server don't work Mohammed falih 18:05
java.lang.ClassNotFoundException: batchprint.Batch Atul Kumar 18:21
Re: java.lang.ClassNotFoundException: batchprint.Batch Rob Sargent 18:27
Timestamp with precision output format with trailing zeros Eugene Podshivalov 20:04
Stream Replication not working Allie Crawford 21:57
Re: md5 issues Postgres14 on OL7 Tom Lane 22:40

Jan. 8, 2022

Thread Author Time
Re: Tab-completion error...? Theodore M Rolle, Jr. 01:12
Re: md5 issues Postgres14 on OL7 📎 Michael Paquier 06:04
Re: Timestamp with precision output format with trailing zeros ewie 06:22
create database hangs forever on WSL - autovacuum deadlock? Alicja Kucharczyk 07:10
How are md5.h: pg_md5_hash() function and below functions working? Ali Koca 13:21
Re: How are md5.h: pg_md5_hash() function and below functions working? Adrian Klaver 16:12
Why not used standart SQL commands? Ali Koca 18:25
Re: Why not used standart SQL commands? David G. Johnston 18:28
Re: Why not used standart SQL commands? Tom Lane 18:30
Re: Why not used standart SQL commands? Adrian Klaver 18:34
Re: Why not used standart SQL commands? Tom Lane 18:38
Re: The postgres server don't work Adrian Klaver 18:45
Re: md5 issues Postgres14 on OL7 Tom Lane 19:00
Re: create database hangs forever on WSL - autovacuum deadlock? Thomas Munro 21:40
Re: Why not used standard SQL commands? Thomas Kellerer 21:45
Re: Why not used standart SQL commands? Andreas 'ads' Scherbaum 22:18
Re: The postgres server don't work Mohammed falih 22:47
Re: The postgres server don't work Adrian Klaver 23:18
Re: The postgres server don't work Mohammed falih 23:29
Re: The postgres server don't work Adrian Klaver 23:40
Re: The postgres server don't work Adrian Klaver 23:51

Jan. 9, 2022

Thread Author Time
Re: create database hangs forever on WSL - autovacuum deadlock? Alicja Kucharczyk 01:15
Re: The postgres server don't work Дмитрий Иванов 04:18
Re: The postgres server don't work Mohammed falih 10:16
Re: The postgres server don't work Mohammed falih 10:27
Re: The postgres server don't work Mohammed falih 10:30
Re: The postgres server don't work Дмитрий Иванов 12:51
Re: The postgres server don't work Mohammed falih 13:42
Re: The postgres server don't work Дмитрий Иванов 13:47
Re: create database hangs forever on WSL - autovacuum deadlock? Thomas Munro 20:55

Jan. 10, 2022

Thread Author Time
Re: Why not used standart SQL commands? Nicklas Avén 07:47
Install pg_dump and pg_restore on UBI8 and UBI8-minimal Torello Querci 08:02
CI/CD Boilerplate for extension binaries without source code ? Markur Sens 10:16
Database stuck in a state where vacuum and vacuumdb is not working jonathaan67 13:19
Re: Database stuck in a state where vacuum and vacuumdb is not working Laurenz Albe 13:29
Re: Install pg_dump and pg_restore on UBI8 and UBI8-minimal Devrim Gündüz 15:13
DROP OWNED BY fails with #53200: ERROR: out of shared memory Dominique Devienne 17:26
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Tom Lane 17:39
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Dominique Devienne 19:12
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Adrian Klaver 19:24
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Alvaro Herrera 19:48
Stream Replication not working Allie Crawford 19:53
Re: Stream Replication not working SATYANARAYANA NARLAPURAM 20:06
Re: [Ext:] Re: Stream Replication not working Allie Crawford 20:42
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory David G. Johnston 21:08
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Adrian Klaver 21:28
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Tom Lane 21:29
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Dominique Devienne 21:58
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Adrian Klaver 22:13

Jan. 11, 2022

Thread Author Time
Re: md5 issues Postgres14 on OL7 Michael Paquier 01:02
Re: [Ext:] Re: Stream Replication not working Sushant Postgres 07:49
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Dominique Devienne 09:24
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Dominique Devienne 09:34
plpgsql function problem whith creating temp table - not correctly using search_path ? benj.dev 09:54
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Francisco Olarte 10:04
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Dominique Devienne 10:57
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Wolfgang Walther 11:47
Folding of case of identifiers Niels Jespersen 11:52
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Francisco Olarte 12:49
Re: plpgsql function problem whith creating temp table - not correctly using search_path ? Pavel Stehule 13:27
Re: [Ext:] Re: Stream Replication not working Amit Kapila 13:28
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Dominique Devienne 13:33
Re: plpgsql function problem whith creating temp table - not correctly using search_path ? David G. Johnston 14:18
Re: [Ext:] Re: Stream Replication not working Allie Crawford 14:47
pg_stat_statements Dirschel, Steve 15:04
Re: [Ext:] Re: Stream Replication not working Allie Crawford 15:05
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Tom Lane 15:06
Re: plpgsql function problem whith creating temp table - not correctly using search_path ? Tom Lane 15:18
Re: Folding of case of identifiers Tom Lane 15:26
Re: plpgsql function problem whith creating temp table - not correctly using search_path ? benj.dev 15:51
Re: plpgsql function problem whith creating temp table - not correctly using search_path ? Pavel Stehule 15:55
Template for schema? (as opposed to databases) Dominique Devienne 16:09
Re: Template for schema? (as opposed to databases) David G. Johnston 16:30
Re: Template for schema? (as opposed to databases) Francisco Olarte 16:38
Re: Template for schema? (as opposed to databases) Dominique Devienne 16:42
Re: Template for schema? (as opposed to databases) Dominique Devienne 16:50
Re: Template for schema? (as opposed to databases) Dominique Devienne 16:53
Re: Template for schema? (as opposed to databases) David G. Johnston 16:58
Re: DROP OWNED BY fails with #53200: ERROR: out of shared memory Adrian Klaver 17:22
Re: When Update balloons memory 📎 Peter Geoghegan 19:45
Re: When Update balloons memory Tom Lane 19:54
Re: When Update balloons memory Peter Geoghegan 19:59
Re: When Update balloons memory Peter Geoghegan 21:15

Jan. 12, 2022

Thread Author Time
Re: [Ext:] Re: Stream Replication not working Kyotaro Horiguchi 01:18
Re: pg_stat_statements Julien Rouhaud 03:03
Re: pg_stat_statements Simon Riggs 10:22
Re: pg_stat_statements Julien Rouhaud 10:31
How to read an external pdf file from postgres? Amine Tengilimoglu 11:16
Re: How to read an external pdf file from postgres? Peter Eisentraut 11:25
postgres event trigger workaround Zwettler Markus (OIZ) 11:57
WAL Archiving and base backup Issa Gorissen 12:22
Re: postgres event trigger workaround Julien Rouhaud 12:55
Re: pg_stat_statements Simon Riggs 13:17
Unable to migrate from postgres-13 to 14 Jasvant Singh 13:59
Re: How to read an external pdf file from postgres? Дмитрий Иванов 14:32
Re: How to read an external pdf file from postgres? Ian Lawrence Barwick 14:35
Re: pg_stat_statements Simon Riggs 14:43
Re: Unable to migrate from postgres-13 to 14 Tom Lane 14:55
Re: WAL Archiving and base backup Torsten Förtsch 15:26
Re: WAL Archiving and base backup Issa Gorissen 18:22
Re: When Update balloons memory Peter Geoghegan 23:44

Jan. 13, 2022

Thread Author Time
Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it Avi Weinberg 09:49
How can a Postgres SQL script be automatically run when a new table turns up? Shaozhong SHI 10:43
Re: How can a Postgres SQL script be automatically run when a new table turns up? Jayadevan M 10:50
Re: How can a Postgres SQL script be automatically run when a new table turns up? Shaozhong SHI 15:55

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 28 29 30 31