pgsql-general since 2021-12-26 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

Dec. 26, 2021

Thread Author Time
Wal files in /pgsql/14/main/pg_wal not removed Lucas 12:09
Re: storing zipped SQLite inside PG ? amihay gonen 12:43
Re: Wal files in /pgsql/14/main/pg_wal not removed Tom Lane 16:14
Re: Wal files in /pgsql/14/main/pg_wal not removed Lucas 23:09

Dec. 27, 2021

Thread Author Time
Deprecating plans for PGPASSWORD environment variable as insecure Alexey Murz Korepov 08:55
Re: Deprecating plans for PGPASSWORD environment variable as insecure Pavel Stehule 09:03
Logical Replication - One table 8 minutes, Identical Two Tables 28 Minutes (Expected 16 Minutes) Avi Weinberg 13:35

Dec. 28, 2021

Thread Author Time
psql command failing with error "undefined symbol: PQhostaddr" Narendra katlamudi 12:29
Re: psql command failing with error "undefined symbol: PQhostaddr" Osvaldo Kussama 12:44
Re: psql command failing with error "undefined symbol: PQhostaddr" Pavel Stehule 12:52
Re: psql command failing with error "undefined symbol: PQhostaddr" Adrian Klaver 15:54

Dec. 29, 2021

Thread Author Time
Re: psql command failing with error "undefined symbol: PQhostaddr" Narendra katlamudi 08:31
Initial Sync - One Subscriber After The Other vs. Parallel Avi Weinberg 12:39
Find missing data in a column john polo 17:43
Find missing data in a column David G. Johnston 17:54
Re: Find missing data in a column Adrian Klaver 17:56
Re: Find missing data in a column Adrian Klaver 18:07
Re: Find missing data in a column Rob Sargent 18:10
Re: Find missing data in a column Adrian Klaver 18:16
Re: Find missing data in a column Alan Hodgson 18:36
csv copy error ourdiaspora 21:08
Re: csv copy error Adrian Klaver 21:15
Re: csv copy error David G. Johnston 21:46
Default values in functions Michael Lewis 22:59
Re: Default values in functions Tom Lane 23:31
Re: Default values in functions David G. Johnston 23:34

Dec. 30, 2021

Thread Author Time
Re: Default values in functions Michael Lewis 00:17
Re: Default values in functions Michael Lewis 00:22
Re: Default values in functions Tom Lane 00:28
Re: Default values in functions Tom Lane 00:31
Re: Default values in functions Michael Lewis 00:46
Re: Find missing data in a column john polo 02:09
pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq 07:09
Re: csv copy error Guillaume Lelarge 07:30
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Magnus Hagander 09:48

Dec. 31, 2021

Thread Author Time
Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 Hasan Marzooq 02:32
Re: csv copy error ourdiaspora 10:03
create query with date values ourdiaspora 13:12
Re: create query with date values Ron 15:34
Re: create query with date values David G. Johnston 16:24
a very naive question about table names in Postgres Martin Mueller 20:27
Re: a very naive question about table names in Postgres Craig McIlwee 20:36
Re: a very naive question about table names in Postgres Gavin Flower 20:40
Re: a very naive question about table names in Postgres Craig McIlwee 20:41
Re: a very naive question about table names in Postgres Karsten Hilbert 21:06
Re: a very naive question about table names in Postgres Josef Šimánek 21:17
Re: a very naive question about table names in Postgres Paul Jungwirth 21:25

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? David G. Johnston 07:00
Re: How to write such a query? Ron 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

Browse Archives

Prev | Next