Mailing lists [pgsql-general]
- Re: Order of rows in statement triggers NEW/OLD tables Thomas Munro
- GIN theory huangning290@yahoo.com
- function currtid2() in SQL and ESQL/C to get the new CTID of a row Matthias Apitz
- Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row Tom Lane
- Extended multivariate statistics are ignored (potentially related to high null fraction, not sure) Danny Shemesh
- Re: Extended multivariate statistics are ignored (potentially related to high null fraction, not sure) Bruce Momjian
- Re: unoptimized nested loops David Rowley
- Re: unoptimized nested loops Jeff Janes
- Re: unoptimized nested loops Tom Lane
- How to display complicated Chinese character: Biang. jian he
- Re: unoptimized nested loops Tim Kelly
- Re: How to display complicated Chinese character: Biang. Laurenz Albe
- Re: Extended multivariate statistics are ignored (potentially related to high null fraction, not sure) Danny Shemesh
- Accessing composite type elements Garfield Lewis
- Re: Accessing composite type elements Tom Lane
- Re: [EXT] Re: Accessing composite type elements Garfield Lewis
- Re: unoptimized nested loops Jeff Janes
- Re: [EXT] Re: Accessing composite type elements Merlin Moncure
- Max sane value for join_collapse_limit? Andreas Joseph Krogh
- Re: GIN theory jian he
- Re: Max sane value for join_collapse_limit? Philip Semanchuk
- Re: Logically replicated table has no visible rows Jeff Ross
- Why password authentication failed for user "postgres"? BeginnerC
- Re: Why password authentication failed for user "postgres"? Reid Thompson
- '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? David G. Johnston
- Call pstrdup() of palloc.h will change source string, please help! mengfanjun
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Tom Lane
- Window function? Robert Stanford
- Re: unoptimized nested loops Tim Kelly
- Re: Window function? Thiemo Kellner
- Re: Window function? Robert Stanford
- Re: Window function? Tom Lane
- Re: Why password authentication failed for user "postgres"? Jeff Janes
- Re: Window function? David G. Johnston
- Re: Call pstrdup() of palloc.h will change source string, please help! Tom Lane
- Re: Window function? John W Higgins
- Logical replication of large objects Andreas Joseph Krogh
- Re: Why password authentication failed for user "postgres"? Frank Finner
- Re: Why password authentication failed for user "postgres"? David G. Johnston
- GSSAPI authentication Niels Jespersen
- Re: GSSAPI authentication Michael van der Kolff
- Re: GSSAPI authentication Michael van der Kolff
- SV: GSSAPI authentication Niels Jespersen
- Re: GSSAPI authentication Michael van der Kolff
- Re: GSSAPI authentication Michael van der Kolff
- Re: GSSAPI authentication Michael van der Kolff
- Re: [EXT] Re: Accessing composite type elements Garfield Lewis
- SV: GSSAPI authentication Niels Jespersen
- SQL state: 42601. Execption handling. Ц
- SQL state: 42601. Execption handling. Ц
- Re: SQL state: 42601. Execption handling. Tom Lane
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Merlin Moncure
- Re: SQL state: 42601. Execption handling. Kyotaro Horiguchi
- Jim McNamara
- Fwd: Jim McNamara
- FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_wal/0000000x.history": No such file or directory pgdba pgdba
- gawk extension linux missing stuff in package manager fedora 36 Jim McNamara
- Re: gawk extension linux missing stuff in package manager fedora 36 Daniel Verite
- Re: Ian Lawrence Barwick
- Re: FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_wal/0000000x.history": No such file or directory Kyotaro Horiguchi
- Sharing DSA pointer between parallel workers after they've been created Ma, Marcus
- Fwd: message log merge (streaming replication) Peter Adlersburg
- Re: message log merge (streaming replication) Ian Lawrence Barwick
- Re: message log merge (streaming replication) Kyotaro Horiguchi
- Cluster OID Limit Lucas
- A function to find errors in groups in a table Shaozhong SHI
- Re: Cluster OID Limit Tom Lane
- Re: Cluster OID Limit Adrian Klaver
- Re: Cluster OID Limit SERHAD ERDEM
- Re: Cluster OID Limit Joshua Drake
- Re: Sharing DSA pointer between parallel workers after they've been created Joshua Drake
- Re: Logical replication of large objects Joshua Drake
- Re: Logical replication of large objects Andreas Joseph Krogh
- Re: cast to domain with default collation issue. David G. Johnston
- Re: Row level security insert policy does not validate update new values/content? David G. Johnston
- How to drop a subscription inside a stored procedure? Thomas Kellerer
- Re: How to drop a subscription inside a stored procedure? Adrian Klaver
- multiple entries for synchronous_standby_names Nitesh Nathani
- How to get response message Rama Krishnan
- Re: How to get response message Adrian Klaver
- Re: How to get response message Francisco Olarte
- Re: How to get response message David G. Johnston
- Need optimization in query Shubham Mittal
- Re: How to drop a subscription inside a stored procedure? Thomas Kellerer
- newbie db design question Rino Mardo
- Re: newbie db design question Gavan Schneider
- Re: newbie db design question Ray O'Donnell
- Re: newbie db design question Peter J. Holzer
- PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Markur Sens
- Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Tom Lane
- Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Markur Sens
- Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P Tom Lane
- Re: newbie db design question Rino Mardo
- "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Bryn Llewellyn
- Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Pavel Stehule
- Re: Need optimization in query Shubham Mittal
- Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Bryn Llewellyn
- Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Pavel Stehule
- Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Tom Lane
- Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Christophe Pettus
- Tools to convert timestamp data to another time zone in PostgreSQL Joel Rabinovitch
- Re: Tools to convert timestamp data to another time zone in PostgreSQL Adrian Klaver
- Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" Bryn Llewellyn
- Re: multiple entries for synchronous_standby_names Michael Paquier
- RE: Build Postgres On AIX Mark Hill
- Re: Tools to convert timestamp data to another time zone in PostgreSQL Ilya Anfimov
- Postgres NOT IN vs NOT EXISTS optimization Dirschel, Steve
- Re: Postgres NOT IN vs NOT EXISTS optimization Jeremy Smith
- Re: Postgres NOT IN vs NOT EXISTS optimization Tom Lane
- Recent 11.16 release change Daniel Brinzila
- Re: Recent 11.16 release change Tom Lane
- Re: Recent 11.16 release change Daniel Brinzila
- Re: cast to domain with default collation issue. Tom Lane
- PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ian Dauncey
- Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ray O'Donnell
- RE: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ian Dauncey
- Automatic autovacuum to prevent wraparound - PG13.5 Mauro Farracha
- Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ray O'Donnell
- Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Tom Lane
- Re: Automatic autovacuum to prevent wraparound - PG13.5 Laurenz Albe
- Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Adrian Klaver
- Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Imre Samu
- ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] David G. Johnston
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] David G. Johnston
- Rama Krishnan
- Re: Adrian Klaver
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] Tom Lane
- Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Daniel Popowich
- Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Tom Lane
- Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Bryn Llewellyn
- Re: Abdul Qoyyuum
- Any way to understand state after data corruption failures during startup. Harinath Kanchu
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] David G. Johnston
- Re: Any way to understand state after data corruption failures during startup. Kyotaro Horiguchi
- Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] Bryn Llewellyn
- Re: Postgresql error : PANIC: could not locate a valid checkpoint record Mateusz Henicz
- RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team
- Re: Postgresql error : PANIC: could not locate a valid checkpoint record Mateusz Henicz
- Re: Postgresql error : PANIC: could not locate a valid checkpoint record Laurenz Albe
- Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Daniel Popowich
- Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type Pavel Stehule
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn
- ISBN (was: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?) Peter J. Holzer
- Re: ERROR: failed to find conversion function from key_vals_nn to record[] Peter J. Holzer
- Re: Peter J. Holzer
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Alban Hertroys
- Re: ISBN (was: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?) Bryn Llewellyn
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? jian he
- Index creation Дмитрий Иванов
- Re: Index creation David G. Johnston
- Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") Bryn Llewellyn
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Thomas Kellerer
- Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") Tom Lane
- Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") David G. Johnston
- Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? Bryn Llewellyn
- A error happend when I am clone the git repository Wen Yi
- Re: A error happend when I am clone the git repository Adrian Klaver
- Re: A error happend when I am clone the git repository Tom Lane
- Re: Index creation Дмитрий Иванов
- AIX and EAGAIN on open() Christoph Berg
- RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team
- Re: Index creation Jeff Janes
- Re: A error happend when I am clone the git repository Magnus Hagander
- accessing postgres from c++ Rino Mardo
- Re: Index creation Дмитрий Иванов
- How to use 32 bit ODBC driver Aditya Bhardwaj
- Re: accessing postgres from c++ Laurenz Albe
- Re: accessing postgres from c++ Dominique Devienne
- INSERT ALL with DML ERROR Logging replacement in PostgreSQL Jagmohan Kaintura
- Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Gilles Darold
- Re: accessing postgres from c++ Matthias Apitz
- Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Jagmohan Kaintura
- Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Gilles Darold
- Reminder: Call for Papers for PostgreSQL Conference Europe 2022 is closing soon! Andreas 'ads' Scherbaum
- RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team
- Re: Postgresql error : PANIC: could not locate a valid checkpoint record Mateusz Henicz
- Re: accessing postgres from c++ Rino Mardo
- Re: How to use 32 bit ODBC driver Rino Mardo
- Re: How to use 32 bit ODBC driver Adrian Klaver
- Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row Matthias Apitz
- Source code test data folder don't have CSV files. How to get the CSV file. jian he
- RE: How to use 32 bit ODBC driver Aditya Bhardwaj
- RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team
- RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team
- PostgreSQL with Patroni not replicating to all nodes after adding 3rd node (another secondary) Zb B
- ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Adrian Klaver
- Tuning a query with ORDER BY and LIMIT Dirschel, Steve
- Re: Tuning a query with ORDER BY and LIMIT Michael van der Kolff
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek
- Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer
- Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer
- Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer
- Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer
- Re: Tuning a query with ORDER BY and LIMIT Tom Lane
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tom Lane
- Re: Tuning a query with ORDER BY and LIMIT Jeff Janes
- Re: Tuning a query with ORDER BY and LIMIT Jeff Janes
- Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row Matthias Apitz
- Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL Jagmohan Kaintura
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek
- Differences in Escaped bytea's when creating a plain pg_dump WR
- Re: Differences in Escaped bytea's when creating a plain pg_dump WR
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Adrian Klaver
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Adrian Klaver
- Re: Differences in Escaped bytea's when creating a plain pg_dump Daniel Verite
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tomas Pospisek
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Peter Eisentraut
- RE: Postgresql error : PANIC: could not locate a valid checkpoint record Mahendrakar, Prabhakar - Dell Team
- Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8) Tom Lane
- Re: Automatic autovacuum to prevent wraparound - PG13.5 Ninad Shah
- Re: Automatic autovacuum to prevent wraparound - PG13.5 Peter Geoghegan
- Re: Tuning a query with ORDER BY and LIMIT Peter J. Holzer
- Question about attention to pgsql-hackers@lists.postgresql.org A Z
- Re: Question about attention to pgsql-hackers@lists.postgresql.org Laurenz Albe
- Re: Question about attention to pgsql-hackers@lists.postgresql.org Julien Rouhaud
- Re: Question about attention to pgsql-hackers@lists.postgresql.org Mladen Gogala
- How can I set up Postgres to use given amount of RAM? W.P.
- Re: How can I set up Postgres to use given amount of RAM? Zahid Rahman
- Re: How can I set up Postgres to use given amount of RAM? Mladen Gogala
- Re: Postgresql error : PANIC: could not locate a valid checkpoint record Michael Paquier
- Re: Differences in Escaped bytea's when creating a plain pg_dump WR
- Sv: How can I set up Postgres to use given amount of RAM? Andreas Joseph Krogh
- Re: Differences in Escaped bytea's when creating a plain pg_dump WR
- Re: Differences in Escaped bytea's when creating a plain pg_dump David G. Johnston
- Table space not returned to the OS ? Florents Tselai
- Re: Differences in Escaped bytea's when creating a plain pg_dump Wolfgang Rißler
- Re: Table space not returned to the OS ? Magnus Hagander
- Re: Table space not returned to the OS ? Thomas Boussekey
- help for pg_wal issue Özge Özyavuz
- Re: Table space not returned to the OS ? Florents Tselai
- Re: Table space not returned to the OS ? Laurenz Albe
- Re: Differences in Escaped bytea's when creating a plain pg_dump Daniel Verite
- Re: help for pg_wal issue Laurenz Albe
- Re: Question about attention to pgsql-hackers@lists.postgresql.org Imre Samu
- Re: Differences in Escaped bytea's when creating a plain pg_dump Wolfgang Rißler
- Different sort result between PostgreSQL 8.4 and 12.5 gzh
- Re: Different sort result between PostgreSQL 8.4 and 12.5 Magnus Hagander
- Unique index prohibits partial aggregates Bos, Fred
- Re: Table space not returned to the OS ? Magnus Hagander
- Libpq question related to allocated resources Karl Denninger
- Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]") Bryn Llewellyn
- Re: Unique index prohibits partial aggregates David Rowley
- Re: Libpq question related to allocated resources Tom Lane
- Re:Re: Different sort result between PostgreSQL 8.4 and 12.5 gzh
- Re: help for pg_wal issue Kyotaro Horiguchi
- Re: help for pg_wal issue Kyotaro Horiguchi
- GIN index operator ?(jsonb,text) not working? jian he
- Re: Libpq question related to allocated resources Karl Denninger
- RE: Unique index prohibits partial aggregates Bos, Fred
- Re: Unique index prohibits partial aggregates David Rowley
- User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn
- Re: User's responsibility when using a chain of "immutable" functions? Christophe Pettus
- Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston
- Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn
- Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule
- Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston
- Re: User's responsibility when using a chain of "immutable" functions? Tom Lane
- Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule
- Re: User's responsibility when using a chain of "immutable" functions? Tom Lane
- Re: User's responsibility when using a chain of "immutable" functions? Laurenz Albe
- Re: User's responsibility when using a chain of "immutable" functions? Pavel Stehule
- Re: User's responsibility when using a chain of "immutable" functions? Christophe Pettus
- RE: help for pg_wal issue Özge Özyavuz
- Question on pg_auto_failover extension DAN LU
- Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn
- Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston
- Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn
- Re: User's responsibility when using a chain of "immutable" functions? David G. Johnston
- Function inside query status Rama Krishnan
- Fatel: unsupported frientend protocol error eswar reddy
- Re: Fatel: unsupported frientend protocol error Laurenz Albe
- Re: Fatel: unsupported frientend protocol error David G. Johnston
- pg_amcheck warnings after upgrade to 14.4 Aleš Zelený
- Re: Fatel: unsupported frientend protocol error Tom Lane
- Re: Function inside query status Adrian Klaver
- Re: User's responsibility when using a chain of "immutable" functions? Bryn Llewellyn