Mailing lists [pgsql-general]
- RE: MS Access Frontend Jason L. Amerson
- Re: MS Access Frontend bret_stern
- Re: MS Access Frontend Vincenzo Campanella
- Re: MS Access Frontend Martin Gainty
- Re: MS Access Frontend Michael Nolan
- Re: MS Access Frontend Ron
- Why are clobs always "0" Arnie Morein
- slow insert speeds with bytea Alex O'Ree
- Re: Why are clobs always "0" Adrian Klaver
- Sv: Why are clobs always "0" Andreas Joseph Krogh
- Re: Why are clobs always "0" Thomas Kellerer
- Connection terminated but client didn't realise David Wheeler
- pgbackrest concerns and doubts. Ajay Pratap
- Conditional return of aggregated data Laura Smith
- Re: Conditional return of aggregated data Wim Bertels
- Re: Conditional return of aggregated data Ravi Krishna
- Re: Conditional return of aggregated data Ravi Krishna
- Re: Conditional return of aggregated data Laura Smith
- Re: Conditional return of aggregated data Alban Hertroys
- Re: Connection terminated but client didn't realise Tom Lane
- Re: pgbackrest concerns and doubts. David Steele
- Re: slow insert speeds with bytea Adrian Klaver
- Re: slow insert speeds with bytea Steve Atkins
- Re: using replace function Antonio Silva
- Preformance on upcoming Linux kernel stan
- Upgrading from V11 to V12 on Debian install stan
- Re: Upgrading from V11 to V12 on Debian install Adrian Klaver
- Re: Connection terminated but client didn't realise David Wheeler
- Syntax error for UPDATE ... RETURNING INTO STRICT Alexander Farber
- RE: Syntax error for UPDATE ... RETURNING INTO STRICT Patrick FICHE
- Re: Syntax error for UPDATE ... RETURNING INTO STRICT Alexander Farber
- Re: slow insert speeds with bytea Jeff Janes
- Re: Syntax error for UPDATE ... RETURNING INTO STRICT Tom Lane
- Re: Syntax error for UPDATE ... RETURNING INTO STRICT Adrian Klaver
- Issue upgrading from V11 to V12 on Debian stan
- Re: Issue upgrading from V11 to V12 on Debian Tom Lane
- Re: Issue upgrading from V11 to V12 on Debian Paul Jungwirth
- Re: Syntax error for UPDATE ... RETURNING INTO STRICT Alexander Farber
- Re: Issue upgrading from V11 to V12 on Debian stan
- Re: Issue upgrading from V11 to V12 on Debian Paul Jungwirth
- Re: Issue upgrading from V11 to V12 on Debian stan
- Re: Issue upgrading from V11 to V12 on Debian stan
- Re: Issue upgrading from V11 to V12 on Debian Paul Jungwirth
- Re: Issue upgrading from V11 to V12 on Debian stan
- Re: Issue upgrading from V11 to V12 on Debian Daniel Verite
- Re: Syntax error for UPDATE ... RETURNING INTO STRICT Adrian Klaver
- Re: Issue upgrading from V11 to V12 on Debian Adrian Klaver
- Re: Issue upgrading from V11 to V12 on Debian stan
- upgrade and migrate Julie Nishimura
- Re: pg_basebackup + incremental base backups Stephen Frost
- Re: upgrade and migrate Michael Paquier
- Re: upgrade and migrate Ron
- Re: upgrade and migrate Thomas Kellerer
- Re: upgrade and migrate Laurenz Albe
- Re: upgrade and migrate Michael Paquier
- secure deletion of archived logs Zwettler Markus (OIZ)
- Re: upgrade and migrate Stephen Frost
- Re: upgrade and migrate Tom Lane
- Re: secure deletion of archived logs Stephen Frost
- Re: upgrade and migrate Peter Eisentraut
- archiving question Zwettler Markus (OIZ)
- Re: archiving question Stephen Frost
- what causes xact_rollback for a database in pg_stat_database toincrement? Hu, Patricia
- Re: what causes xact_rollback for a database in pg_stat_database to increment? Justin
- Re: what causes xact_rollback for a database in pg_stat_database to increment? Jerry Sievers
- Logging Rich Shepard
- Re: Logging Stephen Eilert
- Re: Logging Adrian Klaver
- Re: Logging [RESOLVED] Rich Shepard
- Re: Logging Rich Shepard
- We have to close the cursor or rollback the transaction in case offailure? M Tarkeshwar Rao
- Schema Copy Sonam Sharma
- Re: Schema Copy Justin
- Re: Schema Copy Sonam Sharma
- Re: Schema Copy Justin
- AW: secure deletion of archived logs Zwettler Markus (OIZ)
- AW: archiving question Zwettler Markus (OIZ)
- Re: We have to close the cursor or rollback the transaction in case of failure? Tom Lane
- Re: Schema Copy Melvin Davidson
- Re: Schema Copy Sonam Sharma
- Date created for tables Chloe Dives
- Re: Date created for tables Tom Lane
- Re: Date created for tables Justin
- Re: Date created for tables Adrian Klaver
- Re: Date created for tables Ron
- Re: Date created for tables Michael Paquier
- Re: archiving question Michael Paquier
- Re: Date created for tables Ron
- Insert Table from Execute String Query İlyas Derse
- Tuple concurrency issue in large objects Shalini
- AW: archiving question Zwettler Markus (OIZ)
- Re: archiving question Magnus Hagander
- Slow planing... Mladen Marinović
- AW: archiving question Zwettler Markus (OIZ)
- Re: [11.6] WALs recovery ordering with Restore Command - timelines Pavel Suderevsky
- Re: archiving question Magnus Hagander
- Re: Slow planing... Mladen Marinović
- Re: Slow planing... Tom Lane
- Re: Insert Table from Execute String Query Adrian Klaver
- Re: Slow planing... Michael Lewis
- Re: upgrade and migrate Julie Nishimura
- Re: upgrade and migrate Adrian Klaver
- Q: cert authentication and user remapping fails Albrecht Dreß
- Re: Q: cert authentication and user remapping fails Tom Lane
- Re: upgrade and migrate Justin
- Re: Slow planing... Pavel Stehule
- Re: upgrade and migrate Julie Nishimura
- migration from 9.4 to 9.6 Julie Nishimura
- Re: migration from 9.4 to 9.6 Adrian Klaver
- Re: migration from 9.4 to 9.6 Julie Nishimura
- Re: migration from 9.4 to 9.6 Adrian Klaver
- Re: migration from 9.4 to 9.6 Alan Hodgson
- Re: Logging [RESOLVED] Peter J. Holzer
- CREATE INDEX ON words_moves(length(letters), score) WHERE action = 'play' Alexander Farber
- Re: CREATE INDEX ON words_moves(length(letters), score) WHERE action= 'play' Peter J. Holzer
- canno save editted data Patrick Fiset
- Re: canno save editted data Adrian Klaver
- Re: canno save editted data Adrian Klaver
- Re: Rows violating Foreign key constraint exists Nandakumar M
- PostgreSQL HA FO question Dor Ben Dov
- AW: PostgreSQL HA FO question Zwettler Markus (OIZ)
- RE: PostgreSQL HA FO question Dor Ben Dov
- Re: migration from 9.4 to 9.6 Ekaterina Amez
- Re: AW: secure deletion of archived logs Stephen Frost
- Upgrade PostgreSQL 9.6 to 10.6 github kran
- Re: Upgrade PostgreSQL 9.6 to 10.6 Andreas Kretschmer
- Re: Q: cert authentication and user remapping fails Albrecht Dreß
- Query with correlated join having slow performance saket bansal
- Re: Query with correlated join having slow performance Michael Lewis
- Re: Query with correlated join having slow performance Justin
- Re: Query with correlated join having slow performance saket bansal
- Re: Query with correlated join having slow performance saket bansal
- Re: Query with correlated join having slow performance Pavel Stehule
- Re: Upgrade PostgreSQL 9.6 to 10.6 github kran
- Re: Tuple concurrency issue in large objects Rene Romero Benavides
- Identity columns, DEFAULT keyword and multi-row inserts Thomas Kellerer
- Logical Replication of Multiple Schema Versions Dan shmidt
- RE: Identity columns, DEFAULT keyword and multi-row inserts Patrick FICHE
- Re: Identity columns, DEFAULT keyword and multi-row inserts Thomas Kellerer
- Re: Upgrade PostgreSQL 9.6 to 10.6 Andreas Kretschmer
- A question about upgrading on Debian/Ubuntu stan
- server will not start (Debian) stan
- tcp keep alive don't work when the backend is busy Олег Самойлов
- PGUSER and initdb Олег Самойлов
- PostgreSQL vs PostgresQL Олег Самойлов
- Re: server will not start (Debian) stan
- Re: tcp keep alive don't work when the backend is busy Tom Lane
- Re: tcp keep alive don't work when the backend is busy Fabio Ugo Venchiarutti
- Re: server will not start (Debian) stan
- Re: tcp keep alive don't work when the backend is busy Justin
- pgpool-II 3.7.5 with ssl Vikas Sharma
- Re: A question about upgrading on Debian/Ubuntu Adrian Klaver
- Re: PostgreSQL vs PostgresQL Adrian Klaver
- Re: PGUSER and initdb Adrian Klaver
- Re: pgpool-II 3.7.5 with ssl Tom Lane
- Re: Identity columns, DEFAULT keyword and multi-row inserts Adrian Klaver
- Re: server will not start (Debian) Adrian Klaver
- Re: server will not start (Debian) Ray O'Donnell
- Re: server will not start (Debian) Justin
- Re: A question about upgrading on Debian/Ubuntu stan
- Re: server will not start (Debian) stan
- Re: Identity columns, DEFAULT keyword and multi-row inserts Tom Lane
- Re: server will not start (Debian) stan
- Re: server will not start (Debian) Adrian Klaver
- Re: server will not start (Debian) Adrian Klaver
- Re: A question about upgrading on Debian/Ubuntu Adrian Klaver
- Fast, stable, portable hash function producing 4-byte or 8-byte values? Erwin Brandstetter
- Re: Fast, stable, portable hash function producing 4-byte or 8-bytevalues? Laurenz Albe
- Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Miles Elam
- Re: PostgreSQL vs PostgresQL raf
- Re: Fast, stable, portable hash function producing 4-byte or 8-bytevalues? Ron
- Re: pgpool-II 3.7.5 with ssl Tatsuo Ishii
- Re: tcp keep alive don't work when the backend is busy Thomas Munro
- Re: Tuple concurrency issue in large objects Shalini
- AW: PostgreSQL HA FO question Zwettler Markus (OIZ)
- Re: PGUSER and initdb Олег Самойлов
- Re: tcp keep alive don't work when the backend is busy Олег Самойлов
- Re: Identity columns, DEFAULT keyword and multi-row inserts Peter Eisentraut
- AW: AW: secure deletion of archived logs Zwettler Markus (OIZ)
- Re: AW: AW: secure deletion of archived logs Stephen Frost
- Re: Logical Replication of Multiple Schema Versions Peter Eisentraut
- Re: PGUSER and initdb Adrian Klaver
- Re: PGUSER and initdb Tom Lane
- Re: PGUSER and initdb Adrian Klaver
- Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Erwin Brandstetter
- Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Erwin Brandstetter
- Encoding/collation question Rich Shepard
- Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Tom Lane
- Re: Encoding/collation question Tom Lane
- Re: Encoding/collation question Rich Shepard
- Counting number of sites with same number of sampling dates Rich Shepard
- Re: Counting number of sites with same number of sampling dates Michael Lewis
- Re: Counting number of sites with same number of sampling dates Rich Shepard
- Re: Counting number of sites with same number of sampling dates Rich Shepard
- Re: Logical Replication of Multiple Schema Versions Dan shmidt
- Logical replication DNS cache Mike Lissner
- Re: Encoding/collation question Andrew Gierth
- RE: PostgreSQL version compatibility with RHEL7.7 Deepti Sharma S
- Re: Encoding/collation question Karsten Hilbert
- Re: Encoding/collation question Tom Lane
- Re: Encoding/collation question Rich Shepard
- Re: Logical replication DNS cache Peter Eisentraut
- Async_Notify Арсен Арутюнян
- Backup and Restore Dor Ben Dov
- Re: Backup and Restore Adrian Klaver
- Re: Backup and Restore Grigory Smolkin
- When are Predicate Locks Freed Dave Halter
- Re: Backup and Restore Andreas Kretschmer
- Re: When are Predicate Locks Freed Thomas Munro
- Re: REINDEX VERBOSE iso-8859-1 option Josef Šimánek
- How to Change collate & ctype for an existing database? Daulat Ram
- Re: How to Change collate & ctype for an existing database? Pavel Stehule
- Re: Tuple concurrency issue in large objects Daniel Verite
- Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql? İlyas Derse
- Re: Is there an equivalent to sp_getapplock, sp_releaseapplock inPostgreSql? Andrei Zhidenkov
- Re: Is there an equivalent to sp_getapplock, sp_releaseapplock in PostgreSql? Justin
- Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ? Abraham, Danny
- Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ? Abraham, Danny
- Re: server will not start (Debian) Peter J. Holzer
- Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ? Adrian Klaver
- Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? George Neuner
- Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Erik Aronesty
- Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ? Ron
- Re: Fast, stable, portable hash function producing 4-byte or 8-bytevalues? Ron
- Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ? Grigory Smolkin
- Access privileges Daulat Ram
- Re: Race condition while creating a new partition Andrei Zhidenkov
- Re: Event Triggers and Dropping Objects chikolette-postgresql@yahoo.com
- Re: Access privileges Christoph Moench-Tegeder
- Re: Race condition while creating a new partition Justin
- Re: Race condition while creating a new partition Andrei Zhidenkov
- Re: Race condition while creating a new partition Justin
- Experiencing error during restore - found unexpected block ID (0) Sar
- Re: Race condition while creating a new partition Michael Lewis
- Re: Race condition while creating a new partition Andrei Zhidenkov
- Row locks, SKIP LOCKED, and transactions Steven Winfield
- Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? George Neuner
- Re: Row locks, SKIP LOCKED, and transactions Adrian Klaver
- Re: Row locks, SKIP LOCKED, and transactions Thomas Munro
- Re: Encoding/collation question Karsten Hilbert
- RE: Row locks, SKIP LOCKED, and transactions Steven Winfield
- RE: Row locks, SKIP LOCKED, and transactions Steven Winfield
- Re: REINDEX VERBOSE iso-8859-1 option Josef Šimánek
- Streaming replication fails after some time with 'incorrect resourcemanager data checksum' Julian Backes
- Re: Row locks, SKIP LOCKED, and transactions Tom Lane
- Re: Tuple concurrency issue in large objects Daniel Verite
- Re: Tuple concurrency issue in large objects Justin
- Re: Tuple concurrency issue in large objects Tom Lane
- Re: Tuple concurrency issue in large objects Justin
- Re: Tuple concurrency issue in large objects Tom Lane
- Re: Tuple concurrency issue in large objects Justin
- Re: How to prevent POSTGRES killing linux system from accepting toomuch inserts? Steven Lembark
- Postgres AssertFailedException Exception Patil, Prashant
- Re: Postgres AssertFailedException Exception Tom Lane
- AccessExclusiveLock with pg_locks.locktype of tuple Erik Jones
- READ UNCOMMITTED in postgres Matthew Phillips
- Re: READ UNCOMMITTED in postgres Stephen Frost
- Re: AccessExclusiveLock with pg_locks.locktype of tuple Tom Lane
- Re: READ UNCOMMITTED in postgres Thomas Kellerer
- Re: READ UNCOMMITTED in postgres Simon Riggs
- Max locks James Sewell
- Re: READ UNCOMMITTED in postgres Olivier Gautherot
- Partitioned tables and locks James Sewell
- Commit to primary with unavailable sync standby Andrey Borodin
- Re: Max locks Peter Eisentraut
- Re: Commit to primary with unavailable sync standby Fabio Ugo Venchiarutti
- Re: Commit to primary with unavailable sync standby Andrey Borodin
- Re: Commit to primary with unavailable sync standby Fabio Ugo Venchiarutti
- Re: Partitioned tables and locks Tom Lane
- Re: Commit to primary with unavailable sync standby Maksim Milyutin
- Re: Max locks Andrew Gierth
- Re: Commit to primary with unavailable sync standby Fabio Ugo Venchiarutti
- RE: Row locks, SKIP LOCKED, and transactions Steven Winfield
- Re: Partitioned tables and locks James Sewell
- Re: Max locks James Sewell
- Re: Partitioned tables and locks Michael Lewis
- install postgres Marc Millas
- Re: install postgres Thomas Markus
- Upgrading from PostgreSQL 9.3 to 11.6 tony@exquisiteimages.com
- Re: install postgres Laurenz Albe
- BigSQL pgc alternative Samuel Teixeira Santos
- Re: Upgrading from PostgreSQL 9.3 to 11.6 Adrian Klaver
- Re: Upgrading from PostgreSQL 9.3 to 11.6 tony@exquisiteimages.com
- Semi-unable to add new records to table--primary key needed? Boylan, Ross
- Re: Semi-unable to add new records to table--primary key needed? Ron
- Re: Semi-unable to add new records to table--primary key needed? Tom Lane
- Re: Semi-unable to add new records to table--primary key needed? Adrian Klaver
- Re: Semi-unable to add new records to table--primary key needed? Ron
- Re: Semi-unable to add new records to table--primary key needed? Boylan, Ross
- Re: Semi-unable to add new records to table--primary key needed? Adrian Klaver
- Re: Semi-unable to add new records to table--primary key needed? Boylan, Ross
- Re: Semi-unable to add new records to table--primary key needed? Adrian Klaver
- Re: BigSQL pgc alternative Tomas Vondra
- Re: Semi-unable to add new records to table--primary key needed? Boylan, Ross
- Re: BigSQL pgc alternative Thomas Kellerer
- pg_basebackup Daulat Ram
- Re: pg_basebackup Adrian Klaver
- Re: Semi-unable to add new records to table--primary key needed? Adrian Klaver
- unanalyze a foreign table Jeff Janes
- Re: Semi-unable to add new records to table--primary key needed? Boylan, Ross
- Re: Semi-unable to add new records to table--primary key needed? Adrian Klaver
- Question: what is proper way to define python function asevent_trigger? Andrei Pozolotin
- Re: Question: what is proper way to define python function asevent_trigger? Jeff Ross
- Re: Question: what is proper way to define python function asevent_trigger? Jeff Ross
- Re: Question: what is proper way to define python function as event_trigger? Tom Lane
- Re: Semi-unable to add new records to table--primary key needed? Boylan, Ross
- Re: Semi-unable to add new records to table--primary key needed? Adrian Klaver
- Re: Question: what is proper way to define python function asevent_trigger? Andrei Pozolotin
- Re: Question: what is proper way to define python function asevent_trigger? Andrei Pozolotin
- Re: pg_basebackup Daulat Ram
- Re: Tuple concurrency issue in large objects Shalini
- Re: pg_basebackup Kyotaro Horiguchi
- SQL operator '*=' Matthias Apitz
- Re: SQL operator '*=' Thomas Kellerer
- Mixing greediness in regexp_matches Daniel Verite
- Re: Mixing greediness in regexp_matches Tom Lane
- Re: Mixing greediness in regexp_matches Tom Lane
- Re: Mixing greediness in regexp_matches Daniel Verite
- Re: Mixing greediness in regexp_matches Daniel Verite
- Re: Mixing greediness in regexp_matches Tom Lane
- Re: Commit to primary with unavailable sync standby Maksim Milyutin
- Re: SQL operator '*=' Alban Hertroys
- Re: unanalyze a foreign table Justin
- Re: pgpool High Availability Issue Bruce Momjian
- Re: pgpool High Availability Issue Tatsuo Ishii
- Re: Date created for tables Bruce Momjian
- Re: Date created for tables Ron
- Re: Date created for tables Melvin Davidson
- logical replication protocol Scott Ribe
- Re: Date created for tables Thomas Kellerer
- Postgres cursor taking 2 hrs to update the table M Tarkeshwar Rao
- Re: logical replication protocol Tatsuo Ishii
- Re: logical replication protocol Scott Ribe
- Re: Date created for tables Fabrízio de Royes Mello
- Re: Date created for tables Adrian Klaver
- Re: Postgres cursor taking 2 hrs to update the table Adrian Klaver
- Re: Date created for tables Ron
- Question on upgrading postgresql from 10.7 to 11.5 Lu, Dan
- Re: Date created for tables Adrian Klaver
- Re: Date created for tables Ron
- Re: Date created for tables Rob Sargent
- Re: Date created for tables Ron
- Re: Date created for tables Rob Sargent
- Re: Date created for tables Ron
- Backup and Restore Dor Ben Dov
- Re: Backup and Restore Andreas Kretschmer
- Re: Date created for tables Melvin Davidson
- Syntax question about returning value from an insert stan
- Re: Question on upgrading postgresql from 10.7 to 11.5 Julien Rouhaud
- Re: Syntax question about returning value from an insert Pavel Stehule
- Re: Backup and Restore Ron
- Re: Backup and Restore Adrian Klaver
- Re: Syntax question about returning value from an insert Adrian Klaver
- Re: Syntax question about returning value from an insert stan
- Re: Syntax question about returning value from an insert Adrian Klaver
- Re: Syntax question about returning value from an insert stan
- Re: Syntax question about returning value from an insert Rob Sargent
- Re: Syntax question about returning value from an insert Adrian Klaver
- Re: Syntax question about returning value from an insert stan
- Re: Syntax question about returning value from an insert stan
- Re: Syntax question about returning value from an insert Rob Sargent
- Re: Syntax question about returning value from an insert Adrian Klaver
- Re: Syntax question about returning value from an insert Adrian Klaver
- Re: Syntax question about returning value from an insert stan
- What am I doing wrong here? stan
- RE: Question on upgrading postgresql from 10.7 to 11.5 Lu, Dan
- Re: What am I doing wrong here? Ray O'Donnell
- Re: What am I doing wrong here? Jayadevan M
- Re: What am I doing wrong here? Tom Lane
- Re: What am I doing wrong here? stan
- Re: What am I doing wrong here? stan
- Re: What am I doing wrong here? stan
- Not my day :-( Another syntax error stan
- Re: Not my day :-( Another syntax error David G. Johnston
- Re: Not my day :-( Another syntax error stan
- Re: Not my day :-( Another syntax error Pavel Stehule
- testing in ESQL/C if a CUSROR "foo" is open? Matthias Apitz
- Re: pg_basebackup Jeff Janes
- Re: Are my autovacuum settings too aggressive for this table? Jeff Janes
- replace single char for string using regexp_replace PegoraroF10
- Re: replace single char for string using regexp_replace Tom Lane
- Re: testing in ESQL/C if a CUSROR "foo" is open? Matthias Apitz
- Re: replace single char for string using regexp_replace Daniel Verite
- Need auto fail over cluster solution for PostGres Girish Kumar
- Re: Need auto fail over cluster solution for PostGres Fabrízio de Royes Mello
- A JOIN question stan
- Re: A JOIN question Michael Lewis
- Re: A JOIN question stan
- How to reset a server error '25P02 in_failed_sql_transaction' Matthias Apitz
- Re: How to reset a server error '25P02 in_failed_sql_transaction' Guillaume Lelarge
- RE: How to reset a server error '25P02 in_failed_sql_transaction' Patrick FICHE
- Pg import access Sonam Sharma
- Re: Pg import access Adrian Klaver
- Re: Need auto fail over cluster solution for PostGres Girish Kumar
- Re: How to reset a server error '25P02 in_failed_sql_transaction' Ron
- Re: How to reset a server error '25P02 in_failed_sql_transaction' David G. Johnston
- Re: How to reset a server error '25P02 in_failed_sql_transaction' Ron