Postgresql General Discussion

• Thread Index

• Database designs
  • From: Zahid Rahman
• Re: - operator overloading not giving expected result
  • From: Ravi Krishna
• Re: Error when pasting function blocks into psql
  • From: Tom Lane
• Re: - operator overloading not giving expected result
  • From: Tom Lane
• Re: - operator overloading not giving expected result
  • From: Christoph Moench-Tegeder
• Re: - operator overloading not giving expected result
  • From: Francisco Olarte
• Re: CPU is 100% azure rds postgreSQL-11
  • From: Sunil Thakur
• Re: Error when pasting function blocks into psql
  • From: Francisco Olarte
• Re: postgresql bug
  • From: Christoph Moench-Tegeder
• Re: postgresql generate ddl returns FK with `<?>()` in it
  • From: Francisco Olarte
• Re: postgresql generate ddl returns FK with `<?>()` in it
  • From: Peter J. Holzer
• Re: postgresql bug
  • From: Laurenz Albe
• Re: - operator overloading not giving expected result
  • From: Peter J. Holzer
• postgresql bug
  • From: ml
• CPU is 100% azure rds postgreSQL-11
  • From: Pavan Kumar S
• Why does pg_statio_user_tables report heap_blks_hit after index only scan?
  • From: Aleksander Łukasz
• Error when pasting function blocks into psql
  • From: Ludwig Isaac Lim
• postgresql generate ddl returns FK with `<?>()` in it
  • From: Roman Gavrilov
• RE: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mahendrakar, Prabhakar - Dell Team
• - operator overloading not giving expected result
  • From: Rajesh S
• Re: About revoking large number of privileges; And the PUBLIC role.
  • From: Peter J. Holzer
• Re: Seems to be impossible to set a NULL search_path
  • From: Peter J. Holzer
• Re: About revoking large number of privileges; And the PUBLIC role.
  • From: Laurenz Albe
• Re: About revoking large number of privileges; And the PUBLIC role.
  • From: Dominique Devienne
• Re: About revoking large number of privileges; And the PUBLIC role.
  • From: Tom Lane
• About revoking large number of privileges; And the PUBLIC role.
  • From: Dominique Devienne
• Re: database designs ERDs
  • From: Zahid Rahman
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: Seems to be impossible to set a NULL search_path
  • From: David G. Johnston
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: Seems to be impossible to set a NULL search_path
  • From: Rob Sargent
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: Seems to be impossible to set a NULL search_path
  • From: David G. Johnston
• Re: lifetime of the old CTID
  • From: Adrian Klaver
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: Seems to be impossible to set a NULL search_path
  • From: David G. Johnston
• Re: lifetime of the old CTID
  • From: Christophe Pettus
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• Re: lifetime of the old CTID
  • From: Ron
• Re: Multiple Indexes
  • From: David Rowley
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: lifetime of the old CTID
  • From: Karsten Hilbert
• Re: Seems to be impossible to set a NULL search_path
  • From: David G. Johnston
• Re: Seems to be impossible to set a NULL search_path
  • From: David G. Johnston
• Re: Seems to be impossible to set a NULL search_path
  • From: Christophe Pettus
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Multiple Indexes
  • From: DAVID ROTH
• Re: lifetime of the old CTID
  • From: Ilya Anfimov
• Re: Seems to be impossible to set a NULL search_path
  • From: Adrian Klaver
• Re: Seems to be impossible to set a NULL search_path
  • From: David G. Johnston
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Francisco Olarte
• Re: lifetime of the old CTID
  • From: Peter J. Holzer
• Re: lifetime of the old CTID
  • From: Alvaro Herrera
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Alvaro Herrera
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Florents Tselai
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Florents Tselai
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Francisco Olarte
• Re: unable to understand query result
  • From: Stefan Froehlich
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Florents Tselai
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Florents Tselai
• Re: lifetime of the old CTID
  • From: Karsten Hilbert
• Re: lifetime of the old CTID
  • From: Karsten Hilbert
• Re: unable to understand query result
  • From: Peter Eisentraut
• Re: ADD COLUMN ts tsvector GENERATED too slow
  • From: Peter Eisentraut
• unable to understand query result
  • From: Stefan Froehlich
• ADD COLUMN ts tsvector GENERATED too slow
  • From: Florents Tselai
• Re: How to upgrade postgres version 8 to 13
  • From: Laurenz Albe
• Re: lifetime of the old CTID
  • From: Laurenz Albe
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• Re: lifetime of the old CTID
  • From: Andreas Kretschmer
• Re: lifetime of the old CTID
  • From: Andreas Kretschmer
• Re: lifetime of the old CTID
  • From: Christophe Pettus
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• RE: General Inquiry
  • From: Cloete, F. (Francois)
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: How to upgrade postgres version 8 to 13
  • From: shashidhar Reddy
• Re: Seems to be impossible to set a NULL search_path
  • From: David G. Johnston
• Re: General Inquiry
  • From: Kyotaro Horiguchi
• Re: Seems to be impossible to set a NULL search_path
  • From: Adrian Klaver
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: Seems to be impossible to set a NULL search_path
  • From: Tom Lane
• Re: Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: How to upgrade postgres version 8 to 13
  • From: Michael Nolan
• Re: Seems to be impossible to set a NULL search_path
  • From: Adrian Klaver
• Re: Seems to be impossible to set a NULL search_path
  • From: Pavel Stehule
• Re: Seems to be impossible to set a NULL search_path
  • From: Christophe Pettus
• Re: Seems to be impossible to set a NULL search_path
  • From: Adrian Klaver
• Re: How to upgrade postgres version 8 to 13
  • From: David G. Johnston
• Seems to be impossible to set a NULL search_path
  • From: Bryn Llewellyn
• Re: How to upgrade postgres version 8 to 13
  • From: Adrian Klaver
• Re: How to upgrade postgres version 8 to 13
  • From: shashidhar Reddy
• Re: How to upgrade postgres version 8 to 13
  • From: Adrian Klaver
• Re: How to upgrade postgres version 8 to 13
  • From: Adrian Klaver
• How to upgrade postgres version 8 to 13
  • From: shashidhar Reddy
• Re: lifetime of the old CTID
  • From: Laurenz Albe
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• Re: lifetime of the old CTID
  • From: Laurenz Albe
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• Re: lifetime of the old CTID
  • From: Matthias Apitz
• Re: General Inquiry
  • From: Tim Clarke
• General Inquiry
  • From: Cloete, F. (Francois)
• Re: lifetime of the old CTID
  • From: Laurenz Albe
• lifetime of the old CTID
  • From: Matthias Apitz
• Re: Getting data from a record variable dynamically
  • From: Alban Hertroys
• Re: Getting data from a record variable dynamically
  • From: David G. Johnston
• Getting data from a record variable dynamically
  • From: Rhys A.D. Stewart
• Re: AIX and EAGAIN on open()
  • From: Christoph Berg
• Postgresql 13.7 hangs down
  • From: Bogdan Siara
• Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?
  • From: Tom Lane
• Re: Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?
  • From: Adrian Klaver
• Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?
  • From: Wen Yi
• Re: AIX and EAGAIN on open()
  • From: Thomas Munro
• Re: plpgsql_check issue while upgrading from postgres version 12 to 13.7
  • From: Pavel Stehule
• plpgsql_check issue while upgrading from postgres version 12 to 13.7
  • From: shashidhar Reddy
• Re: Libpq question related to allocated resources
  • From: Karl Denninger
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Bryn Llewellyn
• Re: Function inside query status
  • From: Adrian Klaver
• Re: Fatel: unsupported frientend protocol error
  • From: Tom Lane
• pg_amcheck warnings after upgrade to 14.4
  • From: Aleš Zelený
• Re: Fatel: unsupported frientend protocol error
  • From: David G. Johnston
• Re: Fatel: unsupported frientend protocol error
  • From: Laurenz Albe
• Fatel: unsupported frientend protocol error
  • From: eswar reddy
• Function inside query status
  • From: Rama Krishnan
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: David G. Johnston
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Bryn Llewellyn
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: David G. Johnston
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Bryn Llewellyn
• Question on pg_auto_failover extension
  • From: DAN LU
• RE: help for pg_wal issue
  • From: Özge Özyavuz
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Christophe Pettus
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Pavel Stehule
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Laurenz Albe
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Tom Lane
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Pavel Stehule
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Tom Lane
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: David G. Johnston
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Pavel Stehule
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Bryn Llewellyn
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: David G. Johnston
• Re: User's responsibility when using a chain of "immutable" functions?
  • From: Christophe Pettus
• User's responsibility when using a chain of "immutable" functions?
  • From: Bryn Llewellyn
• Re: Unique index prohibits partial aggregates
  • From: David Rowley
• RE: Unique index prohibits partial aggregates
  • From: Bos, Fred
• Re: Libpq question related to allocated resources
  • From: Karl Denninger
• GIN index operator ?(jsonb,text) not working?
  • From: jian he
• Re: help for pg_wal issue
  • From: Kyotaro Horiguchi
• Re: help for pg_wal issue
  • From: Kyotaro Horiguchi
• Re:Re: Different sort result between PostgreSQL 8.4 and 12.5
  • From: gzh
• Re: Libpq question related to allocated resources
  • From: Tom Lane
• Re: Unique index prohibits partial aggregates
  • From: David Rowley
• Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")
  • From: Bryn Llewellyn
• Libpq question related to allocated resources
  • From: Karl Denninger
• Re: Table space not returned to the OS ?
  • From: Magnus Hagander
• Unique index prohibits partial aggregates
  • From: Bos, Fred
• Re: Different sort result between PostgreSQL 8.4 and 12.5
  • From: Magnus Hagander
• Different sort result between PostgreSQL 8.4 and 12.5
  • From: gzh
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: Wolfgang Rißler
• Re: Question about attention to pgsql-hackers@xxxxxxxxxxxxxxxxxxxx
  • From: Imre Samu
• Re: help for pg_wal issue
  • From: Laurenz Albe
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: Daniel Verite
• help for pg_wal issue
  • From: Özge Özyavuz
• Re: Table space not returned to the OS ?
  • From: Laurenz Albe
• Re: Table space not returned to the OS ?
  • From: Florents Tselai
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: Wolfgang Rißler
• Re: Table space not returned to the OS ?
  • From: Thomas Boussekey
• Re: Table space not returned to the OS ?
  • From: Magnus Hagander
• Table space not returned to the OS ?
  • From: Florents Tselai
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: David G. Johnston
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: WR
• Sv: How can I set up Postgres to use given amount of RAM?
  • From: Andreas Joseph Krogh
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: WR
• Re: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Michael Paquier
• Re: How can I set up Postgres to use given amount of RAM?
  • From: Mladen Gogala
• Re: How can I set up Postgres to use given amount of RAM?
  • From: Zahid Rahman
• How can I set up Postgres to use given amount of RAM?
  • From: W.P.
• Re: Question about attention to pgsql-hackers@xxxxxxxxxxxxxxxxxxxx
  • From: Mladen Gogala
• Re: Question about attention to pgsql-hackers@xxxxxxxxxxxxxxxxxxxx
  • From: Julien Rouhaud
• Re: Question about attention to pgsql-hackers@xxxxxxxxxxxxxxxxxxxx
  • From: Laurenz Albe
• Question about attention to pgsql-hackers@xxxxxxxxxxxxxxxxxxxx
  • From: A Z
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Peter J. Holzer
• Re: Automatic autovacuum to prevent wraparound - PG13.5
  • From: Peter Geoghegan
• Re: Automatic autovacuum to prevent wraparound - PG13.5
  • From: Ninad Shah
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Tom Lane
• RE: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: 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)
  • From: Peter Eisentraut
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Tomas Pospisek
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: Daniel Verite
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Adrian Klaver
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Adrian Klaver
• Re: Differences in Escaped bytea's when creating a plain pg_dump
  • From: WR
• Differences in Escaped bytea's when creating a plain pg_dump
  • From: WR
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Tomas Pospisek
• Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL
  • From: Jagmohan Kaintura
• Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row
  • From: Matthias Apitz
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Jeff Janes
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Jeff Janes
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Tom Lane
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Tom Lane
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Peter J. Holzer
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Peter J. Holzer
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Peter J. Holzer
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Peter J. Holzer
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Tomas Pospisek
• Re: Tuning a query with ORDER BY and LIMIT
  • From: Michael van der Kolff
• Tuning a query with ORDER BY and LIMIT
  • From: Dirschel, Steve
• Re: ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Adrian Klaver
• ERROR: new collation (en_US.UTF-8) is incompatible with the collation of the template database (en_US.utf-8)
  • From: Tomas Pospisek
• RE: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mahendrakar, Prabhakar - Dell Team
• RE: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mahendrakar, Prabhakar - Dell Team
• PostgreSQL with Patroni not replicating to all nodes after adding 3rd node (another secondary)
  • From: Zb B
• RE: How to use 32 bit ODBC driver
  • From: Aditya Bhardwaj
• Source code test data folder don't have CSV files. How to get the CSV file.
  • From: jian he
• Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row
  • From: Matthias Apitz
• Re: How to use 32 bit ODBC driver
  • From: Adrian Klaver
• Re: How to use 32 bit ODBC driver
  • From: Rino Mardo
• RE: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mahendrakar, Prabhakar - Dell Team
• How to use 32 bit ODBC driver
  • From: Aditya Bhardwaj
• Re: accessing postgres from c++
  • From: Rino Mardo
• Re: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mateusz Henicz
• Reminder: Call for Papers for PostgreSQL Conference Europe 2022 is closing soon!
  • From: Andreas 'ads' Scherbaum
• Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL
  • From: Gilles Darold
• Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL
  • From: Jagmohan Kaintura
• Re: accessing postgres from c++
  • From: Matthias Apitz
• Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL
  • From: Gilles Darold
• INSERT ALL with DML ERROR Logging replacement in PostgreSQL
  • From: Jagmohan Kaintura
• Re: accessing postgres from c++
  • From: Dominique Devienne
• Re: accessing postgres from c++
  • From: Laurenz Albe
• Re: Index creation
  • From: Дмитрий Иванов
• accessing postgres from c++
  • From: Rino Mardo
• Re: A error happend when I am clone the git repository
  • From: Magnus Hagander
• Re: Index creation
  • From: Jeff Janes
• RE: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mahendrakar, Prabhakar - Dell Team
• AIX and EAGAIN on open()
  • From: Christoph Berg
• Re: Index creation
  • From: Дмитрий Иванов
• Re: A error happend when I am clone the git repository
  • From: Tom Lane
• Re: A error happend when I am clone the git repository
  • From: Adrian Klaver
• A error happend when I am clone the git repository
  • From: Wen Yi
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Bryn Llewellyn
• Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")
  • From: David G. Johnston
• Re: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")
  • From: Tom Lane
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Thomas Kellerer
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Bryn Llewellyn
• Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")
  • From: Bryn Llewellyn
• Re: Index creation
  • From: David G. Johnston
• Index creation
  • From: Дмитрий Иванов
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: jian he
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Bryn Llewellyn
• Re: ISBN (was: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?)
  • From: Bryn Llewellyn
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Alban Hertroys
• Re:
  • From: Peter J. Holzer
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: Peter J. Holzer
• ISBN (was: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?)
  • From: Peter J. Holzer
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Bryn Llewellyn
• Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type
  • From: Pavel Stehule
• Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type
  • From: Daniel Popowich
• RE: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mahendrakar, Prabhakar - Dell Team
• Re: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Laurenz Albe
• Re: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mateusz Henicz
• Re: Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mateusz Henicz
• Postgresql error : PANIC: could not locate a valid checkpoint record
  • From: Mahendrakar, Prabhakar - Dell Team
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: Bryn Llewellyn
• Re: Any way to understand state after data corruption failures during startup.
  • From: Kyotaro Horiguchi
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: David G. Johnston
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: Bryn Llewellyn
• Any way to understand state after data corruption failures during startup.
  • From: Harinath Kanchu
• Re:
  • From: Abdul Qoyyuum
• Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type
  • From: Bryn Llewellyn
• Re: Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type
  • From: Tom Lane
• Operators on ranges with a domain subtype do not implicitly cast operands of the domain's base type
  • From: Daniel Popowich
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: Tom Lane
• Re:
  • From: Adrian Klaver
• [no subject]
  • From: Rama Krishnan
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: David G. Johnston
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: Bryn Llewellyn
• Re: ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: David G. Johnston
• ERROR: failed to find conversion function from key_vals_nn to record[]
  • From: Bryn Llewellyn
• Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390
  • From: Imre Samu
• Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390
  • From: Adrian Klaver
• Re: Recent 11.16 release change
  • From: Daniel Brinzila
• Re: Automatic autovacuum to prevent wraparound - PG13.5
  • From: Laurenz Albe
• Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390
  • From: Tom Lane
• Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390
  • From: Ray O'Donnell
• Automatic autovacuum to prevent wraparound - PG13.5
  • From: Mauro Farracha
• RE: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390
  • From: Ian Dauncey
• Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390
  • From: Ray O'Donnell
• PostgreSQL 12.2 on Linux ubuntu 20.4 / s390
  • From: Ian Dauncey
• Re: cast to domain with default collation issue.
  • From: Tom Lane
• Re: Recent 11.16 release change
  • From: Tom Lane
• Recent 11.16 release change
  • From: Daniel Brinzila
• Re: Postgres NOT IN vs NOT EXISTS optimization
  • From: Tom Lane
• Re: Postgres NOT IN vs NOT EXISTS optimization
  • From: Jeremy Smith
• Postgres NOT IN vs NOT EXISTS optimization
  • From: Dirschel, Steve
• Re: Tools to convert timestamp data to another time zone in PostgreSQL
  • From: Ilya Anfimov
• RE: Build Postgres On AIX
  • From: Mark Hill
• Re: multiple entries for synchronous_standby_names
  • From: Michael Paquier
• Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
  • From: Bryn Llewellyn
• Re: Tools to convert timestamp data to another time zone in PostgreSQL
  • From: Adrian Klaver
• Tools to convert timestamp data to another time zone in PostgreSQL
  • From: Joel Rabinovitch
• Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
  • From: Christophe Pettus
• Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
  • From: Pavel Stehule
• Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
  • From: Tom Lane
• Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
  • From: Bryn Llewellyn
• Re: Need optimization in query
  • From: Shubham Mittal
• Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
  • From: Pavel Stehule
• "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
  • From: Bryn Llewellyn
• Re: newbie db design question
  • From: Rino Mardo
• Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P
  • From: Tom Lane
• Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P
  • From: Markur Sens
• Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P
  • From: Tom Lane
• PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P
  • From: Markur Sens
• multiple entries for synchronous_standby_names
  • From: Nitesh Nathani
• Re: newbie db design question
  • From: Peter J. Holzer
• Re: newbie db design question
  • From: Ray O'Donnell
• Re: newbie db design question
  • From: Gavan Schneider
• newbie db design question
  • From: Rino Mardo
• Re: How to drop a subscription inside a stored procedure?
  • From: Thomas Kellerer
• Need optimization in query
  • From: Shubham Mittal
• Re: How to get response message
  • From: David G. Johnston
• Re: How to get response message
  • From: Francisco Olarte
• Re: How to get response message
  • From: Adrian Klaver
• How to get response message
  • From: Rama Krishnan
• Re: How to drop a subscription inside a stored procedure?
  • From: Adrian Klaver
• How to drop a subscription inside a stored procedure?
  • From: Thomas Kellerer
• Re: Row level security insert policy does not validate update new values/content?
  • From: David G. Johnston
• Re: cast to domain with default collation issue.
  • From: David G. Johnston
• Re: Logical replication of large objects
  • From: Andreas Joseph Krogh
• Re: Logical replication of large objects
  • From: Joshua Drake
• Re: Sharing DSA pointer between parallel workers after they've been created
  • From: Joshua Drake
• Re: Cluster OID Limit
  • From: Joshua Drake
• Re: Cluster OID Limit
  • From: SERHAD ERDEM
• Re: Cluster OID Limit
  • From: Adrian Klaver
• Re: Cluster OID Limit
  • From: Tom Lane
• A function to find errors in groups in a table
  • From: Shaozhong SHI
• Cluster OID Limit
  • From: Lucas
• Re: message log merge (streaming replication)
  • From: Kyotaro Horiguchi
• Re: message log merge (streaming replication)
  • From: Ian Lawrence Barwick
• Fwd: message log merge (streaming replication)
  • From: Peter Adlersburg
• Sharing DSA pointer between parallel workers after they've been created
  • From: Ma, Marcus
• 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
  • From: Kyotaro Horiguchi
• Re:
  • From: Ian Lawrence Barwick
• Re: gawk extension linux missing stuff in package manager fedora 36
  • From: Daniel Verite
• gawk extension linux missing stuff in package manager fedora 36
  • From: 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
  • From: pgdba pgdba
• Fwd:
  • From: Jim McNamara
• [no subject]
  • From: Jim McNamara
• Re: SQL state: 42601. Execption handling.
  • From: Kyotaro Horiguchi
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Merlin Moncure
• Re: SQL state: 42601. Execption handling.
  • From: Tom Lane
• SQL state: 42601. Execption handling.
  • From: Ц
• SQL state: 42601. Execption handling.
  • From: Ц
• SV: GSSAPI authentication
  • From: Niels Jespersen
• Re: [EXT] Re: Accessing composite type elements
  • From: Garfield Lewis
• Re: GSSAPI authentication
  • From: Michael van der Kolff
• Re: GSSAPI authentication
  • From: Michael van der Kolff
• Re: GSSAPI authentication
  • From: Michael van der Kolff
• SV: GSSAPI authentication
  • From: Niels Jespersen
• Re: GSSAPI authentication
  • From: Michael van der Kolff
• Re: GSSAPI authentication
  • From: Michael van der Kolff
• GSSAPI authentication
  • From: Niels Jespersen
• Re: Why password authentication failed for user "postgres"?
  • From: David G. Johnston
• Re: Why password authentication failed for user "postgres"?
  • From: Frank Finner
• Logical replication of large objects
  • From: Andreas Joseph Krogh
• Re: Window function?
  • From: John W Higgins
• Re: Call pstrdup() of palloc.h will change source string, please help!
  • From: Tom Lane
• Re: unoptimized nested loops
  • From: Tim Kelly
• Call pstrdup() of palloc.h will change source string, please help!
  • From: mengfanjun
• Re: Window function?
  • From: David G. Johnston
• Re: Why password authentication failed for user "postgres"?
  • From: Jeff Janes
• Re: Window function?
  • From: Tom Lane
• Re: Window function?
  • From: Robert Stanford
• Re: Window function?
  • From: Thiemo Kellner
• Window function?
  • From: Robert Stanford
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Tom Lane
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Bryn Llewellyn
• Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: David G. Johnston
• '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?
  • From: Bryn Llewellyn
• Re: Why password authentication failed for user "postgres"?
  • From: Reid Thompson
• Why password authentication failed for user "postgres"?
  • From: BeginnerC
• Re: Logically replicated table has no visible rows
  • From: Jeff Ross
• Re: Max sane value for join_collapse_limit?
  • From: Philip Semanchuk
• Re: GIN theory
  • From: jian he
• Re: unoptimized nested loops
  • From: Tim Kelly
• GIN theory
  • From: huangning290@xxxxxxxxx
• Max sane value for join_collapse_limit?
  • From: Andreas Joseph Krogh
• Re: [EXT] Re: Accessing composite type elements
  • From: Merlin Moncure
• Re: unoptimized nested loops
  • From: Jeff Janes
• Re: [EXT] Re: Accessing composite type elements
  • From: Garfield Lewis
• Re: Accessing composite type elements
  • From: Tom Lane
• Accessing composite type elements
  • From: Garfield Lewis
• Re: Extended multivariate statistics are ignored (potentially related to high null fraction, not sure)
  • From: Danny Shemesh
• Re: How to display complicated Chinese character: Biang.
  • From: Laurenz Albe
• How to display complicated Chinese character: Biang.
  • From: jian he
• Re: unoptimized nested loops
  • From: Tom Lane
• Re: unoptimized nested loops
  • From: Jeff Janes
• Re: unoptimized nested loops
  • From: David Rowley
• Re: Extended multivariate statistics are ignored (potentially related to high null fraction, not sure)
  • From: Bruce Momjian
• Extended multivariate statistics are ignored (potentially related to high null fraction, not sure)
  • From: Danny Shemesh
• Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row
  • From: Tom Lane
• function currtid2() in SQL and ESQL/C to get the new CTID of a row
  • From: Matthias Apitz
• Re: Order of rows in statement triggers NEW/OLD tables
  • From: Thomas Munro
• unoptimized nested loops
  • From: Tim Kelly
• Re: Database trigger (one server to another)
  • From: Adrian Klaver
• Database trigger (one server to another)
  • From: Muhammad Bilal Jamil
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• Logically replicated table has no visible rows
  • From: Jeff Ross
• Re: Build Postgres On AIX
  • From: Tom Lane
• Build Postgres On AIX
  • From: Mark Hill
• Re: The use of partial, expressional indices in pg < 14
  • From: Tom Lane
• pgAdmin 4 v 6.9
  • From: Eric Katchan
• The use of partial, expressional indices in pg < 14
  • From: Danny Shemesh
• Re: Is it possible to index "deep" into a JSONB column?
  • From: Shaheed Haque
• Re: Is it possible to index "deep" into a JSONB column?
  • From: Shaheed Haque
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• Re: autovacuum on primary blocking queries on replica?
  • From: Jeff Janes
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Jeff Janes
• Re: Is it possible to index "deep" into a JSONB column?
  • From: Shaheed Haque
• Appending data locally to a logical replication subscriber
  • From: andrew cooke
• Re: Is it possible to index "deep" into a JSONB column?
  • From: Imre Samu
• Re: Is it possible to index "deep" into a JSONB column?
  • From: Imre Samu
• Re: Is it possible to index "deep" into a JSONB column?
  • From: Shaheed Haque
• Re: Is it possible to index "deep" into a JSONB column?
  • From: Bryn Llewellyn
• Re: psql 15beta1 does not print notices on the console until transaction completes
  • From: Rob Sargent
• Re: psql 15beta1 does not print notices on the console until transaction completes
  • From: Adrian Klaver
• Re: psql 15beta1 does not print notices on the console until transaction completes
  • From: Tom Lane
• Re: psql 15beta1 does not print notices on the console until transaction completes
  • From: Adrian Klaver
• Re: psql 15beta1 does not print notices on the console until transaction completes
  • From: Alastair McKinley
• Re: psql 15beta1 does not print notices on the console until transaction completes
  • From: Adrian Klaver
• Is it possible to index "deep" into a JSONB column?
  • From: Shaheed Haque
• Re: psql 15beta1 does not print notices on the console until transaction completes
  • From: Adrian Klaver
• psql 15beta1 does not print notices on the console until transaction completes
  • From: Alastair McKinley
• Re: Function definition regression in 15beta1 when specific parameter name (string) is used
  • From: Alastair McKinley
• Re: Function definition regression in 15beta1 when specific parameter name (string) is used
  • From: Tom Lane
• Re: Function definition regression in 15beta1 when specific parameter name (string) is used
  • From: Adrian Klaver
• Re: Function definition regression in 15beta1 when specific parameter name (string) is used
  • From: Adrian Klaver
• Function definition regression in 15beta1 when specific parameter name (string) is used
  • From: Alastair McKinley
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Shaheed Haque
• Re: autovacuum on primary blocking queries on replica?
  • From: Laurenz Albe
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Tom Lane
• Re: Showing alternative query planner plans with explain ?
  • From: Tom Lane
• Showing alternative query planner plans with explain ?
  • From: Danny Shemesh
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Shaheed Haque
• Re: Improve configurability for IO related behavoir
  • From: Thomas Munro
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Tom Lane
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Adrian Klaver
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Shaheed Haque
• Re: JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Tom Lane
• JSONB index not in use, but is TOAST the real cause of slow query?
  • From: Shaheed Haque
• Improve configurability for IO related behavoir
  • From: 浩辰 何
• autovacuum on primary blocking queries on replica?
  • From: Don Seiler
• Re: Determine if range list contains specified integer
  • From: Sándor Daku
• Re: Determine if range list contains specified integer
  • From: David G. Johnston
• Re: Determine if range list contains specified integer
  • From: Adrian Klaver
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• Determine if range list contains specified integer
  • From: Andrus
• Re: pg_create_logical_replication_slot in DB1 is blocked by a session in DB2
  • From: Kyotaro Horiguchi
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Tom Lane
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: David G. Johnston
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• Re: Automatic PK values not added to new rows
  • From: Adrian Klaver
• Re: Automatic PK values not added to new rows
  • From: Ron
• Re: Automatic PK values not added to new rows
  • From: Rich Shepard
• Re: PG 13.6 : Data corruption error message not being sent to syslog
  • From: Abhishek Bhola
• Re: Automatic PK values not added to new rows
  • From: Thomas Kellerer
• Re: Automatic PK values not added to new rows [RESOLVED]
  • From: Rich Shepard
• Re: Automatic PK values not added to new rows
  • From: Adrian Klaver
• Re: Automatic PK values not added to new rows
  • From: Rich Shepard
• Re: Automatic PK values not added to new rows
  • From: Rich Shepard
• Re: Automatic PK values not added to new rows
  • From: Adrian Klaver
• Re: Automatic PK values not added to new rows
  • From: Rich Shepard
• Re: "Join Postgres on Slack" ?
  • From: Bryn Llewellyn
• Re: Automatic PK values not added to new rows
  • From: David G. Johnston
• Re: Automatic PK values not added to new rows
  • From: Adrian Klaver
• Automatic PK values not added to new rows
  • From: Rich Shepard
• Re: "Join Postgres on Slack" ?
  • From: David G. Johnston
• "Join Postgres on Slack" ?
  • From: Bryn Llewellyn
• Re: Pg14 possible index corruption after reindex concurrently
  • From: Aleš Zelený
• Re: Connect to specific cluster on command line
  • From: Andreas Fröde
• Extension pg_trgm, permissions and pg_dump order
  • From: Färber, Franz-Josef (StMUK)
• Re: Connect to specific cluster on command line
  • From: Carsten Klein
• Re: Connect to specific cluster on command line
  • From: Adrian Klaver
• Re: Connect to specific cluster on command line
  • From: David G. Johnston
• pg_create_logical_replication_slot in DB1 is blocked by a session in DB2
  • From: Fred Habash
• Re: Connect to specific cluster on command line
  • From: Tom Lane
• Re: Connect to specific cluster on command line
  • From: Laurenz Albe
• Re: Connect to specific cluster on command line
  • From: Carsten Klein
• Re: connect permission based on database name
  • From: Rob Sargent
• Re: connect permission based on database name
  • From: David G. Johnston
• Re: connect permission based on database name
  • From: Rob Sargent
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Tom Lane
• Re: Connect to specific cluster on command line
  • From: Tom Lane
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Ravi Krishna
• Connect to specific cluster on command line
  • From: Carsten Klein
• Re: connect permission based on database name
  • From: Rob Sargent
• Re: connect permission based on database name
  • From: Tom Lane
• Re: PG 13.6 : Data corruption error message not being sent to syslog
  • From: Tom Lane
• connect permission based on database name
  • From: Rob Sargent
• Re: cast to domain with default collation issue.
  • From: David G. Johnston
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Laurenz Albe
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Christoph Moench-Tegeder
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Laurenz Albe
• Re: link that explain ICU_LOCALE locale concept about local variant code and keywords.
  • From: jian he
• Re: link that explain ICU_LOCALE locale concept about local variant code and keywords.
  • From: Daniel Verite
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• PG 13.6 : Data corruption error message not being sent to syslog
  • From: Abhishek Bhola
• link that explain ICU_LOCALE locale concept about local variant code and keywords.
  • From: jian he
• Re: cast to domain with default collation issue.
  • From: jian he
• Re: cast to domain with default collation issue.
  • From: David G. Johnston
• Re: cast to domain with default collation issue.
  • From: jian he
• Re: Pg14 possible index corruption after reindex concurrently
  • From: Aleš Zelený
• Re: Pg14 possible index corruption after reindex concurrently
  • From: Thomas Munro
• Pg14 possible index corruption after reindex concurrently
  • From: Aleš Zelený
• Re: About psql \dt unable display same name table which have different schema
  • From: 徐志宇徐
• Re: About psql \dt unable display same name table which have different schema
  • From: Tom Lane
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Tom Lane
• About psql \dt unable display same name table which have different schema
  • From: 徐志宇徐
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Laurenz Albe
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• Re: Can I start Update row in After Insert trigger function?
  • From: Adrian Klaver
• Re: existing row not found by SELECT ... WHERE CTID = ?
  • From: Tom Lane
• existing row not found by SELECT ... WHERE CTID = ?
  • From: Matthias Apitz
• Re: cast to domain with default collation issue.
  • From: Tom Lane
• Would it be possible to utilize a GIN index to query for distinct values ?
  • From: Danny Shemesh
• Re: Can I start Update row in After Insert trigger function?
  • From: Durumdara
• Re: cast to domain with default collation issue.
  • From: Tom Lane
• Re: cast to domain with default collation issue.
  • From: David G. Johnston
• cast to domain with default collation issue.
  • From: jian he
• Fwd: How is this possible "publication does not exist"
  • From: operations i
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: list tablespaces named in custom format dump
  • From: Adrian Klaver
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: list tablespaces named in custom format dump
  • From: Adrian Klaver
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: list tablespaces named in custom format dump
  • From: Tom Lane
• Re: list tablespaces named in custom format dump
  • From: Adrian Klaver
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: list tablespaces named in custom format dump
  • From: Adrian Klaver
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: Can I start Update row in After Insert trigger function?
  • From: Adrian Klaver
• Re: psql connect over ssl load balancer
  • From: dzagashev@xxxxxxxxx
• Can I start Update row in After Insert trigger function?
  • From: Durumdara
• Re: psql connect over ssl load balancer
  • From: Tom Lane
• Re: list tablespaces named in custom format dump
  • From: Tom Lane
• psql connect over ssl load balancer
  • From: dzagashev@xxxxxxxxx
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: PLPGSQL - extra column existence in trigger
  • From: Durumdara
• Re: list tablespaces named in custom format dump
  • From: Adrian Klaver
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: list tablespaces named in custom format dump
  • From: Adrian Klaver
• Re: list tablespaces named in custom format dump
  • From: Rob Sargent
• Re: list tablespaces named in custom format dump
  • From: Adrian Klaver
• list tablespaces named in custom format dump
  • From: Rob Sargent
• Re:
  • From: Sureshsv Kseb
• [no subject]
  • From: Rama Krishnan
• Re: Casting a collation in an ORDER BY ... COLLATE
  • From: Tom Lane
• Re: Casting a collation in an ORDER BY ... COLLATE
  • From: David G. Johnston
• Casting a collation in an ORDER BY ... COLLATE
  • From: Kip Cole
• Re: In case of network issues, how long before archive_command does retries
  • From: Koen De Groote
• Re: Long living and expiring locks?
  • From: Laurenz Albe
• Re: No default for (user-specific) service file location on Windows?
  • From: Dominique Devienne
• Long living and expiring locks?
  • From: Tim Uckun
• Re: No default for (user-specific) service file location on Windows?
  • From: Julien Rouhaud
• Re: No default for (user-specific) service file location on Windows?
  • From: Tom Lane
• Re: No default for (user-specific) service file location on Windows?
  • From: Julien Rouhaud
• Re: No default for (user-specific) service file location on Windows?
  • From: Julien Rouhaud
• Re: In case of network issues, how long before archive_command does retries
  • From: Laurenz Albe
• Re: No default for (user-specific) service file location on Windows?
  • From: Tom Lane
• Re: In case of network issues, how long before archive_command does retries
  • From: Koen De Groote
• Re: No default for (user-specific) service file location on Windows?
  • From: Julien Rouhaud
• Re: No default for (user-specific) service file location on Windows?
  • From: Dominique Devienne
• Re: No default for (user-specific) service file location on Windows?
  • From: Julien Rouhaud
• No default for (user-specific) service file location on Windows?
  • From: Dominique Devienne
• Re: In case of network issues, how long before archive_command does retries
  • From: Laurenz Albe
• Re: About pg_basebackup
  • From: Laurenz Albe
• About pg_basebackup
  • From: 菊池祐
• Re: Who am I? Where am I connected?
  • From: Tom Lane
• switchover and switchback assistance ...
  • From: itman73
• Re: Who am I? Where am I connected?
  • From: Adrian Klaver
• Re: Who am I? Where am I connected?
  • From: Dominique Devienne
• Re: Reasons for not overwriting processed wal archives?
  • From: David G. Johnston
• Reasons for not overwriting processed wal archives?
  • From: Koen De Groote
• In case of network issues, how long before archive_command does retries
  • From: Koen De Groote
• Re: Who am I? Where am I connected?
  • From: David G. Johnston
• Re: Who am I? Where am I connected?
  • From: Dominique Devienne
• Re: show primary_conninfo unchanged after promotion?
  • From: Ian Lawrence Barwick
• show primary_conninfo unchanged after promotion?
  • From: Wiwwo Staff
• Re: Who am I? Where am I connected?
  • From: Christoph Moench-Tegeder
• Re: Who am I? Where am I connected?
  • From: Ganesh Korde
• Re: Who am I? Where am I connected?
  • From: Erik Wienhold
• Who am I? Where am I connected?
  • From: Dominique Devienne
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: Restricting user to see schema structure
  • From: Adrian Klaver
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: TO_DATE function between PostgreSQL 8.2 and 9.4
  • From: Adrian Klaver
• Re: TO_DATE function between PostgreSQL 8.2 and 9.4
  • From: Thomas Kellerer
• Re: TO_DATE function between PostgreSQL 8.2 and 9.4
  • From: David G. Johnston
• Re: TO_DATE function between PostgreSQL 8.2 and 9.4
  • From: John W Higgins
• Re: TO_DATE function between PostgreSQL 8.2 and 9.4
  • From: Tom Lane
• Re: TO_DATE function between PostgreSQL 8.2 and 9.4
  • From: Adrian Klaver
• Re: Restricting user to see schema structure
  • From: Adrian Klaver
• TO_DATE function between PostgreSQL 8.2 and 9.4
  • From: gzh
• Parallel not working
  • From: huangning290@xxxxxxxxx
• Postgres AST Deparser for Postgres
  • From: Dan Lynch
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Alternative to slow SRF in SELECT?
  • From: David G. Johnston
• Alternative to slow SRF in SELECT?
  • From: Markur Sens
• Row level security insert policy does not validate update new values/content?
  • From: alias
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re:
  • From: Amul Sul
• Re:
  • From: David G. Johnston
• [no subject]
  • From: Rama Krishnan
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Restricting user to see schema structure
  • From: Adrian Klaver
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• RE: Need to install Postgres Version 14 in Linux server with Client and migration steps.
  • From: Rajamoorthy-CW, Thirumurugan 8361
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Logon via GSSAPI from Linux fails, but works from Windows
  • From: Niels Jespersen
• Re: Restricting user to see schema structure
  • From: Adrian Klaver
• Re: Restricting user to see schema structure
  • From: Adrian Klaver
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Restricting user to see schema structure
  • From: Neeraj M R
• Re: Restricting user to see schema structure
  • From: Neeraj M R
• Re: generated column cast from timestamptz to timestamp not OK.
  • From: Francisco Olarte
• generated column cast from timestamptz to timestamp not OK.
  • From: alias
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: Deferred constraint trigger semantics
  • From: Laurenz Albe
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Re: AW: [Extern] Re: consistent postgresql snapshot
  • From: Ron
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: Restricting user to see schema structure
  • From: Pavel Stehule
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: Restricting user to see schema structure
  • From: Tom Lane
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: Restricting user to see schema structure
  • From: David G. Johnston
• Re: Restricting user to see schema structure
  • From: Adrian Klaver
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Re: Restricting user to see schema structure
  • From: Bryn Llewellyn
• Re: AW: [Extern] Re: consistent postgresql snapshot
  • From: kaido vaikla
• Re: Restricting user to see schema structure
  • From: Adrian Klaver
• Restricting user to see schema structure
  • From: Neeraj M R
• Re: effects of nullifying bytea column on storage
  • From: Hugh Ranalli
• Re: AW: [Extern] Re: consistent postgresql snapshot
  • From: Nick Cleaton
• Re: Deferred constraint trigger semantics
  • From: alias
• Re: Fedora 36
  • From: Adrian Klaver
• Re: AW: [Extern] Re: consistent postgresql snapshot
  • From: Tom Lane
• AW: [Extern] Re: consistent postgresql snapshot
  • From: Zwettler Markus (OIZ)
• Re: Deferred constraint trigger semantics
  • From: Laurenz Albe
• Re: effects of nullifying bytea column on storage
  • From: David G. Johnston
• Re: effects of nullifying bytea column on storage
  • From: David Gauthier
• Re: effects of nullifying bytea column on storage
  • From: David G. Johnston
• effects of nullifying bytea column on storage
  • From: David Gauthier
• Re: consistent postgresql snapshot
  • From: Ron
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Re: Deferred constraint trigger semantics
  • From: David G. Johnston
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• consistent postgresql snapshot
  • From: Zwettler Markus (OIZ)
• Re: PLPGSQL - extra column existence in trigger
  • From: hubert depesz lubaczewski
• Re: Deferred constraint trigger semantics
  • From: Laurenz Albe
• Re: Deferred constraint trigger semantics
  • From: David G. Johnston
• Re: Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Re: Deferred constraint trigger semantics
  • From: David G. Johnston
• Deferred constraint trigger semantics
  • From: Bryn Llewellyn
• Re: PLPGSQL - extra column existence in trigger
  • From: Peter J. Holzer
• Re: Fedora 36
  • From: Adrian Klaver
• Fedora 36
  • From: Kieran McCusker
• Re: Question on cast string to date
  • From: Tom Lane
• Re: Question on cast string to date
  • From: 正华吕
• Re: Question on cast string to date
  • From: David G. Johnston
• Re: Question on cast string to date
  • From: Tom Lane
• Re: Question on cast string to date
  • From: Ian Lawrence Barwick
• Re: Question on cast string to date
  • From: Pavel Stehule
• Question on cast string to date
  • From: 正华吕
• Re: Set timeout just on a query?
  • From: Bharath Rupireddy
• Set timeout just on a query?
  • From: Shaozhong SHI
• Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.
  • From: Adrian Klaver
• Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.
  • From: Sandeep Kumar Jakkaraju
• Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.
  • From: Alan Hodgson
• Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.
  • From: Sandeep Kumar Jakkaraju
• Need to install Postgres Version 14 in Linux server with Client and migration steps.
  • From: Rajamoorthy-CW, Thirumurugan 8361
• Re: pg_dump: VACUUM and REINDEXING
  • From: Tom Lane
• Re: PLPGSQL - extra column existence in trigger
  • From: Durumdara
• Re: pg_dump: VACUUM and REINDEXING
  • From: Laurenz Albe
• Re: The P0004 assert_failure exception assert_failure exception seems to be unhandleable
  • From: Bryn Llewellyn
• Re: "A transaction cannot be ended inside a block with exception handlers."
  • From: Bryn Llewellyn
• Re: The P0004 assert_failure exception assert_failure exception seems to be unhandleable
  • From: David G. Johnston
• The P0004 assert_failure exception assert_failure exception seems to be unhandleable
  • From: Bryn Llewellyn
• Re: pg_dump: VACUUM and REINDEXING
  • From: Guillaume Lelarge
• Re: PLPGSQL - extra column existence in trigger
  • From: David G. Johnston
• Re: pg_dump: VACUUM and REINDEXING
  • From: Hasan Marzooq
• PLPGSQL - extra column existence in trigger
  • From: Durumdara
• Re: pg_dump: VACUUM and REINDEXING
  • From: Guillaume Lelarge
• Re: pg_dump: VACUUM and REINDEXING
  • From: Ron
• Re: pg_dump: VACUUM and REINDEXING
  • From: Guillaume Lelarge
• Re: "A transaction cannot be ended inside a block with exception handlers."
  • From: David G. Johnston
• Re: "A transaction cannot be ended inside a block with exception handlers."
  • From: Bryn Llewellyn
• Re: How to get value wrapped in json?
  • From: David G. Johnston
• Re: "A transaction cannot be ended inside a block with exception handlers."
  • From: Tom Lane
• Re: "A transaction cannot be ended inside a block with exception handlers."
  • From: Bryn Llewellyn
• pg_dump: VACUUM and REINDEXING
  • From: Hasan Marzooq
• How to get value wrapped in json?
  • From: Shaozhong SHI
• Re: Vertical partition
  • From: David G. Johnston
• Re: Vertical partition
  • From: Rama Krishnan
• Re: Vertical partition
  • From: David G. Johnston
• Vertical partition
  • From: Rama Krishnan
• Re: "A transaction cannot be ended inside a block with exception handlers."
  • From: David G. Johnston
• "A transaction cannot be ended inside a block with exception handlers."
  • From: Bryn Llewellyn
• Re: Replication with Patroni not working after killing secondary and starting again
  • From: Zb B
• Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
  • From: Francisco Olarte
• Order of rows in statement triggers NEW/OLD tables
  • From: hubert depesz lubaczewski
• Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
  • From: Jerry Sievers
• Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
  • From: Jerry Sievers
• Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
  • From: Jerry Sievers
• Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
  • From: Daniele Varrazzo
• Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
  • From: Tom Lane
• Psycopg3 fails to resolve 'timezone localtime' on MacOS
  • From: Jerry Sievers
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: WIN1252 vs UTF8 database encoding
  • From: Adrian Klaver
• WIN1252 vs UTF8 database encoding
  • From: JORGE MALDONADO
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Re: Backing up a DB excluding certain tables
  • From: Francisco Olarte
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Backing up a DB excluding certain tables
  • From: Francisco Olarte
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Backing up a DB excluding certain tables
  • From: JORGE MALDONADO
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Ron
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Displaying chat by punished users only to themselves (db fiddle attached)
  • From: David G. Johnston
• Displaying chat by punished users only to themselves (db fiddle attached)
  • From: Alexander Farber
• Re: Replication with Patroni not working after killing secondary and starting again
  • From: Peter J. Holzer
• Completely wrong queryplan
  • From: Paul van der Linden
• Re: Replication with Patroni not working after killing secondary and starting again
  • From: Zb B
• Re: Whole Database or Table AES encryption
  • From: Aaron Gray
• Re: Whole Database or Table AES encryption
  • From: Aaron Gray
• Re: Logical replication 'possible' problem
  • From: Steve Baldwin
• Re: Logical replication 'possible' problem
  • From: Steve Baldwin
• Logical replication 'possible' problem
  • From: Steve Baldwin
• Re: Meaning of "constant" not honored when the variable is used as the actual for a proc's OUT formal paameter
  • From: Bryn Llewellyn
• Re: Meaning of "constant" not honored when the variable is used as the actual for a proc's OUT formal paameter
  • From: Tom Lane
• Meaning of "constant" not honored when the variable is used as the actual for a proc's OUT formal paameter
  • From: Bryn Llewellyn
• Re: Backing up a DB excluding certain tables
  • From: Adrian Klaver
• Re: Backing up a DB excluding certain tables
  • From: JORGE MALDONADO
• Re: Backing up a DB excluding certain tables
  • From: Adrian Klaver
• Re: Backing up a DB excluding certain tables
  • From: JORGE MALDONADO
• Re: External psql editor
  • From: Peter J. Holzer
• Re: External psql editor
  • From: Steve Litt
• Re: UUID vs serial and currval('sequence_id')
  • From: David G. Johnston
• Re: UUID vs serial and currval('sequence_id')
  • From: Robert Stanford
• Re: External psql editor
  • From: Mladen Gogala
• Re: UUID vs serial and currval('sequence_id')
  • From: David G. Johnston
• UUID vs serial and currval('sequence_id')
  • From: Robert Stanford
• Re: External psql editor
  • From: Rich Shepard