Postgresql General Discussion

• Thread Index

• Re: pgagent download link missing
  • From: Daniel Gustafsson
• pgagent download link missing
  • From: B Liu
• PostgreSQL C++ Interface version 14.9 using static library instead of shared library
  • From: M Tarkeshwar Rao
• Re: My question about the transaction
  • From: David G. Johnston
• Re: My question about the transaction
  • From: Juan Rodrigo Alejandro Burgos Mella
• Re: My question about the transaction
  • From: Adrian Klaver
• Re: My question about the transaction
  • From: David G. Johnston
• My question about the transaction
  • From: Wen Yi
• Re: Driver Postgresql HP-Unix
  • From: Ron
• Re: Build fails on RHEL 8.8 about libxml2 version
  • From: Sebastien Flaesch
• Re: How can I accurately infer the output of a SELECT statement FROM a table with floating-point data type?
  • From: Tomek
• Build fails on RHEL 8.8 about libxml2 version
  • From: Sebastien Flaesch
• Driver Postgresql HP-Unix
  • From: Abelardo Erazo Lopez
• Re: How can I accurately infer the output of a SELECT statement FROM a table with floating-point data type?
  • From: Tom Lane
• Re: How can I accurately infer the output of a SELECT statement FROM a table with floating-point data type?
  • From: David G. Johnston
• How can I accurately infer the output of a SELECT statement FROM a table with floating-point data type?
  • From: 毛毛
• Re: Inheritance in PostgreSQL
  • From: Merlin Moncure
• Re: psql \du no more showing "member of" column
  • From: Bruce Momjian
• Re: postgres keeps having blocks
  • From: Rob Sargent
• Re: A few questions about foreign tables
  • From: Ron
• Re: postgres keeps having blocks
  • From: Adrian Klaver
• Re: A few questions about foreign tables
  • From: Laurenz Albe
• Re: postgres keeps having blocks
  • From: Ron
• Re: postgres keeps having blocks
  • From: David G. Johnston
• Re: Inheritance in PostgreSQL
  • From: Thomas Kellerer
• Re: Inheritance in PostgreSQL
  • From: Luis Bruno
• postgres keeps having blocks
  • From: Shaozhong SHI
• A few questions about foreign tables
  • From: Marcin Borkowski
• Re: Index based search have issues with 11.20
  • From: Hafeez Rahim
• Re: Index based search have issues with 11.20
  • From: Hafeez Rahim
• Re: Postgresql HA cluster
  • From: Jehan-Guillaume de Rorthais
• Partition Lock Issue
  • From: Saravanan P K
• Fwd: Need efficient way to remove (almost) duplicate rows from a table
  • From: Michael Nolan
• Re: Inheritance in PostgreSQL
  • From: Merlin Moncure
• Re: Need efficient way to remove (almost) duplicate rows from a table
  • From: Ron
• Re: Need efficient way to remove (almost) duplicate rows from a table
  • From: Paul Jungwirth
• Need efficient way to remove (almost) duplicate rows from a table
  • From: David Gauthier
• Re: Inheritance in PostgreSQL
  • From: David G. Johnston
• RE: Inheritance in PostgreSQL
  • From: Jeff Laing
• Re: Inheritance in PostgreSQL
  • From: Ron
• Re: Inheritance in PostgreSQL
  • From: David G. Johnston
• Inheritance in PostgreSQL
  • From: Luis Bruno
• Re: Index based search have issues with 11.20
  • From: Adrian Klaver
• Re: Index based search have issues with 11.20
  • From: Tom Lane
• RE: Postgresql HA cluster
  • From: Jason Grammenos
• Index based search have issues with 11.20
  • From: Hafeez Rahim
• Re: Parsing libpq PQtrace files
  • From: Dominique Devienne
• Re: Parsing libpq PQtrace files
  • From: Alvaro Herrera
• Parsing libpq PQtrace files
  • From: Dominique Devienne
• Logical Replication - Adding Not-Null Column Without Default Value
  • From: Avi Weinberg
• Re: PITR partial timing
  • From: Ron
• PITR partial timing
  • From: Rama Krishnan
• Re: Question About PostgreSQL Extensibility
  • From: Chris Travers
• Re: Understanding max_locks_per_transaction
  • From: Ron
• Re: Understanding max_locks_per_transaction
  • From: Craig McIlwee
• Re: Understanding max_locks_per_transaction
  • From: Tom Lane
• Understanding max_locks_per_transaction
  • From: Craig McIlwee
• Re: Question About PostgreSQL Extensibility
  • From: Laurenz Albe
• Re: Purely declarative FKs
  • From: Ron
• Re: Purely declarative FKs
  • From: Tom Lane
• Re: Postgresql HA cluster
  • From: Jehan-Guillaume de Rorthais
• Re: Purely declarative FKs
  • From: Christophe Pettus
• Purely declarative FKs
  • From: Thiemo Kellner
• Re: right way of using case-expressions in plpgsql functions
  • From: Victor Dobrovolsky
• Re: right way of using case-expressions in plpgsql functions
  • From: Victor Dobrovolsky
• Re: right way of using case-expressions in plpgsql functions
  • From: Tom Lane
• Re: right way of using case-expressions in plpgsql functions
  • From: Ron
• Re: right way of using case-expressions in plpgsql functions
  • From: Victor Dobrovolsky
• Re: right way of using case-expressions in plpgsql functions
  • From: Tom Lane
• Re: right way of using case-expressions in plpgsql functions
  • From: David G. Johnston
• right way of using case-expressions in plpgsql functions
  • From: Victor Dobrovolsky
• Re: RPM-Sync complains about wrong checksums for SLES12 repo
  • From: Stefan Mayr
• Re: RPM-Sync complains about wrong checksums for SLES12 repo
  • From: Julien Rouhaud
• RPM-Sync complains about wrong checksums for SLES12 repo
  • From: Stefan Mayr
• Re: JSON fields with backslashes
  • From: Erik Wienhold
• Re: psql \du no more showing "member of" column
  • From: hubert depesz lubaczewski
• Re: JSON fields with backslashes
  • From: David G. Johnston
• Re: JSON fields with backslashes
  • From: Tom Lane
• JSON fields with backslashes
  • From: Greig Wise
• Re: psql \du no more showing "member of" column
  • From: Pavel Luzanov
• Re: Postgresql HA cluster
  • From: Laura Smith
• Re: psql \du no more showing "member of" column
  • From: Lele Gaifax
• Re: Question About PostgreSQL Extensibility
  • From: felix . quintgz
• Re: psql \du no more showing "member of" column
  • From: Luca Ferrari
• Re: psql \du no more showing "member of" column
  • From: Ian Lawrence Barwick
• Re: Postgresql HA cluster
  • From: Jehan-Guillaume de Rorthais
• RE: Postgresql HA cluster
  • From: Jason Grammenos
• psql \du no more showing "member of" column
  • From: Luca Ferrari
• Re: Can not drop partition if exist foreign keys
  • From: Laurenz Albe
• Re: Question About PostgreSQL Extensibility
  • From: Chris Travers
• Re: Postgresql HA cluster
  • From: Олег Самойлов
• Re: Question About PostgreSQL Extensibility
  • From: Ilya Kosmodemiansky
• Re: Can not drop partition if exist foreign keys
  • From: Олег Самойлов
• Re: List users privileges for whole cluster/all databases in the cluster
  • From: Dominique Devienne
• Re: List users privileges for whole cluster/all databases in the cluster
  • From: Tom Lane
• Re: List users privileges for whole cluster/all databases in the cluster
  • From: Priancka Chatz
• Re: Question About PostgreSQL Extensibility
  • From: Laurenz Albe
• List users privileges for whole cluster/all databases in the cluster
  • From: Jana Mihalidesová
• Question About PostgreSQL Extensibility
  • From: Sepideh Eidi
• Re: log wal file transfer in error logs
  • From: Laurenz Albe
• Re: Change error code severity for syslog?
  • From: Michael Paquier
• Change error code severity for syslog?
  • From: Abhishek Bhola
• Re: logs are not getting logged in error logs
  • From: Adrian Klaver
• logs are not getting logged in error logs
  • From: Atul Kumar
• Re: A question about possible recovery inconsistency
  • From: Ron
• Re: Assitance needed for the resolution of memory leak
  • From: Ron
• Re: Assitance needed for the resolution of memory leak
  • From: Sasmit Utkarsh
• Re: Assitance needed for the resolution of memory leak
  • From: Tom Lane
• Re: Assitance needed for the resolution of memory leak
  • From: Sasmit Utkarsh
• Re: Assitance needed for the resolution of memory leak
  • From: Adrian Klaver
• Assitance needed for the resolution of memory leak
  • From: Sasmit Utkarsh
• Re: log wal file transfer in error logs
  • From: Ron
• Postgresql HA cluster
  • From: Jason Grammenos
• Re: log wal file transfer in error logs
  • From: Atul Kumar
• Re: A question about possible recovery inconsistency
  • From: Ron
• log wal file transfer in error logs
  • From: Atul Kumar
• Re: log wal file transfer in error logs
  • From: Laurenz Albe
• Re: moving data with pg_dump/pg_restore between database with different locale
  • From: Laurenz Albe
• Re: A question about possible recovery inconsistency
  • From: Eugen Konkov
• Re: No Data Being Inserted
  • From: Adrian Klaver
• Re: Subject: FATAL: cache lookup failed for relation 1247
  • From: Tom Lane
• Re: No Data Being Inserted
  • From: Ron
• Can not drop partition if exist foreign keys
  • From: Олег Самойлов
• No Data Being Inserted
  • From: Anthony Apollis
• moving data with pg_dump/pg_restore between database with different locale
  • From: Zwettler Markus (OIZ)
• Re: Can not drop partition if exist foreign keys
  • From: Laurenz Albe
• Re: Can not drop partition if exist foreign keys
  • From: Alvaro Herrera
• Subject: FATAL: cache lookup failed for relation 1247
  • From: Israr Khan
• Re: A question about possible recovery inconsistency
  • From: Laurenz Albe
• Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: Tom Lane
• Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: Peter Eisentraut
• A question about possible recovery inconsistency
  • From: Eugen Konkov
• Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: Tom Lane
• Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: Laurenz Albe
• Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: Tatsuo Ishii
• Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: Julien Rouhaud
• Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: Laurenz Albe
• Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  • From: David HJ
• GIST index and ORDER BY
  • From: Michał Kłeczek
• RE: Ask about Foreign Table Plug-in on Windows Server.
  • From: Anuwat Sagulmontreechai
• Re: Index scan is not pushed down to union all subquery
  • From: Lauri Kajan
• Re: Multiple inserts with two levels of foreign keys
  • From: Dow Drake
• Re: Multiple inserts with two levels of foreign keys
  • From: Peter J. Holzer
• Re: psql trying twice to connect to local DB
  • From: Ron
• Re: psql trying twice to connect to local DB
  • From: Steve Baldwin
• Re: psql trying twice to connect to local DB
  • From: Tom Lane
• psql trying twice to connect to local DB
  • From: Steve Baldwin
• Monitoring logical replication
  • From: Shaheed Haque
• Re: Gradual migration from integer to bigint?
  • From: Bruce Momjian
• Re: why generated columsn cannot be used in COPY TO?
  • From: David G. Johnston
• Re: why generated columsn cannot be used in COPY TO?
  • From: Tom Lane
• Re: why generated columsn cannot be used in COPY TO?
  • From: Ron
• Re: why generated columsn cannot be used in COPY TO?
  • From: David G. Johnston
• Re: why generated columsn cannot be used in COPY TO?
  • From: Adrian Klaver
• Re: why generated columsn cannot be used in COPY TO?
  • From: Ron
• Re: why generated columsn cannot be used in COPY TO?
  • From: Dominique Devienne
• Re: why generated columsn cannot be used in COPY TO?
  • From: David G. Johnston
• Re: why generated columsn cannot be used in COPY TO?
  • From: Rob Sargent
• Re: How to make a map in pg kernel?
  • From: Artur Zakirov
• Re: why generated columsn cannot be used in COPY TO?
  • From: Andreas Kretschmer
• Re: why generated columsn cannot be used in COPY TO?
  • From: Tom Lane
• Re: why generated columsn cannot be used in COPY TO?
  • From: Ron
• Re: why generated columsn cannot be used in COPY TO?
  • From: Andreas Kretschmer
• why generated columsn cannot be used in COPY TO?
  • From: Luca Ferrari
• Re: No yum repo for CentOS 7 and postgres 16?
  • From: Jeff Ross
• No yum repo for CentOS 7 and postgres 16?
  • From: David G. Johnston
• No yum repo for CentOS 7 and postgres 16?
  • From: Jeff Ross
• Re: Ask about Foreign Table Plug-in on Windows Server.
  • From: Laurenz Albe
• Ask about Foreign Table Plug-in on Windows Server.
  • From: Anuwat Sagulmontreechai
• Re: Multiple inserts with two levels of foreign keys
  • From: Ron
• Re: Multiple inserts with two levels of foreign keys
  • From: Dow Drake
• How to make a map in pg kernel?
  • From: jacktby jacktby
• Re: Index scan is not pushed down to union all subquery
  • From: Lauri Kajan
• Re: pgBackRest for a 50 TB database
  • From: Stephen Frost
• Re: Gradual migration from integer to bigint?
  • From: Nick Cleaton
• Re: Index scan is not pushed down to union all subquery
  • From: Dominique Devienne
• Re: Index scan is not pushed down to union all subquery
  • From: Marian Wendt
• Re: Multiple inserts with two levels of foreign keys
  • From: Alvaro Herrera
• Re: Index scan is not pushed down to union all subquery
  • From: Marian Wendt
• Re: Index scan is not pushed down to union all subquery
  • From: Marian Wendt
• Re: pgBackRest for a 50 TB database
  • From: Abhishek Bhola
• Index scan is not pushed down to union all subquery
  • From: Lauri Kajan
• Re: Multiple inserts with two levels of foreign keys
  • From: Ron
• Re: Multiple inserts with two levels of foreign keys
  • From: Dow Drake
• Re: Multiple inserts with two levels of foreign keys
  • From: Ron
• Re: Multiple inserts with two levels of foreign keys
  • From: Dow Drake
• Re: Multiple inserts with two levels of foreign keys
  • From: Ron
• Multiple inserts with two levels of foreign keys
  • From: Dow Drake
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Alban Hertroys
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Brent Wood
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Lincoln Swaine-Moore
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Lincoln Swaine-Moore
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Alban Hertroys
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Steve Crawford
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Lincoln Swaine-Moore
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Tom Lane
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Lincoln Swaine-Moore
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Tom Lane
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Lincoln Swaine-Moore
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Tom Lane
• Re: [EXT]Re: Strange error trying to import with Ora2PG
  • From: Johnson, Bruce E - (bjohnson)
• I'm using both window and agg, is this expected sorting behavior?
  • From: jinser
• Re: I'm using both window and agg, is this expected sorting behavior?
  • From: Tom Lane
• Re: [EXT]Re: Strange error trying to import with Ora2PG
  • From: Johnson, Bruce E - (bjohnson)
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Lincoln Swaine-Moore
• Re: [EXT]Re: Strange error trying to import with Ora2PG
  • From: Adrian Klaver
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Marian Wendt
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Tom Lane
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Marian Wendt
• Re: Peer authentication failed ???
  • From: Amn Ojee Uw
• Re: pgBackRest for a 50 TB database
  • From: KK CHN
• Re: pgBackRest for a 50 TB database
  • From: Abhishek Bhola
• Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Steve Crawford
• Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  • From: Lincoln Swaine-Moore
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Laurenz Albe
• Re: Problems starting slave
  • From: Ron
• Re: Peer authentication failed ???
  • From: Peter J. Holzer
• Re: pg_stat_statements IN problem
  • From: byme
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Dominique Devienne
• Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Adrian Klaver
• Re: Strange error trying to import with Ora2PG
  • From: Adrian Klaver
• Strange error trying to import with Ora2PG
  • From: Johnson, Bruce E - (bjohnson)
• Re: specifying multiple options in URI psql behaviour?
  • From: Ron
• Re: How to investigate deadlocks
  • From: Andreas Kretschmer
• Re: pgBackRest for a 50 TB database
  • From: Stephen Frost
• Logical Replication vs. Free Replication Slots
  • From: Don Seiler
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Michael Paquier
• Re: Logical Replication vs. Free Replication Slots
  • From: Don Seiler
• Problems starting slave
  • From: Douglas Reed
• Re: Problems starting slave
  • From: Ron
• Re: Problems starting slave
  • From: Douglas Reed
• Re: Operating of synchronous master when no standby is available
  • From: MATSUO Takatoshi
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: rob stone
• Re: Operating of synchronous master when no standby is available
  • From: Sergey Cherukhin
• Re: Peer authentication failed ???
  • From: David G. Johnston
• Re: Operating of synchronous master when no standby is available
  • From: Sergey Cherukhin
• Cancelling "vacuum full" in single user mode?
  • From: Colin 't Hart
• Peer authentication failed ???
  • From: Amn Ojee Uw
• Re: specifying multiple options in URI psql behaviour?
  • From: Tom Lane
• Re: pg_stat_statements IN problem
  • From: David Rowley
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Michael Paquier
• Re: How to investigate deadlocks
  • From: David G. Johnston
• Re: Operating of synchronous master when no standby is available
  • From: MATSUO Takatoshi
• Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Harry Green
• Re: pg_stat_statements IN problem
  • From: byme
• specifying multiple options in URI psql behaviour?
  • From: Wim Bertels
• Re: pg_stat_statements IN problem
  • From: Laurenz Albe
• Re: How to investigate deadlocks
  • From: Laurenz Albe
• Re: pg_stat_statements IN problem
  • From: David Rowley
• Re: How to investigate deadlocks
  • From: Andreas Kretschmer
• Re: Cancelling "vacuum full" in single user mode?
  • From: Laurenz Albe
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Dominique Devienne
• Cancelling "vacuum full" in single user mode?
  • From: Colin 't Hart
• Re: pgBackRest for a 50 TB database
  • From: Abhishek Bhola
• Re: Trigger functions and parallelism
  • From: Karl O. Pinc
• Trigger functions and parallelism
  • From: Karl O. Pinc
• Re: pg_agent jobs
  • From: Giovanni Biscontini
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Michael Paquier
• Re: pg_stat_statements IN problem
  • From: Wim Bertels
• Re: Trigger functions and parallelism
  • From: Tom Lane
• Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Laurenz Albe
• Re: Operating of synchronous master when no standby is available
  • From: Andreas Kretschmer
• Re: Operating of synchronous master when no standby is available
  • From: Ron
• How to investigate deadlocks
  • From: Matthias Apitz
• Re: specifying multiple options in URI psql behaviour?
  • From: Wim Bertels
• pg_stat_statements IN problem
  • From: byme
• How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  • From: Dominique Devienne
• Re: pg_agent jobs
  • From: Adrian Klaver
• Re: How to investigate deadlocks
  • From: Tom Lane
• Operating of synchronous master when no standby is available
  • From: Sergey Cherukhin
• Re: Gradual migration from integer to bigint?
  • From: Ron
• Re: Gradual migration from integer to bigint?
  • From: Ann Harrison
• Re: Gradual migration from integer to bigint?
  • From: Ireneusz Pluta
• What changes to a table cannot be detected by a trigger?
  • From: Phillip Diffley
• Re: cache lookup failed for function 0
  • From: Tom Lane
• Re: Gradual migration from integer to bigint?
  • From: Ron
• Re: Gradual migration from integer to bigint?
  • From: James Healy
• Re: Gradual migration from integer to bigint?
  • From: James Healy
• Re: cache lookup failed for function 0
  • From: pf
• Re: Gradual migration from integer to bigint?
  • From: Tom Lane
• Re: cache lookup failed for function 0
  • From: pf
• Re: cache lookup failed for function 0
  • From: Adrian Klaver
• Re: cache lookup failed for function 0
  • From: Adrian Klaver
• Re: cache lookup failed for function 0
  • From: Tom Lane
• Re: cache lookup failed for function 0
  • From: pf
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: cache lookup failed for function 0
  • From: pf
• Re: cache lookup failed for function 0
  • From: pf
• Re: Right version of jdbc
  • From: postgresql439848
• Re: Right version of jdbc
  • From: Raivo Rebane
• cache lookup failed for function 0
  • From: pf
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Gradual migration from integer to bigint?
  • From: grimy . outshine830
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: pg_agent jobs
  • From: Adrian Klaver
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: cache lookup failed for function 0
  • From: Adrian Klaver
• Re: [EXT] YNT: Need help tuning a query
  • From: Amn Ojee Uw
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: Gradual migration from integer to bigint?
  • From: Bruce Momjian
• Re: cache lookup failed for function 0
  • From: Pierre Fortin
• Gradual migration from integer to bigint?
  • From: James Healy
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: cache lookup failed for function 0
  • From: pf
• Re: cache lookup failed for function 0
  • From: Tom Lane
• Re: cache lookup failed for function 0
  • From: Tom Lane
• Re: Right version of jdbc
  • From: Raivo Rebane
• RE: [EXT] YNT: Need help tuning a query
  • From: Wong, Kam Fook (TR Technology)
• Re: Right version of jdbc
  • From: Craig McIlwee
• Re: cache lookup failed for function 0
  • From: Adrian Klaver
• pg_agent jobs
  • From: Giovanni Biscontini
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: postgresql439848
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: [EXT] YNT: Need help tuning a query
  • From: Vladimir Sitnikov
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: [EXT] YNT: Need help tuning a query
  • From: Vladimir Sitnikov
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: cast bytea to macaddr
  • From: Boris Zentner
• Right version of jdbc
  • From: Raivo Rebane
• Re: cast bytea to macaddr
  • From: Matt Zagrabelny
• Re: Right version of jdbc
  • From: Ron
• RE: [EXT] YNT: Need help tuning a query
  • From: Wong, Kam Fook (TR Technology)
• Re: Right version of jdbc
  • From: Rob Sargent
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: Dave Cramer
• YNT: Need help tuning a query
  • From: Mehmet Çakoğlu
• cast bytea to macaddr
  • From: Matt Zagrabelny
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: valid casts to anyarray
  • From: Philip Carlsen
• Re: debugger from superuser only.... why?
  • From: Luca Ferrari
• Re: Ad hoc SETOF type definition?
  • From: Merlin Moncure
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: debugger from superuser only.... why?
  • From: Alexander Petrossian
• pg*.dll in psqlODBC have no version numbers
  • From: Mark Hill
• Need help tuning a query
  • From: Dirschel, Steve
• valid casts to anyarray
  • From: Philip Carlsen
• Re: Regarding PostgreSQL 15.4
  • From: Erik Wienhold
• Re: valid casts to anyarray
  • From: Laurenz Albe
• Re: valid casts to anyarray
  • From: Tom Lane
• Re: Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })
  • From: dld
• Re: debugger from superuser only.... why?
  • From: Tom Lane
• Re: log_statement vs log_min_duration_statement
  • From: Laurenz Albe
• Regarding PostgreSQL 15.4
  • From: Somnath Som
• Re: Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })
  • From: Erik Wienhold
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: log_statement vs log_min_duration_statement
  • From: Jeff Janes
• Re: Ad hoc SETOF type definition?
  • From: Ron
• Re: Ad hoc SETOF type definition?
  • From: Adrian Klaver
• Re: Ad hoc SETOF type definition?
  • From: Adrian Klaver
• Is the logfile the only place to find the finish LSN?
  • From: pgchem pgchem
• Re: Ad hoc SETOF type definition?
  • From: Ron
• Re: Ad hoc SETOF type definition?
  • From: Ron
• Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })
  • From: dld
• Re: Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })
  • From: Erik Wienhold
• Re: log_statement vs log_min_duration_statement
  • From: Maciek Sakrejda
• Re: Ad hoc SETOF type definition?
  • From: Adrian Klaver
• Re: log_statement vs log_min_duration_statement
  • From: Adrian Klaver
• Ad hoc SETOF type definition?
  • From: Ron
• log_statement vs log_min_duration_statement
  • From: Atul Kumar
• Re: Ad hoc SETOF type definition?
  • From: Tom Lane
• Re: Ad hoc SETOF type definition?
  • From: Tom Lane
• Re: [EXT]Re: Accessing system information functions
  • From: Johnson, Bruce E - (bjohnson)
• Re: Postgres 11.5 not logging all sqls
  • From: Adrian Klaver
• Re: Postgres 11.5 not logging all sqls
  • From: shashidhar Reddy
• Move from v9.4 to v15
  • From: Brad White
• Re: Postgres 11.5 not logging all sqls
  • From: shashidhar Reddy
• Re: Postgres 11.5 not logging all sqls
  • From: Adrian Klaver
• Re: Right version of jdbc
  • From: Rob Sargent
• Re: Accessing system information functions
  • From: Pavel Stehule
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: debugger from superuser only.... why?
  • From: Luca Ferrari
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: debugger from superuser only.... why?
  • From: Alexander Petrossian
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: Accessing system information functions
  • From: Rob Sargent
• Re: Postgres 11.5 not logging all sqls
  • From: shashidhar Reddy
• Re: debugger from superuser only.... why?
  • From: Alexander Petrossian (PAF)
• Right version of jdbc
  • From: Raivo Rebane
• Re: Postgres 11.5 not logging all sqls
  • From: Erik Wienhold
• Re: debugger from superuser only.... why?
  • From: Tom Lane
• Re: Accessing system information functions
  • From: Rob Sargent
• Re: Right version of jdbc
  • From: Raivo Rebane
• Re: Right version of jdbc
  • From: Dave Cramer
• Postgres 11.5 not logging all sqls
  • From: shashidhar Reddy
• Re: Right version of jdbc
  • From: Thomas Kellerer
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: Accessing system information functions
  • From: Erik Wienhold
• Re: Postgres 11.5 not logging all sqls
  • From: Laurenz Albe
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: Right version of jdbc
  • From: Dave Cramer
• Re: Right version of jdbc
  • From: Dave Cramer
• Accessing system information functions
  • From: Johnson, Bruce E - (bjohnson)
• Re: Question regarding specifics of GIN and pg_trgm performance and potential use of show_trgm to improve it
  • From: Jeff Janes
• jdbc problem
  • From: Raivo Rebane
• jdbc problem
  • From: Raivo Rebane
• Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: Chris Kelly
• Re: jdbc problem
  • From: Laurenz Albe
• Re: jdbc problem
  • From: postgresql439848
• Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: Ray O'Donnell
• Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: postmaster
• Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: Chris Kelly
• Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: Ray O'Donnell
• Re: connecting to new instance
  • From: Alan Hodgson
• Re: Start service
  • From: Nick Ivanov
• Re: connecting to new instance
  • From: Adrian Klaver
• Re: Start service
  • From: Brad White
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: David G. Johnston
• Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: Adrian Klaver
• Re: Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: Ray O'Donnell
• connecting to new instance
  • From: Brad White
• Ubuntu 18 + PHP 8.2 + PDO: can't find drivers
  • From: Chris Kelly
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Brad White
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Dominique Devienne
• Re: Changed functionality from 14.3 to 15.3
  • From: Michael Corey
• How to fork pg_dump or psql w/o leaking secrets?
  • From: David G. Johnston
• Re: Start service
  • From: Brad White
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: David G. Johnston
• Start service
  • From: Brad White
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Dominique Devienne
• Re: Start service
  • From: Brad White
• Re: debugger from superuser only.... why?
  • From: Luca Ferrari
• StackBuilder unexpected restart
  • From: russcampbell
• Re: Start service
  • From: postgresql439848
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Dominique Devienne
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Luca Ferrari
• Re: debugger from superuser only.... why?
  • From: postgresql439848
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Tom Lane
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Francisco Olarte
• Re: debugger from superuser only.... why?
  • From: Luca Ferrari
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Luca Ferrari
• Re: Migration of Oracle Vault to Postgres
  • From: Laurenz Albe
• Re: debugger from superuser only.... why?
  • From: Luca Ferrari
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Luca Ferrari
• Re: How to fork pg_dump or psql w/o leaking secrets?
  • From: Dominique Devienne
• Migration of Oracle Vault to Postgres
  • From: Elango Thiagarajan
• How to fork pg_dump or psql w/o leaking secrets?
  • From: Dominique Devienne
• Re: whether I can add a new encoding?
  • From: Tom Lane
• whether I can add a new encoding?
  • From: Pandora
• Re: whether I can add a new encoding?
  • From: Tatsuo Ishii
• Re: Database selection
  • From: Laurenz Albe
• Re: Changed functionality from 14.3 to 15.3
  • From: Laurenz Albe
• Re: Changed functionality from 14.3 to 15.3
  • From: Erik Wienhold
• Re: Changed functionality from 14.3 to 15.3
  • From: Erik Wienhold
• Re: Changed functionality from 14.3 to 15.3
  • From: Michael Corey
• Re: Changed functionality from 14.3 to 15.3
  • From: Erik Wienhold
• Re: Changed functionality from 14.3 to 15.3
  • From: David G. Johnston
• Cannot link against libpq on macOS
  • From: A. Reichstadt
• Re: Changed functionality from 14.3 to 15.3
  • From: Michael Corey
• Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: Laurenz Albe
• Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: Harry Green
• Re: Database selection
  • From: veem v
• Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: Adrian Klaver
• Database selection
  • From: veem v
• Re: Database selection
  • From: Laurenz Albe
• Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: David G. Johnston
• Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Harry Green
• Re: Changed functionality from 14.3 to 15.3
  • From: Erik Wienhold
• Re: Changed functionality from 14.3 to 15.3
  • From: David G. Johnston
• Re: Changed functionality from 14.3 to 15.3
  • From: Imre Samu
• Re: Changed functionality from 14.3 to 15.3
  • From: Michael Corey
• Re: Changed functionality from 14.3 to 15.3
  • From: Michael Corey
• Re: Database selection
  • From: Christophe Pettus
• Re: Changed functionality from 14.3 to 15.3
  • From: Erik Wienhold
• Re: Calculating Days/Time(Are Loops Neccessary?)
  • From: Alvaro Herrera
• Re: Calculating Days/Time(Are Loops Neccessary?)
  • From: Adrian Klaver
• Re: Changed functionality from 14.3 to 15.3
  • From: Michael Corey
• Re: could not open file "base/XX/XX": Interrupted system call
  • From: Torsten Krah
• Re: could not open file "base/XX/XX": Interrupted system call
  • From: Laurenz Albe
• debugger from superuser only.... why?
  • From: Александр Петросян (web)
• could not open file "base/XX/XX": Interrupted system call
  • From: Torsten Krah
• Re: Changed functionality from 14.3 to 15.3
  • From: Erik Wienhold
• Calculating Days/Time(Are Loops Neccessary?)
  • From: Anthony Apollis
• Changed functionality from 14.3 to 15.3
  • From: Michael Corey
• [Beginner Question]What should I do if I want to achieve lsm-tree index in postgresql?
  • From: Wen Yi
• 回复: ident auth does not works as usual
  • From: pan snowave
• Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: Laurenz Albe
• Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Adrian Klaver
• Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Johnson, Bruce E - (bjohnson)
• Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Israel Brewster
• Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Adrian Klaver
• Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: Adrian Klaver
• Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  • From: Tom Lane
• trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: Harry Green
• Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: Adrian Klaver
• Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
  • From: David G. Johnston
• How to synchronize the read/write DB on my laptop with the read-only DB on cloud (primary on premises, replica on cloud)?
  • From: Utku
• Re: Ensuring Rifferential Integrity
  • From: Peter J. Holzer
• Ensuring Rifferential Integrity
  • From: Anthony Apollis
• Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?
  • From: James Stuart
• Re: update from 13 to16
  • From: Maciek Sakrejda
• Re: Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?
  • From: Tom Lane
• update from 13 to16
  • From: Martin Mueller
• Re: update from 13 to16
  • From: Adrian Klaver
• RE: Access plan selection logic PG9.2 -> PG14
  • From: Ryo Yamaji (Fujitsu)
• RE: Access plan selection logic PG9.2 -> PG14
  • From: Ryo Yamaji (Fujitsu)
• Re: Access plan selection logic PG9.2 -> PG14
  • From: David Rowley
• RE: Help with PostgreSQL Upgrade
  • From: SMITH Matt
• Re: Help with PostgreSQL Upgrade
  • From: Adrian Klaver
• Re: Access plan selection logic PG9.2 -> PG14
  • From: Adrian Klaver
• Re: Access plan selection logic PG9.2 -> PG14
  • From: David Rowley
• Help with PostgreSQL Upgrade
  • From: SMITH Matt
• Re: Help with PostgreSQL Upgrade
  • From: Daniel Gustafsson
• Access plan selection logic PG9.2 -> PG14
  • From: Ryo Yamaji (Fujitsu)
• Re: Making Sure Primary and Secondary Keys Alligns
  • From: Sándor Daku
• Re: Unqualified relations in views
  • From: Pete O'Such
• RE: [EXT] Re: Query performance going from Oracle to Postgres
  • From: Dirschel, Steve
• Re: Unqualified relations in views
  • From: Laurenz Albe
• Re: Making Sure Primary and Secondary Keys Alligns
  • From: Anthony Apollis
• Unqualified relations in views
  • From: Pete O'Such
• Re: pg_update and encoding
  • From: Adrian Klaver
• Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
  • From: duc hiep ha
• Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
  • From: DAVID ROTH
• Re: Upgrade problem
  • From: Adrian Klaver
• Re: pg_update and encoding
  • From: Graeme
• Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
  • From: Daniel Gustafsson
• Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
  • From: Matthias Apitz
• Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
  • From: Peter J. Holzer
• pg_update and encoding
  • From: Graeme
• Re: Upgrade problem
  • From: Graeme
• Re: Upgrade problem
  • From: Peter J. Holzer
• Granting privileges to a schema to a role
  • From: Johnson, Bruce E - (bjohnson)
• Re: Granting privileges to a schema to a role
  • From: Erik Wienhold
• Re: Upgrade problem
  • From: Adrian Klaver
• Can't drop logical replication slot
  • From: Eduardo Gargiulo
• Re: Upgrade problem
  • From: Ray O'Donnell
• Re: Upgrade problem
  • From: Adrian Klaver
• Re: Making Sure Primary and Secondary Keys Alligns
  • From: Alban Hertroys
• Re: Upgrade problem
  • From: Graeme
• Re: Upgrade problem
  • From: Tom Lane
• Re: Upgrade problem
  • From: Graeme
• Re: Upgrade problem
  • From: Tom Lane
• Upgrade problem
  • From: Graeme
• Making Sure Primary and Secondary Keys Alligns
  • From: Anthony Apollis
• Re: ERROR: stack depth limit exceeded
  • From: gzh
• Re: pgsql --echo-errors --quiet and setval
  • From: David G. Johnston
• Re: pgsql --echo-errors --quiet and setval
  • From: Tom Lane
• Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
  • From: Alban Hertroys
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Peter J. Holzer
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Peter J. Holzer
• pgsql --echo-errors --quiet and setval
  • From: Les
• Re: pgsql --echo-errors --quiet and setval
  • From: David G. Johnston
• Re: pgsql --echo-errors --quiet and setval
  • From: Adrian Klaver
• Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
  • From: Adrian Klaver
• Re: pg_restore unexpected end of file
  • From: Adrian Klaver
• Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?
  • From: duc hiep ha
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Dominique Devienne
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Dominique Devienne
• Re: ERROR: stack depth limit exceeded
  • From: Tom Lane
• Re: ERROR: stack depth limit exceeded
  • From: Laurenz Albe
• Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"
  • From: Nature Conservation Geovista Space
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Rob Sargent
• Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Torsten Krah
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Sai Teja
• Re: ERROR: stack depth limit exceeded
  • From: gzh
• Re: Query performance going from Oracle to Postgres
  • From: Peter Geoghegan
• Re: Will PostgreSQL 16 supports native transparent data encryption ?
  • From: Matthias Apitz
• pg_restore unexpected end of file
  • From: Les
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: David G. Johnston
• Re: Will PostgreSQL 16 supports native transparent data encryption ?
  • From: Stephen Frost
• Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Sai Teja
• Re: Will PostgreSQL 16 supports native transparent data encryption ?
  • From: Stephen Frost
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Erik Wienhold
• Re: Query performance going from Oracle to Postgres
  • From: David Rowley
• Re: Only getting few records inserted from millions
  • From: Erik Wienhold
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Tom Lane
• Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL
  • From: Tom Lane
• Only getting few records inserted from millions
  • From: Anthony Apollis
• Feedback on supporting AI queries in Postgres with EvaDB
  • From: Arulraj, Joy
• Re: listening on an address other than 'localhost'?
  • From: Adrian Klaver
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Joe Conway
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Helmut Bender
• ERROR: stack depth limit exceeded
  • From: gzh
• listening on an address other than 'localhost'?
  • From: Johnson, Bruce E - (bjohnson)
• Re: ERROR: stack depth limit exceeded
  • From: Geoff Winkless
• Re: ERROR: stack depth limit exceeded
  • From: Tom Lane
• Re: listening on an address other than 'localhost'?
  • From: Erik Wienhold
• Re: Query performance going from Oracle to Postgres
  • From: David Rowley
• Re: listening on an address other than 'localhost'?
  • From: Daniel Gustafsson
• Re: Query performance going from Oracle to Postgres
  • From: Peter Geoghegan
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Jehan-Guillaume de Rorthais
• Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Imre Samu
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Erik Wienhold
• Re: Ynt: Pgbackrest Restore Error - Segmentation fault (core dumped)
  • From: Rob Sargent
• Re: Query performance going from Oracle to Postgres
  • From: Laurenz Albe
• Query performance going from Oracle to Postgres
  • From: Dirschel, Steve
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Sai Teja
• Re: Q: inet operators for IPv4 encapsulated in IPv6
  • From: Albrecht Dreß
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Erik Wienhold
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Laurenz Albe
• Ynt: Pgbackrest Restore Error - Segmentation fault (core dumped)
  • From: pgdba pgdba
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Sai Teja
• Re: Q: inet operators for IPv4 encapsulated in IPv6
  • From: Erik Wienhold
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Erik Wienhold
• Re: Postgres partition max limit
  • From: Chris Travers
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Francisco Olarte
• Re: Postgres partition max limit
  • From: Laurenz Albe
• Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Laurenz Albe
• Re: Pgbackrest Restore Error - Segmentation fault (core dumped)
  • From: Rob Sargent
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Sai Teja
• Q: inet operators for IPv4 encapsulated in IPv6
  • From: Albrecht Dreß
• postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Sai Teja
• Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Torsten Krah
• Re: postgreSQL UPPER Method is converting the character "µ" into "M"
  • From: Tom Lane
• Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Torsten Krah
• running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Torsten Krah
• Re: Pgbackrest Restore Error - Segmentation fault (core dumped)
  • From: Daniel Gustafsson
• Pgbackrest Restore Error - Segmentation fault (core dumped)
  • From: pgdba pgdba
• Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Erik Wienhold
• Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
  • From: Laurenz Albe
• Postgres partition max limit
  • From: Daulat
• Re: Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume
  • From: Lorusso Domenico
• Re: ./configure doesn't make effect?
  • From: David G. Johnston
• Re: Strategy for migrating from Oracle to PG
  • From: Deep
• Re: ./configure doesn't make effect?
  • From: jacktby jacktby
• Re: ./configure doesn't make effect?
  • From: Adrian Klaver
• Re: rollback to savepoint issue
  • From: Alvaro Herrera
• ./configure doesn't make effect?
  • From: jacktby jacktby
• Re: ./configure doesn't make effect?
  • From: Erik Wienhold
• Re: rollback to savepoint issue
  • From: Tom Lane
• Re: pg_dump/pg_restore and the magic of the search_path
  • From: Arthur Bazin
• Strategy for migrating from Oracle to PG
  • From: Johnson, Bruce E - (bjohnson)
• Re: Will PostgreSQL 16 supports native transparent data encryption ?
  • From: Matthias Apitz
• Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume
  • From: wheels
• Re: Array vs Temporary table vs Normal Table + truncate at end
  • From: Laurenz Albe
• Re: createuser unexpectedly creates superuser with createdb and createrole
  • From: Laurenz Albe
• Re: createuser unexpectedly creates superuser with createdb and createrole
  • From: Erik Wienhold
• Array vs Temporary table vs Normal Table + truncate at end
  • From: Lorusso Domenico
• Re: rollback to savepoint issue
  • From: Dominique Devienne
• Re: rollback to savepoint issue
  • From: David G. Johnston
• Re: rollback to savepoint issue
  • From: Erik Wienhold
• Re: rollback to savepoint issue
  • From: Erik Wienhold
• Re: rollback to savepoint issue
  • From: Adrian Klaver
• Re: rollback to savepoint issue
  • From: Dominique Devienne
• Re: [EXTERNAL] Oracle FDW version
  • From: Adam Lee
• Re: rollback to savepoint issue
  • From: Tom Lane
• rollback to savepoint issue
  • From: Lorusso Domenico
• Re: Question on Partition key
  • From: David Rowley
• Re: [EXTERNAL] Oracle FDW version
  • From: Jethro Elmer Sanidad
• Re: PSQL = Yes ... JDBC = no ??
  • From: Peter J. Holzer
• Re: createuser unexpectedly creates superuser with createdb and createrole
  • From: Erik Wienhold
• Re: PSQL = Yes ... JDBC = no ??
  • From: Maciek Sakrejda
• Re: PSQL = Yes ... JDBC = no ??
  • From: Amn Ojee Uw
• Re: PSQL = Yes ... JDBC = no ??
  • From: David G. Johnston
• Re: PSQL = Yes ... JDBC = no ??
  • From: Adrian Klaver
• Re: createuser unexpectedly creates superuser with createdb and createrole
  • From: Tom Lane
• Re: PSQL = Yes ... JDBC = no ??
  • From: Amn Ojee Uw
• Re: PSQL = Yes ... JDBC = no ??
  • From: Adrian Klaver
• PSQL = Yes ... JDBC = no ??
  • From: Amn Ojee Uw
• Re: Question on Partition key
  • From: veem v
• Re: Question on Partition key
  • From: Deep
• Question on Partition key
  • From: veem v
• Re: Question on Partition key
  • From: Erik Wienhold
• Re: Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)
  • From: Adrian Klaver
• Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)
  • From: Sai Teja
• Re: PG FDW query fails, works local, same credentials
  • From: Pete O'Such
• Re: [EXTERNAL] Oracle FDW version
  • From: Jethro Elmer Sanidad
• Re: pg_dump/pg_restore and the magic of the search_path
  • From: Erik Wienhold
• pg_dump/pg_restore and the magic of the search_path
  • From: Arthur Bazin
• Re: pg_visible_in_snapshot clarification
  • From: Luca Ferrari
• Re: event trigger clarification
  • From: Marc Millas
• Re: event trigger clarification
  • From: Marc Millas
• PG FDW query fails, works local, same credentials
  • From: Pete O'Such
• Re: PG FDW query fails, works local, same credentials
  • From: Tom Lane
• Re: Partitionwise JOIN scanning all partitions, even unneeded ones
  • From: Dimitrios Apostolou
• Re: Partitionwise JOIN scanning all partitions, even unneeded ones
  • From: David Rowley
• Partitionwise JOIN scanning all partitions, even unneeded ones
  • From: Dimitrios Apostolou
• Re: event trigger clarification
  • From: David G. Johnston
• Re: event trigger clarification
  • From: Erik Wienhold
• event trigger clarification
  • From: Marc Millas
• Re: Calculating vm.nr_hugepages
  • From: Erik Wienhold
• Re: Calculating vm.nr_hugepages
  • From: Don Seiler
• Calculating vm.nr_hugepages
  • From: Troels Arvin
• Re: Restoring default privileges on objects
  • From: Peter J. Holzer
• Re: [INTERNET] Re: auto vacuum question
  • From: Jerry Sievers
• createuser unexpectedly creates superuser with createdb and createrole
  • From: Erik Wienhold
• Re: createuser unexpectedly creates superuser with createdb and createrole
  • From: Laurenz Albe
• Re: Restoring default privileges on objects
  • From: Erik Wienhold
• Re: Restoring default privileges on objects
  • From: Stuart McGraw
• Re: [INTERNET] Re: auto vacuum question
  • From: Alan Stange
• Re: Restoring default privileges on objects
  • From: Erik Wienhold
• Re: Restoring default privileges on objects
  • From: Erik Wienhold
• Re: Restoring default privileges on objects
  • From: Tom Lane
• Re: Restoring default privileges on objects
  • From: Stuart McGraw
• Re: Restoring default privileges on objects
  • From: Tom Lane
• Re: Restoring default privileges on objects
  • From: Erik Wienhold
• Re: PL/Perl function signatures
  • From: Luca Ferrari
• Restoring default privileges on objects
  • From: Stuart McGraw
• Re: Postgres service is not starting
  • From: David G. Johnston
• Postgres service is not starting
  • From: Vinit Saini
• Re: auto vacuum question
  • From: Jerry Sievers
• Re: [INTERNET] Re: auto vacuum question
  • From: Adrian Klaver
• Re: [INTERNET] Re: auto vacuum question
  • From: Alan Stange
• Re: auto vacuum question
  • From: Adrian Klaver
• auto vacuum question
  • From: Alan Stange
• pg_visible_in_snapshot clarification
  • From: Mike Roest
• Re: ident auth does not works as usual
  • From: David G. Johnston
• Re: PostgreSQL 12 reindex
  • From: Joseph Kennedy
• PostgreSQL 12 reindex
  • From: Joseph Kennedy
• 回复: ident auth does not works as usual
  • From: pan snowave
• 回复: ident auth does not works as usual
  • From: pan snowave
• Re: Support for Deferred Constraints in PG15 Logical Replication
  • From: Laurenz Albe
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: duc hiep ha
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: Luca Ferrari
• PL/Perl function signatures
  • From: Luca Ferrari
• Re: Role for just read the data + avoid CREATE / ALTER / DROP
  • From: Durumdara
• Re: ident auth does not works as usual
  • From: David G. Johnston
• Re: pgBackRest for a 50 TB database
  • From: o1bigtenor
• Re: pgBackRest for a 50 TB database
  • From: Abhishek Bhola
• Re: pgBackRest for a 50 TB database
  • From: Stephen Frost
• pgBackRest for a 50 TB database
  • From: Abhishek Bhola
• Re: ident auth does not works as usual
  • From: David G. Johnston
• Re: ident auth does not works as usual
  • From: Alban Hertroys
• ident auth does not works as usual
  • From: pan snowave
• Re: Will PostgreSQL 16 supports native transparent data encryption ?
  • From: Ron
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: duc hiep ha
• Re: LDAP Authentication
  • From: Dominique Devienne
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: Luca Ferrari
• Re: Role for just read the data + avoid CREATE / ALTER / DROP
  • From: David G. Johnston
• Re: Role for just read the data + avoid CREATE / ALTER / DROP
  • From: Thomas Kellerer
• Aw: Role for just read the data + avoid CREATE / ALTER / DROP
  • From: Karsten Hilbert
• Re: LDAP Authentication
  • From: Stephen Frost
• Role for just read the data + avoid CREATE / ALTER / DROP
  • From: Durumdara
• Re: LDAP Authentication
  • From: Dominique Devienne
• Support for Deferred Constraints in PG15 Logical Replication
  • From: Jitesh Srivastava
• Re: Materialized view refreshing problem
  • From: Hellen Jiang
• Re: Will PostgreSQL 16 supports native transparent data encryption ?
  • From: Stephen Frost
• Re: LDAP Authentication
  • From: Stephen Frost
• Re: Materialized view refreshing problem
  • From: Tom Lane
• Re: Materialized view refreshing problem
  • From: Tom Lane
• Materialized view refreshing problem
  • From: Hellen Jiang
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: duc hiep ha
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: duc hiep ha
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: Erik Wienhold
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: Luca Ferrari
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: duc hiep ha
• Re: ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: Luca Ferrari
• ora2pg -c ora2pg.conf -t COPY -a tablename not working properly
  • From: duc hiep ha
• Re: Read only user permission
  • From: Dominique Devienne
• Re: Read only user permission
  • From: Erik Wienhold
• Re: Read only user permission
  • From: Dominique Devienne
• Re: [EXTERNAL] Oracle FDW version
  • From: Adam Lee
• Re: Read only user permission
  • From: jian he
• Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
  • From: Tushar Takate
• Re: Read only user permission
  • From: Rob Sargent
• Re: Read only user permission
  • From: Hellen Jiang
• Re: Read only user permission
  • From: Erik Wienhold
• Read only user permission
  • From: Hellen Jiang
• Re: Read only user permission
  • From: Marcos Pegoraro
• Re: Read only user permission
  • From: Tom Lane
• Re: [EXTERNAL] Oracle FDW version
  • From: Adrian Klaver
• archive_command debugging
  • From: Nick Renders
• Re: archive_command debugging
  • From: Christoph Moench-Tegeder
• Re: PL/pgSQL RETURN QUERY and DOMAIN CHECKs
  • From: David G. Johnston
• Re: Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset?
  • From: Rihad
• PL/pgSQL RETURN QUERY and DOMAIN CHECKs
  • From: Christian Barthel
• Re: [EXTERNAL] Oracle FDW version
  • From: Ian Lawrence Barwick
• Re: PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
  • From: Avinash Vallarapu
• PostgreSQL DB cluster migration from centos7/RHEL7/OEL7 to RHEL8
  • From: Tushar Takate
• Add primary key to existing, partitioned table
  • From: Arne Henrik Segtnan
• Re: [EXTERNAL] Oracle FDW version
  • From: Ian Lawrence Barwick
• Re: [EXTERNAL] Oracle FDW version
  • From: Jethro Elmer Sanidad
• Re: [EXTERNAL] Oracle FDW version
  • From: Justin Clift
• Re: [EXTERNAL] Re: Oracle FDW version
  • From: Jethro Elmer Sanidad
• Re: Oracle FDW version
  • From: Adrian Klaver
• Oracle FDW version
  • From: Jethro Elmer Sanidad
• Re: [EXTERNAL] Oracle FDW version
  • From: Christophe Pettus
• Re: [EXTERNAL] Re: Oracle FDW version
  • From: Tom Lane
• Re: Oracle FDW version
  • From: Tom Lane
• Re: JDBC + PG-15 but not psql
  • From: Amn Ojee Uw