pgsql-general since 2022-01-05 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

Browse Archives

Prev | Next

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
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
Re: Using FOREIGN TABLE to get the Size of the Actual Remote Table Behind it	Laurenz Albe	19:22
Assistance with an out of shared memory error 📎	Gautam Bellary	21:30
Re: Assistance with an out of shared memory error	Tom Lane	23:35

Jan. 14, 2022

Thread	Author	Time
Re: How can a Postgres SQL script be automatically run when a new table turns up?	David G. Johnston	00:31
AW: [Extern] Re: postgres event trigger workaround	Zwettler Markus (OIZ)	09:01
Re: [Extern] Re: postgres event trigger workaround	Dominique Devienne	10:22
Re: [Extern] Re: postgres event trigger workaround	Julien Rouhaud	10:23
List all tables from a specific database	Flaviu2	10:39
Re: List all tables from a specific database	Ray O'Donnell	11:04
Re: List all tables from a specific database	Thomas Boussekey	12:08
Re: List all tables from a specific database	Flaviu2	12:19
Re: List all tables from a specific database	Julien Rouhaud	12:26
Re: List all tables from a specific database	Flaviu2	12:42
Re: List all tables from a specific database	Ray O'Donnell	12:45
Re: List all tables from a specific database	Flaviu2	12:51
Re: List all tables from a specific database	Ray O'Donnell	12:53
Upgrade 13 to 14 with replication of partitioned table	Sergey Belyashov	12:53
Re: How can a Postgres SQL script be automatically run when a new table turns up?	Miles Elam	14:31
Re: WAL Archiving and base backup	Stephen Frost	18:31
Re: WAL Archiving and base backup	Ron	19:27
Re: WAL Archiving and base backup	Stephen Frost	19:40
Re: WAL Archiving and base backup	Ron	20:48
Re: WAL Archiving and base backup	David G. Johnston	21:00
Re: WAL Archiving and base backup	Daniel Westermann (DWE)	21:04
Re: WAL Archiving and base backup	Adrian Klaver	21:42

Jan. 15, 2022

Thread	Author	Time
Re: Assistance with an out of shared memory error	Gautam Bellary	02:25
Re: [Extern] Re: postgres event trigger workaround	Дмитрий Иванов	03:36

Browse Archives

Prev | Next