Home > mailing lists

Mailing lists [pgsql-general]

1 March 2022

11:18 Require details that can we set characters length of a password to a User account in PostgreSQL Database. Sonai muthu raja M
14:49 Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database. Laurenz Albe
15:46 Re: Require details that can we set characters length of a password to a User account in PostgreSQL Database. Sonai muthu raja M

2 March 2022

12:14 How to log to client (port native code to stored procedure)? Durumdara
15:21 PostgreSQL Upgrade with Replication managed via repmgr DAN LU

3 March 2022

03:28 Re: PostgreSQL Upgrade with Replication managed via repmgr Ian Lawrence Barwick
10:29 Power loss test Levente Birta
10:46 Postgres Wal Full pgdba pgdba
11:04 Re: Postgres Wal Full Andreas Kretschmer
11:22 Re: Postgres Wal Full Kyotaro Horiguchi
11:47 Ynt: Postgres Wal Full pgdba pgdba
12:50 Re: Postgres Wal Full Bharath Rupireddy
13:02 Couldn't cast to record[] Suresh Kumar R
13:16 Re: Couldn't cast to record[] Pavel Stehule
17:26 oid2name: Why table and not relation? Daniel Westermann (DWE)
18:04 Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski
18:11 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski
18:48 Re: Couldn't cast to record[] Tom Lane
19:39 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski
19:44 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski
20:54 Re: Power loss test Bruce Momjian

4 March 2022

16:10 Looking for tips on improving full-text search quality in Postgres Bayer, Samuel
18:25 Re: Looking for tips on improving full-text search quality in Postgres Bruce Momjian
18:28 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Bayer, Samuel
18:30 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Atri Sharma
18:41 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Bayer, Samuel
18:54 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Bruce Momjian
19:09 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Tom Lane
19:39 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Bayer, Samuel
19:43 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Tom Lane
19:44 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Bruce Momjian
19:45 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Bruce Momjian
19:52 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Atri Sharma
19:53 Re: [EXT] Re: Looking for tips on improving full-text search quality in Postgres Bruce Momjian
20:58 Re: Couldn't cast to record[] Merlin Moncure
22:09 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal Tom Lane
23:45 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski

5 March 2022

01:03 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal Tom Lane
05:42 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal Mladen Gogala
05:48 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal Tom Lane
10:33 Re: Couldn't cast to record[] Suresh Kumar R
14:07 REG:DR DRILL obi reddy
18:29 Re: Couldn't cast to record[] Tom Lane

6 March 2022

17:04 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski
19:10 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal Tom Lane
19:36 FDW to postGIS Database Susan Hurst
21:41 Do you know a json_populate_record alternative method to create a ROW with a named field notation? Stéphane Klein
21:54 Re: Do you know a json_populate_record alternative method to create a ROW with a named field notation? Tom Lane

7 March 2022

04:35 Re: FDW to postGIS Database Brent Wood
16:03 Re: FDW to postGIS Database Susan Hurst
18:11 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski
20:22 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal Tom Lane
20:46 Getting more detail in plpython error messages Jeff Ross
20:54 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal Andres Freund
21:06 Re: Getting more detail in plpython error messages Tom Lane
21:12 Re: Getting more detail in plpython error messages Jeff Ross
22:35 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski

8 March 2022

02:57 Re: ERROR: extra data after last expected column Rob Sargent
04:42 Re: ERROR: extra data after last expected column Ron
12:44 A simple question: Why 'pg_ctl: command not found...' ? BeginnerC
12:50 Re: A simple question: Why 'pg_ctl: command not found...' ? Laurenz Albe
16:29 Serializable read only deferrable- implications Michael Lewis
19:03 Re: A simple question: Why 'pg_ctl: command not found...' ? Adrian Klaver
19:04 Re: Serializable read only deferrable- implications Laurenz Albe
19:16 Re: Serializable read only deferrable- implications Michael Lewis
19:21 Re: Serializable read only deferrable- implications Tom Lane
19:27 Re: Serializable read only deferrable- implications Adrian Klaver
21:47 Re: Serializable read only deferrable- implications Michael Lewis
22:56 Re: Serializable read only deferrable- implications Adrian Klaver
23:15 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal hubert depesz lubaczewski
23:17 Re: Serializable read only deferrable- implications David G. Johnston

9 March 2022

10:03 Postgres migration from 9.2 to 14 Lucas

10 March 2022

04:40 Simple Query Doesn't Even with Data Scott Macri
08:33 Could not read certificate file from while upgrading to PostgreSQLClient 12.9 M Tarkeshwar Rao
11:20 Re: Simple Query Doesn't Even with Data Julien Rouhaud
11:30 Re: Simple Query Doesn't Even with Data Ken Tanzer
16:51 primary_conninfo and restore_command ? Luca Ferrari
17:04 Re: primary_conninfo and restore_command ? Julien Rouhaud
17:09 PQresultMemorySize of ResultSet larger than expected Dominique Devienne
17:27 Re: primary_conninfo and restore_command ? Bharath Rupireddy
18:00 Re: PQresultMemorySize of ResultSet larger than expected Tom Lane
18:44 foreign key on delete cascade order? George Woodring
18:56 Re: foreign key on delete cascade order? Tom Lane
19:18 [pgpool] invalid read kind Peter Juhasz
20:32 Re: foreign key on delete cascade order? George Woodring
20:38 Re: foreign key on delete cascade order? Tom Lane

11 March 2022

11:53 Am I in the same transaction block in complex PLPGSQL? Durumdara
13:02 Postgres query Ian Dauncey
13:57 Re: Postgres query hubert depesz lubaczewski
17:48 Re: foreign key on delete cascade order? George Woodring
18:01 Re: Am I in the same transaction block in complex PLPGSQL? Tom Lane
19:24 Re: Am I in the same transaction block in complex PLPGSQL? Durumdara
20:56 COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines Dominique Devienne
21:28 Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines David G. Johnston
21:37 Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines Daniel Verite
21:58 Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines Dominique Devienne
22:32 Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines Daniel Verite
23:16 Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines Dominique Devienne

12 March 2022

06:03 Re: foreign key on delete cascade order? Michael Lewis
08:23 Re: Am I in the same transaction block in complex PLPGSQL? David G. Johnston

13 March 2022

11:41 Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines Francisco Olarte
11:53 Re: COPY TO STDOUT WITH (FORMAT CSV, HEADER), and embedded newlines Francisco Olarte
17:44 delete query using CTE Roger Bos
17:50 Re: delete query using CTE Michael Lewis
17:52 Re: delete query using CTE David G. Johnston
19:06 Re: delete query using CTE Roger Bos
20:05 Re: delete query using CTE benj.dev@laposte.net

14 March 2022

08:13 Indexes that would span partitions. Tim Uckun
15:53 LISTEN/NOTIFY ultra slow speed Арсен Арутюнян
16:39 Restoring using PG_DUMP in PG12 results in Shukla, Pranjal
17:55 Re: Restoring using PG_DUMP in PG12 results in Adrian Klaver
18:29 Re: LISTEN/NOTIFY ultra slow speed Tom Lane
22:59 Re: foreign key on delete cascade order? George Woodring

15 March 2022

09:18 Re: Indexes that would span partitions. Michael Lewis
09:42 Re: Restoring using PG_DUMP in PG12 results in Shukla, Pranjal
10:20 Postgres Crash Issue Sankar, Uma (Uma)
10:32 Re: Indexes that would span partitions. Tim Uckun
10:34 Re: LISTEN/NOTIFY ultra slow speed Арсен Арутюнян
13:39 Re[2]: LISTEN/NOTIFY ultra slow speed Арсен Арутюнян
16:27 Re: Postgres Crash Issue hubert depesz lubaczewski
16:30 RE: [External]Re: Postgres Crash Issue Menon, Deepak (Deepak)
16:32 Re: [External]Re: Postgres Crash Issue hubert depesz lubaczewski
16:38 RE: [External]Re: Postgres Crash Issue Menon, Deepak (Deepak)
16:42 Re: [External]Re: Postgres Crash Issue hubert depesz lubaczewski
17:17 Re: [External]Re: Postgres Crash Issue Tom Lane
17:32 Re: Re[2]: LISTEN/NOTIFY ultra slow speed Tom Lane
18:49 Re: Restoring using PG_DUMP in PG12 results in Adrian Klaver
19:01 Corrupt Index Jorel Casal
19:41 Re: Corrupt Index Tom Lane
20:40 Re: [External]Re: Postgres Crash Issue Adrian Klaver
23:48 Re[4]: LISTEN/NOTIFY ultra slow speed Арсен Арутюнян

16 March 2022

23:15 Apparently table locks are the key issue to see red flags Shaozhong SHI
23:21 Re: Apparently table locks are the key issue to see red flags Ron
23:23 Re: Apparently table locks are the key issue to see red flags Adrian Klaver
23:30 How to explicitly lock and unlock tables in pgsql? Shaozhong SHI
23:35 Re: How to explicitly lock and unlock tables in pgsql? Fabrízio de Royes Mello

17 March 2022

10:51 Re: How to explicitly lock and unlock tables in pgsql? Laurenz Albe
13:38 Re: PSQL bug? Pavel Stehule
13:38 PSQL bug? Dominique Devienne
14:09 Re: PSQL bug? Dominique Devienne
14:32 Re: PSQL bug? Josef Šimánek
15:36 Query on WAL Optimization and Streaming Replication Shukla, Pranjal
15:58 High Postgres postmaster CPU when My Background Worker is loaded. GoLang Developere
16:19 Re: Query on WAL Optimization and Streaming Replication Laurenz Albe
17:05 Re: Query on WAL Optimization and Streaming Replication Shukla, Pranjal
17:38 Re: Query on WAL Optimization and Streaming Replication Laurenz Albe
18:21 Re: Query on WAL Optimization and Streaming Replication Shukla, Pranjal
21:34 Re[5]: LISTEN/NOTIFY ultra slow speed Арсен Арутюнян

18 March 2022

03:52 Re: PSQL bug? Kyotaro Horiguchi
19:38 Re: How to explicitly lock and unlock tables in pgsql? Merlin Moncure

19 March 2022

01:48 Re: How to explicitly lock and unlock tables in pgsql? Laurenz Albe

22 March 2022

01:15 Can you install/run postgresql on a FIPS enabled host? McDermott, Becky
01:24 Re: Can you install/run postgresql on a FIPS enabled host? Adrian Klaver
01:33 Re: Can you install/run postgresql on a FIPS enabled host? Tom Lane
01:43 RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky
01:45 Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Adrian Klaver
01:47 RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky
01:52 RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky
01:55 RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky
01:57 Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Rob Sargent
01:59 Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Tom Lane
02:02 RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky
02:08 Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Rob Sargent
02:16 RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky
12:45 PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause PALAYRET Jacques
13:16 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause Torsten Förtsch
13:42 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause Guillaume Lelarge
14:32 PG12: Any drawback of increasing wal_keep_segments Shukla, Pranjal
15:42 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause David G. Johnston
15:48 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause PALAYRET Jacques
16:04 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause David G. Johnston
18:03 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause PALAYRET Jacques
18:26 Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause David Rowley

23 March 2022

07:19 Re: Can you install/run postgresql on a FIPS enabled host? Michael Paquier
14:48 Open SSL Version Query Sahaj Diwan
17:23 Re: Open SSL Version Query Laura Smith
19:56 Unexpected zero results Viliam Ďurina
20:00 Re: Unexpected zero results Thomas Kellerer
20:10 Re: Unexpected zero results Viliam Ďurina

24 March 2022

01:51 Re: Unexpected zero results David G. Johnston
01:57 Re: Unexpected zero results Tom Lane
13:25 Re: PG12: Any drawback of increasing wal_keep_segments Alvaro Herrera
18:49 Get primary key of a table through SPI Oskar Stenberg
18:59 Re: Get primary key of a table through SPI Tom Lane

25 March 2022

18:32 Leading comments and client applications Philip Semanchuk
18:46 Re: Leading comments and client applications David G. Johnston
18:59 Re: Leading comments and client applications Tom Lane
19:25 Re: Leading comments and client applications Rob Sargent
20:37 Re: Leading comments and client applications Peter J. Holzer
21:05 Re: Leading comments and client applications Philip Semanchuk
22:30 Re: Leading comments and client applications Tom Lane
22:35 Re: Leading comments and client applications Rob Sargent

26 March 2022

08:08 Re: Leading comments and client applications Laurenz Albe
12:35 dynamically generate path to output file robert@redo2oo.ch
15:12 In what situation, a line feature could not be visible in PgAdmin? Shaozhong SHI
15:48 Re: dynamically generate path to output file Osvaldo Kussama

27 March 2022

13:54 support for DIN SPEC 91379 encoding Marco Lechner
17:14 Re: support for DIN SPEC 91379 encoding Ralf Schuchardt
19:30 Performance issues on FK Triggers after replacing a primary column Per Kaminsky
20:47 Re: support for DIN SPEC 91379 encoding Alvaro Herrera
21:06 Re: support for DIN SPEC 91379 encoding Tom Lane
21:08 Re: support for DIN SPEC 91379 encoding Bzm@g

28 March 2022

00:22 Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver
02:34 Re: support for DIN SPEC 91379 encoding Peter J. Holzer
09:53 Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky
10:22 Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky
11:13 Re: support for DIN SPEC 91379 encoding Alvaro Herrera
11:49 Will using subtransactions will come back to bite me? Kannan Goundan
12:42 Re: Leading comments and client applications Philippe Doussot
17:07 Re: Performance issues on FK Triggers after replacing a primary column Tom Lane
18:31 Re: Will using subtransactions will come back to bite me? Laurenz Albe
18:41 Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver
18:47 Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky
18:59 Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver
19:39 Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky
19:41 Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver
19:49 Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver
20:35 Re: Leading comments and client applications Philip Semanchuk
20:49 Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky
20:56 Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver

29 March 2022

08:05 Indexes in JSONB Saurav Sarkar
11:49 Re: Indexes in JSONB Magnus Hagander
17:32 Re: Indexes in JSONB Michael Lewis
18:12 Re: Indexes in JSONB Saurav Sarkar
18:17 Re: PG12: Any drawback of increasing wal_keep_segments Stephen Frost
21:05 Why is my function inlined only when STABLE? Philip Semanchuk
21:24 Re: Why is my function inlined only when STABLE? Tom Lane
21:43 Re: Why is my function inlined only when STABLE? Philip Semanchuk

30 March 2022

04:30 psql -f and PAGER Paul Jungwirth
05:08 Re: psql -f and PAGER David G. Johnston
06:09 Reg: User creation script/List of privileges Sai Ch
09:57 Re: psql -f and PAGER Peter J. Holzer
19:19 Re: Reg: User creation script/List of privileges Tomas Pospisek

31 March 2022

17:01 PostgreSQL on focal and llvm version Christoph Berg
17:01 PostgreSQL on focal and llvm version Christoph Berg
19:58 Re: PG12: Any drawback of increasing wal_keep_segments Marc
19:59 Re: PG12: Any drawback of increasing wal_keep_segments Stephen Frost