Postgresql General Discussion

• Thread Index

• Fwd: PostGreSQL Replication and question on maintenance
  • From: github kran
• Re: Query which shows FK child columns?
  • From: Jeff Ross
• Query which shows FK child columns?
  • From: Ron
• Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208
  • From: Tom Lane
• PostGreSQL Replication and question on maintenance
  • From: github kran
• Re: Postgresql RDS DB Latency Chossing Hash join Plan
  • From: github kran
• Re: Problems modifyiong view
  • From: stan
• Re: Problems modifyiong view
  • From: stan
• Re: Problems modifyiong view
  • From: Adrian Klaver
• Re: Problems modifyiong view
  • From: Adrian Klaver
• Re: Problems modifyiong view
  • From: Tom Lane
• Re: INOUT PARAMETERS WITH RETURN TABLES IN FUNCTION
  • From: Adrian Klaver
• Re: Problems modifyiong view
  • From: Adrian Klaver
• RE: ERROR: COPY escape must be a single one-byte character (multi-delimiter appears to work on Postgres 9.0 but does not on Postgres 9.2)
  • From: Kevin Brannen
• Re: Problems modifyiong view
  • From: Tom Lane
• Re: Problems modifyiong view
  • From: Adrian Klaver
• Re: Problems modifyiong view
  • From: Igor Korot
• Problems modifyiong view
  • From: stan
• Re: root page 3 of index "pg_class_oid_index" has level 0, expected 1
  • From: Michael Paquier
• Re: terminated by signal 11: Segmentation fault
  • From: Gerrit Fouche
• Re: root page 3 of index "pg_class_oid_index" has level 0, expected 1
  • From: Laurenz Albe
• root page 3 of index "pg_class_oid_index" has level 0, expected 1
  • From: Abhijit Gharami
• Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208
  • From: Kyotaro Horiguchi
• Re: `pg_ls_dir` can query some directories, but not others
  • From: Brennan Vincent
• Re: ERROR: COPY escape must be a single one-byte character (multi-delimiter appears to work on Postgres 9.0 but does not on Postgres 9.2)
  • From: Adrian Klaver
• ERROR: COPY escape must be a single one-byte character (multi-delimiter appears to work on Postgres 9.0 but does not on Postgres 9.2)
  • From: Brandon Ragland
• Re: `pg_ls_dir` can query some directories, but not others
  • From: Adrian Klaver
• `pg_ls_dir` can query some directories, but not others
  • From: Brennan Vincent
• Re: Last autovacuum time - what is it?
  • From: Tom Lane
• Re: terminated by signal 11: Segmentation fault
  • From: Tom Lane
• Last autovacuum time - what is it?
  • From: Durumdara
• terminated by signal 11: Segmentation fault
  • From: Gerrit Fouche
• Re: CASE(?) to write in a different column based on a string pattern
  • From: Moreno Andreo
• Re: CASE(?) to write in a different column based on a string pattern
  • From: Moreno Andreo
• Re: CASE(?) to write in a different column based on a string pattern
  • From: Andrew Kerber
• Re: CASE(?) to write in a different column based on a string pattern
  • From: Geoff Winkless
• CASE(?) to write in a different column based on a string pattern
  • From: Moreno Andreo
• Re: here does postgres take its timezone information from?
  • From: Tom Lane
• Re: type SERIAL in C host-struct
  • From: Matthias Apitz
• Re: here does postgres take its timezone information from?
  • From: Thomas Munro
• Sv: DELETE Query Hang
  • From: Andreas Joseph Krogh
• Re: DELETE Query Hang
  • From: Rob Sargent
• Re: DELETE Query Hang
  • From: DrakoRod
• Re: DELETE Query Hang
  • From: Rob Sargent
• DELETE Query Hang
  • From: DrakoRod
• Re: here does postgres take its timezone information from?
  • From: Palle Girgensohn
• Re: security on user for replication
  • From: Christoph Moench-Tegeder
• Re: Rules documentation example
  • From: Tom Lane
• Rules documentation example
  • From: Paul A Jungwirth
• Re: security on user for replication
  • From: Andreas Kretschmer
• security on user for replication
  • From: PegoraroF10
• Partition, inheritance for storing syslog records.
  • From: Mimiko
• RE: Postgres Point in time Recovery (PITR),
  • From: Daulat Ram
• Re: announce: spark-postgres 3 released
  • From: Adrian Klaver
• Re: How to import Apache parquet files?
  • From: Nicolas Paris
• announce: spark-postgres 3 released
  • From: Nicolas Paris
• Re: type SERIAL in C host-struct
  • From: Matthias Apitz
• Re: type SERIAL in C host-struct
  • From: Peter J. Holzer
• Re: logical replication - negative bitmapset member not allowed
  • From: Jehan-Guillaume de Rorthais
• Re: logical replication - negative bitmapset member not allowed
  • From: Peter Eisentraut
• Re: Storing a time interval
  • From: Pankaj Jangid
• Merge sort/postgis performance tweaking?
  • From: Israel Brewster
• Re: Storing a time interval
  • From: Steve Baldwin
• Re: Storing a time interval
  • From: Michael Lewis
• Re: firewall trouble on Windows
  • From: Adrian Klaver
• firewall trouble on Windows
  • From: Boylan, Ross
• Re: Storing a time interval
  • From: stan
• Re: Storing a time interval
  • From: Adrian Klaver
• Re: Storing a time interval
  • From: Michael Lewis
• pg_logical for RHEL 8
  • From: Olivier Gautherot
• Storing a time interval
  • From: stan
• Re: AW: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Brad Nicholson
• AW: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Brad Nicholson
• AW: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Brad Nicholson
• AW: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: INOUT PARAMETERS WITH RETURN TABLES IN FUNCTION
  • From: Adrian Klaver
• Re: AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Brad Nicholson
• Re: SQL SERVER migration to PostgreSql
  • From: SERHAD ERDEM
• AW: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: INOUT PARAMETERS WITH RETURN TABLES IN FUNCTION
  • From: Thomas Kellerer
• INOUT PARAMETERS WITH RETURN TABLES IN FUNCTION
  • From: İlyas Derse
• AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: logging proxy
  • From: Bruce Momjian
• Re: type SERIAL in C host-struct
  • From: Matthias Apitz
• Re: AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Brad Nicholson
• Re: broken backup trail in case of quickly patroni switchback and forth
  • From: Laurenz Albe
• AW: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: 11 -> 12 upgrade on Debian Ubuntu
  • From: Peter J. Holzer
• Re: AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Adrian Klaver
• Re: 11 -> 12 upgrade on Debian Ubuntu
  • From: stan
• Re: 11 -> 12 upgrade on Debian Ubuntu
  • From: Alan Hodgson
• Re: 11 -> 12 upgrade on Debian Ubuntu
  • From: Adrian Klaver
• AW: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• 11 -> 12 upgrade on Debian Ubuntu
  • From: stan
• Re: AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Adrian Klaver
• AW: broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: logical replication - negative bitmapset member not allowed
  • From: Jehan-Guillaume de Rorthais
• Re: SQL SERVER migration to PostgreSql
  • From: Thomas Kellerer
• Re: broken backup trail in case of quickly patroni switchback and forth
  • From: Adrian Klaver
• Re: logical replication - negative bitmapset member not allowed
  • From: Peter Eisentraut
• Re: SQL SERVER migration to PostgreSql
  • From: Adrian Klaver
• Re: logical replication - negative bitmapset member not allowed
  • From: Peter Eisentraut
• SQL SERVER migration to PostgreSql
  • From: İlyas Derse
• broken backup trail in case of quickly patroni switchback and forth
  • From: Zwettler Markus (OIZ)
• Re: PostgreSQL && data types in ESQL/C
  • From: Merlin Moncure
• type SERIAL in C host-struct
  • From: Matthias Apitz
• Re: Hunspell as filtering dictionary
  • From: Bibi Mansione
• Re: Locked out of schema public (pg_dump lacks backup of the grant)
  • From: Peter
• Re: Locked out of schema public
  • From: Peter
• Re: Locked out of schema public (pg_dump lacks backup of the grant)
  • From: Tom Lane
• Re: Locked out of schema public (pg_dump lacks backup of the grant)
  • From: Peter
• How to convert return values from JSON Path functions to text
  • From: Thomas Kellerer
• Re: Locked out of schema public
  • From: Adrian Klaver
• Locked out of schema public
  • From: Peter
• Re: Upgrade PGSQL main version without backup/restore all databases?
  • From: Ravi Krishna
• Re: Hunspell as filtering dictionary
  • From: Hugh Ranalli
• Re: Upgrade PGSQL main version without backup/restore all databases?
  • From: Thomas Kellerer
• Upgrade PGSQL main version without backup/restore all databases?
  • From: Durumdara
• Re: Vacuum very big table - how the full vacuum works in background/internally?
  • From: Durumdara
• Re: PostgreSQL && data types in ESQL/C
  • From: Pavel Stehule
• PostgreSQL && data types in ESQL/C
  • From: Matthias Apitz
• Re: here does postgres take its timezone information from?
  • From: Thomas Munro
• Re: here does postgres take its timezone information from?
  • From: Tom Lane
• Re: here does postgres take its timezone information from?
  • From: Thomas Munro
• Re: here does postgres take its timezone information from?
  • From: Adrian Klaver
• Re: here does postgres take its timezone information from?
  • From: Chris Withers
• Re: here does postgres take its timezone information from?
  • From: Adrian Klaver
• Re: here does postgres take its timezone information from?
  • From: Adrian Klaver
• here does postgres take its timezone information from?
  • From: Chris Withers
• RE: Upgrade procedure
  • From: Kevin Brannen
• Re: select view definition from pg_views feature request
  • From: George Neuner
• Re: Upgrade procedure
  • From: rihad
• RE: Upgrade procedure
  • From: Rich Shepard
• RE: Upgrade procedure
  • From: Kevin Brannen
• Re: logical replication - negative bitmapset member not allowed
  • From: Andres Freund
• Re: How to import Apache parquet files?
  • From: Tomas Vondra
• Re: logical replication - negative bitmapset member not allowed
  • From: Jehan-Guillaume de Rorthais
• Re: select view definition from pg_views feature request
  • From: Tom Lane
• Re: How to import Apache parquet files?
  • From: Softwarelimits
• Re: How to import Apache parquet files?
  • From: Imre Samu
• Re: logical replication - negative bitmapset member not allowed
  • From: Peter Eisentraut
• Re: select view definition from pg_views feature request
  • From: Adrian Klaver
• How to import Apache parquet files?
  • From: Softwarelimits
• Re: select view definition from pg_views feature request
  • From: Michael Shapiro
• Hunspell as filtering dictionary
  • From: Bibi Mansione
• Re: Create a logical and physical replication
  • From: Andreas Joseph Krogh
• Re: Create a logical and physical replication
  • From: Deepak Pahuja .
• Re: Create a logical and physical replication
  • From: Ashok Kumar Tiwari
• Re: Create a logical and physical replication
  • From: Kyotaro Horiguchi
• Re: select view definition from pg_views feature request
  • From: David Rowley
• Re: select view definition from pg_views feature request
  • From: George Neuner
• Re: question about array indexing
  • From: Merlin Moncure
• question about array indexing
  • From: Szymon Lipiński
• Re: explain plan difference
  • From: Ravi Krishna
• Re: explain plan difference
  • From: Tom Lane
• Re: explain plan difference
  • From: Ravi Krishna
• Re: explain plan difference
  • From: Tom Lane
• Re: select view definition from pg_views feature request
  • From: Michael Shapiro
• Create a logical and physical replication
  • From: Ashok Kumar Tiwari
• Re: explain plan difference
  • From: Ravi Krishna
• Re: Are my autovacuum settings too aggressive for this table?
  • From: Laurenz Albe
• Re: explain plan difference
  • From: Steve Baldwin
• Re: explain plan difference
  • From: Tom Lane
• explain plan difference
  • From: Steve Baldwin
• Re: select view definition from pg_views feature request
  • From: Tom Lane
• select view definition from pg_views feature request
  • From: Michael Shapiro
• Re: Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block)
  • From: Francisco Olarte
• Re: Can you please suggest how to configure hot_standby_feedback?
  • From: Nikolay Samokhvalov
• Re: Can you please suggest how to configure hot_standby_feedback?
  • From: Konstantin Gredeskoul
• RE: Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block)
  • From: M Tarkeshwar Rao
• Re: QUERY: autovacuum: VACUUM ANALYZE table versus QUERY: autovacuum: VACUUM table
  • From: Tom Lane
• Re: QUERY: autovacuum: VACUUM ANALYZE table versus QUERY: autovacuum: VACUUM table
  • From: Adrian Klaver
• QUERY: autovacuum: VACUUM ANALYZE table versus QUERY: autovacuum: VACUUM table
  • From: Jason Ralph
• RE: Declarative Range Partitioning Postgres 11
  • From: Shatamjeev Dewan
• RE: Are my autovacuum settings too aggressive for this table?
  • From: Jason Ralph
• Re: Are my autovacuum settings too aggressive for this table?
  • From: Michael Lewis
• Re: Declarative Range Partitioning Postgres 11
  • From: Michael Lewis
• Are my autovacuum settings too aggressive for this table?
  • From: Jason Ralph
• Re: Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block)
  • From: Francisco Olarte
• RE: Declarative Range Partitioning Postgres 11
  • From: Shatamjeev Dewan
• Getting following error in using cursor to fetch the records from a large table in c language(current transaction is aborted, commands ignored until end of transaction block)
  • From: M Tarkeshwar Rao
• RE: Barman
  • From: Daulat Ram
• RE: Getting following error in using cursor to fetch the records from a large table in c language
  • From: M Tarkeshwar Rao
• logging proxy
  • From: Олег Самойлов
• Re: Getting following error in using cursor to fetch the records from a large table in c language
  • From: Laurenz Albe
• Re: Barman
  • From: Tomas Vondra
• Barman
  • From: Daulat Ram
• Re: Automatically parsing in-line composite types
  • From: Mitar
• Re: Automatically parsing in-line composite types
  • From: Tom Lane
• Re: Automatically parsing in-line composite types
  • From: Merlin Moncure
• Re: Can you please suggest how to configure hot_standby_feedback?
  • From: Andreas Kretschmer
• RE: Getting following error in using cursor to fetch the records from a large table in c language
  • From: M Tarkeshwar Rao
• Re: Getting following error in using cursor to fetch the records from a large table in c language
  • From: Laurenz Albe
• Re: Upgrade procedure
  • From: rihad
• Can you please suggest how to configure hot_standby_feedback?
  • From: M Tarkeshwar Rao
• RE: Getting following error in using cursor to fetch the records from a large table in c language
  • From: M Tarkeshwar Rao
• Re: Automatically parsing in-line composite types
  • From: Mitar
• RE: Upgrade procedure
  • From: Kevin Brannen
• Re: Automatically parsing in-line composite types
  • From: Andres Freund
• Re: Automatically parsing in-line composite types
  • From: Merlin Moncure
• Re: Getting following error in using cursor to fetch the records from a large table in c language
  • From: Laurenz Albe
• Re: Upgrade procedure
  • From: Francisco Olarte
• Getting following error in using cursor to fetch the records from a large table in c language
  • From: M Tarkeshwar Rao
• Upgrade procedure
  • From: rihad
• Re: Automatically parsing in-line composite types
  • From: Fabio Ugo Venchiarutti
• Re: Automatically parsing in-line composite types
  • From: Mitar
• Re: Automatically parsing in-line composite types
  • From: Merlin Moncure
• Re: Restore single table
  • From: Ritesh Jha
• Restore single table
  • From: Sonam Sharma
• Re: Automatically parsing in-line composite types
  • From: Mitar
• Re: Automatically parsing in-line composite types
  • From: Tom Lane
• Re: Automatically parsing in-line composite types
  • From: Mitar
• Re: Automatically parsing in-line composite types
  • From: Mitar
• Re: Automatically parsing in-line composite types
  • From: Fabio Ugo Venchiarutti
• Re: Automatically parsing in-line composite types
  • From: Dave Cramer
• Re: PostgreSQL - unrecognized win32 error code: 38
  • From: Thomas Munro
• Re: PostgreSQL - unrecognized win32 error code: 38
  • From: ZhenHua Cai
• Re: PostgreSQL - unrecognized win32 error code: 38
  • From: Michael Paquier
• Re: SQL pretty pritner?
  • From: Thiemo Kellner
• Re: SQL pretty pritner?
  • From: DiasCosta
• Re: PostgreSQL - unrecognized win32 error code: 38
  • From: ZhenHua Cai
• Re: SQL pretty pritner?
  • From: Reid Thompson
• RE: SQL pretty pritner?
  • From: Kevin Brannen
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Yessica Brinkmann
• Re: jsonb_set() strictness considered harmful to data
  • From: Mark Felder
• Re: SQL pretty pritner?
  • From: Basques, Bob (CI-StPaul)
• Re: SQL pretty pritner?
  • From: Basques, Bob (CI-StPaul)
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• Re: SQL pretty pritner?
  • From: Thomas Boussekey
• Re: SQL pretty pritner?
  • From: Rob Sargent
• Re: SQL pretty pritner?
  • From: Ron
• Re: SQL pretty pritner?
  • From: Rob Sargent
• Re: SQL pretty pritner?
  • From: Basques, Bob (CI-StPaul)
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Joe Conway
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Yessica Brinkmann
• Re: SQL pretty pritner?
  • From: Adrian Klaver
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Jony Cohen
• SQL pretty pritner?
  • From: stan
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Laurenz Albe
• Re: Installation problem.
  • From: Laurenz Albe
• Installation problem.
  • From: Lugano Abel
• Re: PostgreSQL - unrecognized win32 error code: 38
  • From: Tom Lane
• Re: PostgreSQL - unrecognized win32 error code: 38
  • From: Michael Paquier
• Re: Updating data: confirmation and question
  • From: Rich Shepard
• Re: Updating data: confirmation and question
  • From: Adrian Klaver
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Yessica Brinkmann
• Re: Updating data: confirmation and question
  • From: Rich Shepard
• Re: Updating data: confirmation and question
  • From: Adrian Klaver
• Re: PostgreSQL - unrecognized win32 error code: 38
  • From: Adrian Klaver
• PostgreSQL - unrecognized win32 error code: 38
  • From: ZhenHua Cai
• Re: Updating data: confirmation and question
  • From: Rich Shepard
• Re: Updating data: confirmation and question
  • From: Adrian Klaver
• Updating data: confirmation and question
  • From: Rich Shepard
• Re: Composite type storage overhead
  • From: George Neuner
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Yessica Brinkmann
• Re: Trying to fetch records only if preceded by at least another one
  • From: Michael Lewis
• Re: Trying to fetch records only if preceded by at least another one
  • From: Alexander Farber
• Re: Composite type storage overhead
  • From: Michael Lewis
• Re: Quere keep using temporary files
  • From: Tom Lane
• Re: Trying to fetch records only if preceded by at least another one
  • From: Michael Lewis
• Re: Quere keep using temporary files
  • From: rihad
• Re: logical replication - negative bitmapset member not allowed
  • From: Jehan-Guillaume de Rorthais
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Yessica Brinkmann
• Trying to fetch records only if preceded by at least another one
  • From: Alexander Farber
• Re: I think that my data is saved correctly, but when printing again, other data appears
  • From: Tom Lane
• Re: Error building Postgres for Windows
  • From: Tom Lane
• Re: Quere keep using temporary files
  • From: Tom Lane
• I think that my data is saved correctly, but when printing again, other data appears
  • From: Yessica Brinkmann
• Re: Index
  • From: Ravi Krishna
• Re: Index
  • From: Luca Ferrari
• Re: Quere keep using temporary files
  • From: Luca Ferrari
• Error building Postgres for Windows
  • From: Stephan Sandow
• Quere keep using temporary files
  • From: rihad
• Re: Search path
  • From: Thomas Kellerer
• Index
  • From: Sonam Sharma
• Re: Is this a bug ?
  • From: George Neuner
• Re: jsonb_set() strictness considered harmful to data
  • From: Stuart McGraw
• Re: EXPLAIN BUFFERS and I/O timing accounting questions
  • From: Andres Freund
• Re: EXPLAIN BUFFERS and I/O timing accounting questions
  • From: Maciek Sakrejda
• Re: A very puzzling backup/restore problem
  • From: Tom Lane
• Re: A very puzzling backup/restore problem
  • From: Adrian Klaver
• Re: A very puzzling backup/restore problem
  • From: stan
• Re: EXPLAIN BUFFERS and I/O timing accounting questions
  • From: Andres Freund
• Re: jsonb_set() strictness considered harmful to data
  • From: Tom Lane
• Re: SQL Error [0A000]: ERROR: nondeterministic collations are not supported for LIKE
  • From: Jeff Lanzarotta
• Re: SQL Error [0A000]: ERROR: nondeterministic collations are not supported for LIKE
  • From: Daniel Verite
• Re: jsonb_set() strictness considered harmful to data
  • From: Laurenz Albe
• Re: Recover databases from raw files (only exists the base directory)
  • From: Laurenz Albe
• Re: Lookup Primary Key of Foreign Server's Table
  • From: Chris Morris
• Recover databases from raw files (only exists the base directory)
  • From: Carlos Martinez
• Re: Search path
  • From: Adrian Klaver
• Search path
  • From: stan
• Re: Having more than one constraint trigger on a table
  • From: Andreas Joseph Krogh
• SQL Error [0A000]: ERROR: nondeterministic collations are not supported for LIKE
  • From: Jeff Lanzarotta
• Re: Having more than one constraint trigger on a table
  • From: Adrian Klaver
• Re: LocalTransactionId vs txid_current
  • From: Tom Lane
• Re: A very puzzling backup/restore problem
  • From: Adrian Klaver
• Re: A very puzzling backup/restore problem
  • From: stan
• Re: PGPool version 4.0.6-1
  • From: Adrian Klaver
• Re: A very puzzling backup/restore problem
  • From: Adrian Klaver
• Re: A very puzzling backup/restore problem
  • From: stan
• LocalTransactionId vs txid_current
  • From: Luca Ferrari
• PGPool version 4.0.6-1
  • From: Vikas Sharma
• A very puzzling backup/restore problem
  • From: stan
• Re: Composite type storage overhead
  • From: Laiszner Tamás
• Failed to increase the restart LSN of PostgreSQL logical replication slot
  • From: Rashmi V Bharadwaj
• Re: Composite type storage overhead
  • From: Thomas Kellerer
• Re: jsonb_set() strictness considered harmful to data
  • From: Maurice Aubrey
• Re: jsonb_set() strictness considered harmful to data
  • From: rob stone
• Re: jsonb_set() strictness considered harmful to data
  • From: Maciek Sakrejda
• Re: Composite type storage overhead
  • From: Laiszner Tamás
• Re: Composite type storage overhead
  • From: Rob Sargent
• Re: Composite type storage overhead
  • From: Rob Sargent
• Composite type storage overhead
  • From: Laiszner Tamás
• Re: Is this a bug ?
  • From: Ravi Krishna
• Re: Automatically parsing in-line composite types
  • From: Mitar
• Re: Is this a bug ?
  • From: Gaetano Mendola
• Re: Is this a bug ?
  • From: Gaetano Mendola
• Re: Is this a bug ?
  • From: Peter J. Holzer
• Re: jsonb_set() strictness considered harmful to data
  • From: Stuart McGraw
• Re: Is this a bug ?
  • From: Ron
• Re: jsonb_set() strictness considered harmful to data
  • From: Peter J. Holzer
• Re: Is this a bug ?
  • From: Fabio Ugo Venchiarutti
• Re: Is this a bug ?
  • From: Adrian Klaver
• Re: date function bug
  • From: Adrian Klaver
• Re: Is this a bug ?
  • From: Ron
• Re: Is this a bug ?
  • From: Geoff Winkless
• Re: Is this a bug ?
  • From: Ron
• Re: Is this a bug ?
  • From: Geoff Winkless
• Re: EXPLAIN BUFFERS and I/O timing accounting questions
  • From: Maciek Sakrejda
• Re: Lookup Primary Key of Foreign Server's Table
  • From: David G. Johnston
• Re: Is this a bug ?
  • From: Ron
• Re: Is this a bug ?
  • From: Ron
• Re: jsonb_set() strictness considered harmful to data
  • From: David G. Johnston
• Re: Is this a bug ?
  • From: Geoff Winkless
• Re: Is this a bug ?
  • From: John W Higgins
• Re: Is this a bug ?
  • From: Fabio Ugo Venchiarutti
• Re: Is this a bug ?
  • From: Tom Lane
• Re: Is this a bug ?
  • From: Ravi Krishna
• Re: Is this a bug ?
  • From: Ron
• Re: Is this a bug ?
  • From: Geoff Winkless
• Re: Is this a bug ?
  • From: Gianni Ceccarelli
• Re: Lookup Primary Key of Foreign Server's Table
  • From: Chris Morris
• Re: Is this a bug ?
  • From: Ron
• Is this a bug ?
  • From: Ravi Krishna
• Re: Calling jsonb_array_elements 4 times in the same query
  • From: Alexander Farber
• Re: date function bug
  • From: Ravi Krishna
• Re: date function bug
  • From: Adrian Klaver
• Re: date function bug
  • From: Tom Lane
• RE: date function bug
  • From: Kevin Brannen
• Re: date function bug
  • From: Ron
• RE: Re: date function bug
  • From: Abraham, Danny
• Re: date function bug
  • From: Ravi Krishna
• Re: date function bug
  • From: Ron
• Re: date function bug
  • From: Ravi Krishna
• date function bug
  • From: Abraham, Danny
• Re: jsonb_set() strictness considered harmful to data
  • From: Laurenz Albe
• Re: jsonb_set() strictness considered harmful to data
  • From: David G. Johnston
• Re: jsonb_set() strictness considered harmful to data
  • From: Peter J. Holzer
• Re: jsonb_set() strictness considered harmful to data
  • From: Peter J. Holzer
• Re: jsonb_set() strictness considered harmful to data
  • From: Peter J. Holzer
• Re: Upgrade mode will prevent the installer .... (pgAgent)
  • From: Kris Deugau
• Upgrade mode will prevent the installer .... (pgAgent)
  • From: Boylan, Ross
• Re: A question about sequences and backup/restore cycles
  • From: Stan Brown
• Re: Primary key definition?
  • From: Michael Lewis
• SQL Error [0A000]: ERROR: nondeterministic collations are not supported for LIKE
  • From: Jeff Lanzarotta
• Re: A question about sequences and backup/restore cycles
  • From: Adrian Klaver
• Re: A question about sequences and backup/restore cycles
  • From: stan
• Re: Primary key definition?
  • From: Ron
• Re: Primary key definition?
  • From: Adrian Klaver
• Re: A question about sequences and backup/restore cycles
  • From: Adrian Klaver
• Primary key definition?
  • From: stan
• Re: Recovering disk space
  • From: Jeff Janes
• Re: Regarding db dump with Fc taking very long time to completion
  • From: Jeff Janes
• Re: An issue installing an extension
  • From: Tom Lane
• An issue installing an extension
  • From: stan
• Re: Lookup Primary Key of Foreign Server's Table
  • From: David G. Johnston
• Lookup Primary Key of Foreign Server's Table
  • From: Chris Morris
• Re: existing dblinks
  • From: Adrian Klaver
• Re: Having more than one constraint trigger on a table
  • From: Andreas Joseph Krogh
• Re: Having more than one constraint trigger on a table
  • From: Adrian Klaver
• Having more than one constraint trigger on a table
  • From: Andreas Joseph Krogh
• Re: FW: Re: A question about building pg-libphonenumber
  • From: Josef Šimánek
• FW: Re: A question about building pg-libphonenumber
  • From: stan
• Re: A question about building pg-libphonenumber
  • From: Pavel Stehule
• Re: pg_hba & ldap
  • From: Stephen Frost
• Re: A question about building pg-libphonenumber
  • From: stan
• Re: A question about building pg-libphonenumber
  • From: Pavel Stehule
• A question about building pg-libphonenumber
  • From: stan
• pg_hba & ldap
  • From: Diego
• A question about sequnces and pg_restore
  • From: stan
• Re: Too many SET TimeZone and Application_name queries
  • From: Amarendra Konda
• EXPLAIN BUFFERS and I/O timing accounting questions
  • From: Maciek Sakrejda
• Re: A question about sequences and backup/restore cycles
  • From: Adrian Klaver
• A question about sequences and backup/restore cycles
  • From: stan
• existing dblinks
  • From: Julie Nishimura
• Re: jsonb_set() strictness considered harmful to data
  • From: raf
• Re: Calling jsonb_array_elements 4 times in the same query
  • From: Adrian Klaver
• Re: jsonb_set() strictness considered harmful to data
  • From: Adrian Klaver
• Re: Calling jsonb_array_elements 4 times in the same query
  • From: Alexander Farber
• Re: jsonb_set() strictness considered harmful to data
  • From: Tomas Vondra
• Re: jsonb_set() strictness considered harmful to data
  • From: Steve Atkins
• Re: CPU SPIKE
  • From: Francisco Olarte
• Re: jsonb_set() strictness considered harmful to data
  • From: Steven Pousty
• Re: jsonb_set() strictness considered harmful to data
  • From: David G. Johnston
• Re: Postgres Point in time Recovery (PITR),
  • From: Horacio Miranda
• Re: Postgres Point in time Recovery (PITR),
  • From: Avinash Kumar
• Re: Postgres Point in time Recovery (PITR),
  • From: Alan Hodgson
• Re: Postgres Point in time Recovery (PITR),
  • From: Adrian Klaver
• Re: Postgres Point in time Recovery (PITR),
  • From: Avinash Kumar
• Re: jsonb_set() strictness considered harmful to data
  • From: Adrian Klaver
• Re: Postgres Point in time Recovery (PITR),
  • From: Alan Hodgson
• Re: Calling jsonb_array_elements 4 times in the same query
  • From: Thomas Kellerer
• Re: Calling jsonb_array_elements 4 times in the same query
  • From: Adrian Klaver
• Re: Calling jsonb_array_elements 4 times in the same query
  • From: Alexander Farber
• Re: Calling jsonb_array_elements 4 times in the same query
  • From: Thomas Kellerer
• Calling jsonb_array_elements 4 times in the same query
  • From: Alexander Farber
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• Re: Postgres Point in time Recovery (PITR),
  • From: Fabio Ugo Venchiarutti
• Re: Postgres Point in time Recovery (PITR),
  • From: Avinash Kumar
• Re: Postgres Point in time Recovery (PITR),
  • From: Fabio Ugo Venchiarutti
• Re: Postgres Point in time Recovery (PITR),
  • From: Luca Ferrari
• Re: jsonb_set() strictness considered harmful to data
  • From: Tomas Vondra
• Re: CPU SPIKE
  • From: Tomas Vondra
• Re: CPU SPIKE
  • From: Pavel Stehule
• CPU SPIKE
  • From: Pawan Sharma
• Re: jsonb_set() strictness considered harmful to data
  • From: Abelard Hoffman
• Re: jsonb_set() strictness considered harmful to data
  • From: rob stone
• Re: jsonb_set() strictness considered harmful to data
  • From: raf
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• Re: jsonb_set() strictness considered harmful to data
  • From: Paul A Jungwirth
• Re: jsonb_set() strictness considered harmful to data
  • From: Laurenz Albe
• Re: jsonb_set() strictness considered harmful to data
  • From: Steven Pousty
• Re: jsonb_set() strictness considered harmful to data
  • From: Tomas Vondra
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• Re: Too many SET TimeZone and Application_name queries
  • From: Jeff Janes
• Re: jsonb_set() strictness considered harmful to data
  • From: David G. Johnston
• Re: UTC-6 or UTC+6?
  • From: Tom Lane
• Re: jsonb_set() strictness considered harmful to data
  • From: Isaac Morland
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• UTC-6 or UTC+6?
  • From: Luca Ferrari
• Re: jsonb_set() strictness considered harmful to data
  • From: Steve Atkins
• jsonb_set() strictness considered harmful to data
  • From: Floris Van Nee
• Re: releasing space
  • From: Adrian Klaver
• Re: releasing space
  • From: Tomas Vondra
• Re: releasing space
  • From: Adrian Klaver
• Re: releasing space
  • From: Julie Nishimura
• Re: Execute a function through fdw
  • From: Jeff Janes
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: Tomas Vondra
• Re: Postgres Point in time Recovery (PITR),
  • From: Avinash Kumar
• Re: Postgres Point in time Recovery (PITR),
  • From: Jeff Janes
• Re: jsonb_set() strictness considered harmful to data
  • From: Adrian Klaver
• RE: Postgres Point in time Recovery (PITR),
  • From: Daulat Ram
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• Re: jsonb_set() strictness considered harmful to data
  • From: David G. Johnston
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• Re: jsonb_set() strictness considered harmful to data
  • From: Tomas Vondra
• Re: jsonb_set() strictness considered harmful to data
  • From: Tomas Vondra
• Re: jsonb_set() strictness considered harmful to data
  • From: Andrew Dunstan
• Re: jsonb_set() strictness considered harmful to data
  • From: Stephen Frost
• Re: jsonb_set() strictness considered harmful to data
  • From: Christoph Moench-Tegeder
• Re: jsonb_set() strictness considered harmful to data
  • From: Dmitry Dolgov
• Re: Has there been any discussion of custom dictionaries being defined in the database?
  • From: Tomas Vondra
• Re: releasing space
  • From: Tomas Vondra
• Re: Replication of Replication
  • From: Tomas Vondra
• Re: Securing records using linux grou permissions
  • From: Peter J. Holzer
• Re: jsonb_set() strictness considered harmful to data
  • From: Tomas Vondra
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: Pavel Stehule
• Re: jsonb_set() strictness considered harmful to data
  • From: David G. Johnston
• Re: jsonb_set() strictness considered harmful to data
  • From: Pavel Stehule
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: Adrian Klaver
• Re: jsonb_set() strictness considered harmful to data
  • From: Stephen Frost
• Re: jsonb_set() strictness considered harmful to data
  • From: Stephen Frost
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: Adrian Klaver
• Re: jsonb_set() strictness considered harmful to data
  • From: Christoph Moench-Tegeder
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• Re: jsonb_set() strictness considered harmful to data
  • From: David G. Johnston
• Replication of Replication
  • From: Edilmar Alves
• Re: jsonb_set() strictness considered harmful to data
  • From: Christoph Moench-Tegeder
• Re: jsonb_set() strictness considered harmful to data
  • From: Mark Felder
• jsonb_set() strictness considered harmful to data
  • From: Ariadne Conill
• RE: Execute a function through fdw
  • From: Patrick FICHE
• Re: Execute a function through fdw
  • From: Guillaume Lelarge
• RE: Execute a function through fdw
  • From: Patrick FICHE
• Re: DBD::Pg exorts char columns with trailing blanks
  • From: Rob Sargent
• Re: DBD::Pg exorts char columns with trailing blanks
  • From: Adrian Klaver
• Re: DBD::Pg exorts char columns with trailing blanks
  • From: Rob Sargent
• Re: DBD::Pg exorts char columns with trailing blanks
  • From: Adrian Klaver
• Re: DBD::Pg exorts char columns with trailing blanks
  • From: Matthias Apitz
• Re: connection timeout with psycopg2
  • From: Adrian Klaver
• RE: CVE-2018-1058
  • From: Lizeth Solis Aramayo
• Re: DBD::Pg exorts char columns with trailing blanks
  • From: Tom Lane
• Visibility Map Issues
  • From: Jeremy Smith
• RE: Execute a function through fdw
  • From: Patrick FICHE
• DBD::Pg exorts char columns with trailing blanks
  • From: Matthias Apitz
• Re: Postgres Point in time Recovery (PITR),
  • From: Avinash Kumar
• Re: Execute a function through fdw
  • From: Tom Lane
• Re: Create role like role
  • From: Ron
• Re: Postgres Point in time Recovery (PITR),
  • From: David Steele
• Re: stable for each row before insert trigger
  • From: Luca Ferrari
• Re: Execute a function through fdw
  • From: Guillaume Lelarge
• Create role like role
  • From: Sonam Sharma
• Execute a function through fdw
  • From: Patrick FICHE
• Re: Postgres Point in time Recovery (PITR),
  • From: Luca Ferrari
• Re: stable for each row before insert trigger
  • From: Олег Самойлов
• Re: Sv: Conflict between autovacuum and backup restoration
  • From: Ekaterina Amez
• Re: Postgres Point in time Recovery (PITR),
  • From: Andreas Kretschmer
• Sv: Postgres Point in time Recovery (PITR),
  • From: Andreas Joseph Krogh
• Re: Postgres Point in time Recovery (PITR),
  • From: Emanuele Musella
• Re: Postgres Point in time Recovery (PITR),
  • From: Luca Ferrari
• Re: stable for each row before insert trigger
  • From: Luca Ferrari
• Re: stable for each row before insert trigger
  • From: Tom Lane
• Re: A little confusion about JSON Path
  • From: Thomas Kellerer
• Re: stable for each row before insert trigger
  • From: Олег Самойлов
• Postgres Point in time Recovery (PITR),
  • From: Daulat Ram
• Can you please tell us how set this prefetch attribute in following lines.
  • From: M Tarkeshwar Rao
• Re:Using PostgreSQL for Machine Learning Data Pipelines
  • From: chris
• Re: drop database
  • From: Ron
• Re: stable for each row before insert trigger
  • From: Adrian Klaver
• stable for each row before insert trigger
  • From: Олег Самойлов
• Re: drop database
  • From: pabloa98
• Re: drop database
  • From: Andrew Kerber
• Re: drop database
  • From: Michael Lewis
• Re: drop database
  • From: Julie Nishimura
• Re: drop database
  • From: Julie Nishimura
• Re: Sv: drop database
  • From: Ron
• Sv: drop database
  • From: Andreas Joseph Krogh
• Re: drop database
  • From: Ron
• Sv: drop database
  • From: Andreas Joseph Krogh
• drop database
  • From: Julie Nishimura
• Re: Changing PK on replicated database
  • From: PegoraroF10
• Re: releasing space
  • From: Adrian Klaver
• Re: Vacuum very big table - how the full vacuum works in background/internally?
  • From: Michael Lewis
• Using PostgreSQL for Machine Learning Data Pipelines
  • From: Pankaj Jangid
• releasing space
  • From: Julie Nishimura
• Re: Can you please tell us how set this prefetch attribute in following lines.
  • From: Laurenz Albe
• Re: Can you please tell us how set this prefetch attribute in following lines.
  • From: Reid Thompson
• Re: Vacuum very big table - how the full vacuum works in background/internally?
  • From: Luca Ferrari
• Vacuum very big table - how the full vacuum works in background/internally?
  • From: Durumdara
• Re: Changing PK on replicated database
  • From: Adrian Klaver
• RE: CVE-2018-1058
  • From: Lizeth Solis Aramayo
• Re: CVE-2018-1058
  • From: Adrian Klaver
• Sv: Conflict between autovacuum and backup restoration
  • From: Andreas Joseph Krogh
• Conflict between autovacuum and backup restoration
  • From: Ekaterina Amez
• Re: Can functions containing a CTE be PARALLEL SAFE?
  • From: Erwin Brandstetter
• Re: PostgreSQL memory usage
  • From: Tom Lane
• RE: PostgreSQL memory usage
  • From: Alexander Pyhalov
• Re: A little confusion about JSON Path
  • From: Laurenz Albe
• Re: PostgreSQL memory usage
  • From: Laurenz Albe
• Re: pgbackrest with PAF(corosync and pacmaker)
  • From: David Steele
• Re: Has there been any discussion of custom dictionaries being defined in the database?
  • From: Karsten Hilbert
• Re: Changing PK on replicated database
  • From: PegoraroF10
• Re: Has there been any discussion of custom dictionaries being defined in the database?
  • From: Morris de Oryx
• pgbackrest with PAF(corosync and pacmaker)
  • From: Ajay Pratap
• Re: Pgbackrest backup is too slow
  • From: Ajay Pratap
• Re: Has there been any discussion of custom dictionaries being defined in the database?
  • From: Tom Lane
• Re: Has there been any discussion of custom dictionaries being defined in the database?
  • From: Morris de Oryx
• Re: Can functions containing a CTE be PARALLEL SAFE?
  • From: Tom Lane
• Re: Has there been any discussion of custom dictionaries being defined in the database?
  • From: Tom Lane
• Has there been any discussion of custom dictionaries being defined in the database?
  • From: Morris de Oryx
• Re: PostgreSQL memory usage
  • From: Luca Ferrari
• Can functions containing a CTE be PARALLEL SAFE?
  • From: Erwin Brandstetter
• Re: CVE-2018-1058
  • From: Adrian Klaver
• Re: Changing PK on replicated database
  • From: Adrian Klaver
• Re: CVE-2018-1058
  • From: Adrian Klaver
• Re: CVE-2018-1058
  • From: Adrian Klaver
• Re: CVE-2018-1058
  • From: Adrian Klaver
• RE: CVE-2018-1058
  • From: Lizeth Solis Aramayo
• Re: CVE-2018-1058
  • From: Neil
• Changing PK on replicated database
  • From: PegoraroF10
• Re: CVE-2018-1058
  • From: Ron
• Re: CVE-2018-1058
  • From: Rob Sargent
• Re: CVE-2018-1058
  • From: Adrian Klaver
• CVE-2018-1058
  • From: Lizeth Solis Aramayo
• Text search lexer's handling of hyphens and negatives
  • From: Raymond Lu
• RE: Postgres 10.7 Systemd Startup Issue
  • From: Lu, Dan
• RE: Postgres 10.7 Systemd Startup Issue
  • From: Lu, Dan
• Re: Postgres 9.6 active-passive HA cluster
  • From: Michael Lewis
• PostgreSQL memory usage
  • From: Alexander Pyhalov
• Re: Text search lexer's handling of hyphens and negatives
  • From: Alan Hodgson
• Re: Analyze and vaccum
  • From: Adrian Klaver
• Analyze and vaccum
  • From: Sonam Sharma
• Re: Regarding db dump with Fc taking very long time to completion
  • From: Imre Samu
• A little confusion about JSON Path
  • From: Thomas Kellerer
• Re: Text search lexer's handling of hyphens and negatives
  • From: Daniel Verite
• Re: Is there any configuration in postgresql.conf or any other configuration of postgres which will make this possible to listen on particular interface
  • From: Francisco Olarte
• Postgres 9.6 active-passive HA cluster
  • From: Jairam Gauns
• Is there any configuration in postgresql.conf or any other configuration of postgres which will make this possible to listen on particular interface
  • From: M Tarkeshwar Rao
• Re: Regarding db dump with Fc taking very long time to completion
  • From: Durgamahesh Manne
• Re: Regarding db dump with Fc taking very long time to completion
  • From: Durgamahesh Manne
• Re: Regarding db dump with Fc taking very long time to completion
  • From: Luca Ferrari
• connection timeout with psycopg2
  • From: Vicente Juan Tomas Monserrat
• Re: Regarding db dump with Fc taking very long time to completion
  • From: Durgamahesh Manne
• Re: Securing records using linux grou permissions
  • From: Luca Ferrari
• Re: Text search lexer's handling of hyphens and negatives
  • From: raylu
• Re: Text search lexer's handling of hyphens and negatives
  • From: Alan Hodgson
• Text search lexer's handling of hyphens and negatives
  • From: raylu
• Re: Securing records using linux grou permissions
  • From: Ron
• Re: Securing records using linux grou permissions
  • From: David Gauthier
• Re: Securing records using linux grou permissions
  • From: Michael Lewis
• Securing records using linux grou permissions
  • From: David Gauthier
• Re: SELECT returnig a constant
  • From: Michael Lewis
• Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound
  • From: Moreno Andreo
• Re: Inserting multiple rows wtih a SELECt in the values clause
  • From: Andrew Gierth
• Re: SELECT returnig a constant
  • From: Geoff Winkless
• Inserting multiple rows wtih a SELECt in the values clause
  • From: stan
• Re: timescaleDB & WAL replication
  • From: Tomas Vondra
• SOLVED Re: SELECT returnig a constant
  • From: stan
• SELECT returnig a constant
  • From: stan
• Re: How to make runtime partition pruning work?
  • From: Markus Heiden
• timescaleDB & WAL replication
  • From: basti
• Re: How to make runtime partition pruning work?
  • From: David Rowley
• Re: Too many SET TimeZone and Application_name queries
  • From: Adrian Klaver
• Re: Postgres 10.7 Systemd Startup Issue
  • From: Tom Lane
• Re: Too many SET TimeZone and Application_name queries
  • From: Amarendra Konda
• Re: day interval
  • From: Adrian Klaver
• RE: Re: day interval
  • From: Abraham, Danny
• Re: day interval
  • From: Tom Lane
• Re: SELECT d02name::bytea FROM ... && DBI::Pg
  • From: Andrew Gierth
• Re: day interval
  • From: Andrew Gierth
• Re: day interval
  • From: Adrian Klaver
• RE: Re: day interval
  • From: Abraham, Danny
• Re: day interval
  • From: Andrew Gierth
• RE: Re: day interval
  • From: Abraham, Danny
• Re: day interval
  • From: Adrian Klaver
• Re: day interval
  • From: Ron
• RE: Re: day interval
  • From: Abraham, Danny
• Re: day interval
  • From: Andrew Gierth
• day interval
  • From: Abraham, Danny
• Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server
  • From: Daniel Verite
• Re: SELECT d02name::bytea FROM ... && DBI::Pg
  • From: Christoph Moench-Tegeder
• Re: Case Insensitive Comparison with Postgres 12
  • From: Daniel Verite
• Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server
  • From: Christoph Moench-Tegeder
• Re: Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• Re: SELECT d02name::bytea FROM ... && DBI::Pg
  • From: Francisco Olarte
• Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
  • From: Adrian Klaver
• Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
  • From: wambacher
• Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
  • From: Adrian Klaver
• Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
  • From: wambacher
• Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
  • From: Adrian Klaver
• Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
  • From: Adrian Klaver
• got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated
  • From: wambacher
• Re: how can I get non-truncated version of running sql?
  • From: Adrian Klaver
• how can I get non-truncated version of running sql?
  • From: Julie Nishimura
• Profile a db connection time?
  • From: Vijaykumar Jain
• Re: Case Insensitive Comparison with Postgres 12
  • From: Igal Sapir
• Re: Pgbackrest backup is too slow
  • From: Ajay Pratap
• Re: JSON vs. JSONB storage size
  • From: Andrew Gierth
• Re: JSON vs. JSONB storage size
  • From: Adrian Klaver
• Re: JSON vs. JSONB storage size
  • From: Dmitry Dolgov
• Re: Issues with PAM : log that it failed, whether it actually failed or not
  • From: Tom Lane
• Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server
  • From: Matthias Apitz
• Re: Too many SET TimeZone and Application_name queries
  • From: Adrian Klaver
• Re: Pgbackrest backup is too slow
  • From: Brad Nicholson
• Re: Pgbackrest backup is too slow
  • From: Stephen Frost
• Re: Trigger
  • From: Charles Clavadetscher
• Too many SET TimeZone and Application_name queries
  • From: Amarendra Konda
• JSON vs. JSONB storage size
  • From: Thomas Kellerer
• Trigger
  • From: Sonam Sharma
• Pgbackrest backup is too slow
  • From: Ajay Pratap
• How to make runtime partition pruning work?
  • From: Markus Heiden
• Issues with PAM : log that it failed, whether it actually failed or not
  • From: La Cancellera Yoann
• Re: DDL support for logical replication
  • From: Jeremy Finzel
• Re: DDL support for logical replication
  • From: Cory Nemelka
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Achilleas Mantzios
• Re: Segmentation fault with PG-12
  • From: Andres Freund
• Re: DDL support for logical replication
  • From: Lev Kokotov
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Yessica Brinkmann
• Re: DDL support for logical replication
  • From: Miles Elam
• Re: plpgsql copy import csv double quotes
  • From: pascal.crozet
• Re: Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Yessica Brinkmann
• Re: Segmentation fault with PG-12
  • From: Tom Lane
• Re: plpgsql copy import csv double quotes
  • From: Adrian Klaver
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Yessica Brinkmann
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Jaime Soler
• DDL support for logical replication
  • From: Lev Kokotov
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Yessica Brinkmann
• Re: SELECT d02name::bytea FROM ... && DBI::Pg
  • From: Matthias Apitz
• Re: SELECT d02name::bytea FROM ... && DBI::Pg
  • From: Francisco Olarte
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Yessica Brinkmann
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Yessica Brinkmann
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Alban Hertroys
• Re: The connection to the server was lost. Attempting reset: Failed.
  • From: Tom Lane
• The connection to the server was lost. Attempting reset: Failed.
  • From: Yessica Brinkmann
• Re: Case Insensitive Comparison with Postgres 12
  • From: Igal @ Lucee.org
• RE: plpgsql copy import csv double quotes
  • From: PASCAL CROZET
• Re: Minimum privilege for Backup and replication
  • From: Stephen Frost
• Re: Event Triggers and GRANT/REVOKE
  • From: Adrian Klaver
• Re: SOLVED Re: Recovering disk space
  • From: Melvin Davidson
• Re: psql \copy hanging
  • From: Adrian Klaver
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Stephen Frost
• websearch_to_tsquery() and handling of ampersand characters inside double quotes
  • From: Alastair McKinley
• Re: websearch_to_tsquery() and apostrophe inside double quotes
  • From: Alastair McKinley
• Re: syntax error with v12
  • From: Adrian Klaver
• Re: syntax error with v12
  • From: Ivan Kabaivanov
• Re: websearch_to_tsquery() and apostrophe inside double quotes
  • From: Tom Lane
• Re: Case Insensitive Comparison with Postgres 12
  • From: Thomas Kellerer
• Re: logical replication - negative bitmapset member not allowed
  • From: Jehan-Guillaume de Rorthais
• Re: syntax error with v12
  • From: Félix GERZAGUET
• Re: syntax error with v12
  • From: Josef Šimánek
• syntax error with v12
  • From: Ivan Kabaivanov
• Re: Case Insensitive Comparison with Postgres 12
  • From: Igal @ Lucee.org
• Re: Minimum privilege for Backup and replication
  • From: Luca Ferrari
• websearch_to_tsquery() and apostrophe inside double quotes
  • From: Alastair McKinley
• Minimum privilege for Backup and replication
  • From: Timmy Siu
• SELECT d02name::bytea FROM ... && DBI::Pg
  • From: Matthias Apitz
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Simon Riggs
• Re: Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Geoff Winkless
• Re: Version 10.7 of postgres
  • From: Magnus Hagander
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Wim Bertels
• SOLVED Re: Recovering disk space
  • From: stan
• Recovering disk space
  • From: stan
• Re: Segmentation fault with PG-12
  • From: Andres Freund
• Re: Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• Re: psql \copy hanging
  • From: Arnaud L.
• Re: Version 10.7 of postgres
  • From: Michael Paquier
• Re: Segmentation fault with PG-12
  • From: Andres Freund
• Version 10.7 of postgres
  • From: Shankar Bhaskaran
• Re: pgutils, pglogger and pgutilsL out
  • From: Adrian Klaver
• pgutils, pglogger and pgutilsL out
  • From: Thiemo Kellner
• Re: plpgsql copy import csv double quotes
  • From: Tom Lane
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Pól Ua Laoínecháin
• Re: Event Triggers and GRANT/REVOKE
  • From: Miles Elam
• Re: Event Triggers and GRANT/REVOKE
  • From: Adrian Klaver
• Re: plpgsql copy import csv double quotes
  • From: Adrian Klaver
• plpgsql copy import csv double quotes
  • From: PASCAL CROZET
• Event Triggers and GRANT/REVOKE
  • From: Miles Elam
• Re: Allowing client access
  • From: Adrian Klaver
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Tim Clarke
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Alan Hodgson
• Re: Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Stephen Frost
• Re: I messed up and my disk utlization is HUGE
  • From: stan
• Is my lecturer wrong about PostgreSQL? I think he is!
  • From: Pól Ua Laoínecháin
• Re: Allowing client access
  • From: Timmy Siu
• Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound
  • From: Alvaro Herrera
• I messed up and my disk utlization is HUGE
  • From: stan
• Repmgr and pglogical
  • From: Sonam Sharma
• Re: Segmentation fault with PG-12
  • From: Tom Lane
• Re: Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• Re: Segmentation fault with PG-12
  • From: Tom Lane
• Re: GSSAPI: logging principal
  • From: Stephen Frost
• Re: Allowing client access
  • From: Bob Jolliffe
• Allowing client access
  • From: Timmy Siu
• Re: Event Triggers and Dropping Objects
  • From: Luca Ferrari
• Re: Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• GSSAPI: logging principal
  • From: Allan Jensen
• Re: Case Insensitive Comparison with Postgres 12
  • From: Pavel Křehula
• Re: Case Insensitive Comparison with Postgres 12
  • From: Laurenz Albe
• Re: Case Insensitive Comparison with Postgres 12
  • From: Wim Bertels
• Transition tables for column-specific UPDATE triggers
  • From: Guy Burgess
• Re: Case Insensitive Comparison with Postgres 12
  • From: Morris de Oryx
• Case Insensitive Comparison with Postgres 12
  • From: Igal Sapir
• Re: Declarative Range Partitioning Postgres 11
  • From: Ron
• RE: Declarative Range Partitioning Postgres 11
  • From: Shatamjeev Dewan
• Re: Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• Re: Declarative Range Partitioning Postgres 11
  • From: Michael Lewis
• Re: Declarative Range Partitioning Postgres 11
  • From: Michael Lewis
• Re: temporary files
  • From: dangal
• Re: Segmentation fault with PG-12
  • From: Tom Lane
• Segmentation fault with PG-12
  • From: Andreas Joseph Krogh
• Re: Table locking during backup
  • From: Tom Lane
• Re: psql \copy hanging
  • From: Arnaud L.
• Re: psql \copy hanging
  • From: Daniel Verite
• Re: psql \copy hanging
  • From: Arnaud L.
• RE: Declarative Range Partitioning Postgres 11
  • From: Shatamjeev Dewan
• RE: Declarative Range Partitioning Postgres 11
  • From: Shatamjeev Dewan