pgsql-general - December 2019

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30 31

Dec. 1, 2019

Thread Author Time
Re: MS Access Frontend bret_stern 00:14
RE: Re: Re: Postgres Full Text Search Jsonb Array column does not search for first row 📎 Dmytro Zhluktenko 08:49
Re: MS Access Frontend Vincenzo Campanella 10:08
Re: MS Access Frontend Martin Gainty 14:09
Re: MS Access Frontend Michael Nolan 16:46
Re: MS Access Frontend Ron 16:54
Why are clobs always "0" Arnie Morein 17:31
slow insert speeds with bytea Alex O'Ree 17:59
Re: Why are clobs always "0" Adrian Klaver 18:21
Sv: Why are clobs always "0" Andreas Joseph Krogh 20:37
Re: Why are clobs always "0" Thomas Kellerer 21:13

Dec. 2, 2019

Thread Author Time
Connection terminated but client didn't realise David Wheeler 06:41
pgbackrest concerns and doubts. Ajay Pratap 06:52
Conditional return of aggregated data Laura Smith 11:10
Re: Conditional return of aggregated data Wim Bertels 11:27
Re: Conditional return of aggregated data Ravi Krishna 11:52
Re: Conditional return of aggregated data Ravi Krishna 11:56
Re: Conditional return of aggregated data Laura Smith 12:05
Re: Conditional return of aggregated data Alban Hertroys 12:08
Re: Connection terminated but client didn't realise Tom Lane 15:17
Re: pgbackrest concerns and doubts. David Steele 15:27
Re: slow insert speeds with bytea Adrian Klaver 15:52
Re: slow insert speeds with bytea Steve Atkins 16:01
Re: using replace function Antonio Silva 16:26
Preformance on upcoming Linux kernel stan 17:10
Upgrading from V11 to V12 on Debian install stan 19:28
Re: Upgrading from V11 to V12 on Debian install Adrian Klaver 20:28

Dec. 3, 2019

Thread Author Time
Re: Connection terminated but client didn't realise David Wheeler 01:29
Syntax error for UPDATE ... RETURNING INTO STRICT Alexander Farber 10:12
RE: Syntax error for UPDATE ... RETURNING INTO STRICT Patrick FICHE 10:49
Re: Syntax error for UPDATE ... RETURNING INTO STRICT Alexander Farber 11:37
Re: slow insert speeds with bytea Jeff Janes 15:20
Re: Syntax error for UPDATE ... RETURNING INTO STRICT Tom Lane 15:27
Re: Syntax error for UPDATE ... RETURNING INTO STRICT Adrian Klaver 15:29
Issue upgrading from V11 to V12 on Debian stan 15:53
Re: Issue upgrading from V11 to V12 on Debian Tom Lane 16:13
Re: Issue upgrading from V11 to V12 on Debian Paul Jungwirth 16:21
Re: Syntax error for UPDATE ... RETURNING INTO STRICT Alexander Farber 16:24
Re: Issue upgrading from V11 to V12 on Debian stan 16:46
Re: Issue upgrading from V11 to V12 on Debian Paul Jungwirth 16:58
Re: Issue upgrading from V11 to V12 on Debian stan 17:29
Re: Issue upgrading from V11 to V12 on Debian stan 17:41
Re: Issue upgrading from V11 to V12 on Debian Paul Jungwirth 17:47
Re: Issue upgrading from V11 to V12 on Debian stan 17:51
Re: Issue upgrading from V11 to V12 on Debian Daniel Verite 17:59
Re: Syntax error for UPDATE ... RETURNING INTO STRICT Adrian Klaver 19:34
Re: Issue upgrading from V11 to V12 on Debian Adrian Klaver 19:35
Re: Issue upgrading from V11 to V12 on Debian stan 20:33
upgrade and migrate Julie Nishimura 22:32

Dec. 4, 2019

Thread Author Time
Re: pg_basebackup + incremental base backups Stephen Frost 03:09
Re: upgrade and migrate Michael Paquier 04:48
Re: upgrade and migrate Ron 07:13
Re: upgrade and migrate Thomas Kellerer 07:38
Re: upgrade and migrate Laurenz Albe 07:56
Re: upgrade and migrate Michael Paquier 08:08
secure deletion of archived logs Zwettler Markus (OIZ) 10:30
Re: upgrade and migrate Stephen Frost 13:08
Re: upgrade and migrate Tom Lane 13:28
Re: secure deletion of archived logs Stephen Frost 13:31
Re: upgrade and migrate Peter Eisentraut 15:26
archiving question Zwettler Markus (OIZ) 16:49
Re: archiving question Stephen Frost 17:56
what causes xact_rollback for a database in pg_stat_database to increment? Hu, Patricia 20:48
Re: what causes xact_rollback for a database in pg_stat_database to increment? Justin 22:15
Re: what causes xact_rollback for a database in pg_stat_database to increment? Jerry Sievers 22:31
Logging Rich Shepard 23:20
Re: Logging Stephen Eilert 23:24
Re: Logging Adrian Klaver 23:26

Dec. 5, 2019

Thread Author Time
Re: Logging [RESOLVED] Rich Shepard 00:03
Re: Logging Rich Shepard 00:06
We have to close the cursor or rollback the transaction in case of failure? M Tarkeshwar Rao 10:00
Schema Copy Sonam Sharma 10:07
Re: Schema Copy Justin 14:22
Re: Schema Copy Sonam Sharma 14:30
Re: Schema Copy Justin 14:33
AW: secure deletion of archived logs Zwettler Markus (OIZ) 14:49
AW: archiving question Zwettler Markus (OIZ) 15:04
Re: We have to close the cursor or rollback the transaction in case of failure? Tom Lane 15:05
Re: Schema Copy Melvin Davidson 15:58
Re: Schema Copy Sonam Sharma 16:17
Date created for tables Chloe Dives 17:10
Re: Date created for tables Tom Lane 19:01
Re: Date created for tables Justin 19:02
Re: Date created for tables Adrian Klaver 19:10

Dec. 6, 2019

Thread Author Time
Re: Date created for tables Ron 01:12
Re: Date created for tables Michael Paquier 01:40
Re: archiving question Michael Paquier 01:42
Re: Date created for tables Ron 02:50
Insert Table from Execute String Query İlyas Derse 09:00
Tuple concurrency issue in large objects Shalini 09:26
AW: archiving question Zwettler Markus (OIZ) 09:50
Re: archiving question Magnus Hagander 10:14
Slow planing... Mladen Marinović 10:14
AW: archiving question Zwettler Markus (OIZ) 11:06
Re: [11.6] WALs recovery ordering with Restore Command - timelines Pavel Suderevsky 13:17
Re: archiving question Magnus Hagander 13:20
Re: Slow planing... Mladen Marinović 13:50
Re: Slow planing... Tom Lane 14:45
Re: Insert Table from Execute String Query Adrian Klaver 15:38
Re: Slow planing... Michael Lewis 15:43
Re: upgrade and migrate Julie Nishimura 16:14
Re: upgrade and migrate Adrian Klaver 17:02
Q: cert authentication and user remapping fails Albrecht Dreß 17:22
Re: Q: cert authentication and user remapping fails Tom Lane 17:52
Re: upgrade and migrate Justin 18:06
Re: Slow planing... Pavel Stehule 18:16
Re: upgrade and migrate Julie Nishimura 19:36
migration from 9.4 to 9.6 Julie Nishimura 21:19
Re: migration from 9.4 to 9.6 Adrian Klaver 21:32
Re: migration from 9.4 to 9.6 Julie Nishimura 21:38
Re: migration from 9.4 to 9.6 Adrian Klaver 22:02
Re: migration from 9.4 to 9.6 Alan Hodgson 22:07
Re: Logging [RESOLVED] Peter J. Holzer 22:08

Dec. 7, 2019

Thread Author Time
CREATE INDEX ON words_moves(length(letters), score) WHERE action = 'play' Alexander Farber 15:20

Dec. 8, 2019

Thread Author Time
Re: CREATE INDEX ON words_moves(length(letters), score) WHERE action = 'play' Peter J. Holzer 11:55
canno save editted data Patrick Fiset 19:54
Re: canno save editted data Adrian Klaver 20:09
Re: canno save editted data Adrian Klaver 21:23

Dec. 9, 2019

Thread Author Time
Re: Rows violating Foreign key constraint exists Nandakumar M 10:17
PostgreSQL HA FO question Dor Ben Dov 10:24
AW: PostgreSQL HA FO question Zwettler Markus (OIZ) 11:13
RE: PostgreSQL HA FO question Dor Ben Dov 12:24
Re: migration from 9.4 to 9.6 Ekaterina Amez 12:25
Re: AW: secure deletion of archived logs Stephen Frost 14:30
Upgrade PostgreSQL 9.6 to 10.6 github kran 15:43
Re: Upgrade PostgreSQL 9.6 to 10.6 Andreas Kretschmer 16:02
Re: Q: cert authentication and user remapping fails Albrecht Dreß 17:30
Query with correlated join having slow performance saket bansal 18:22
Re: Query with correlated join having slow performance Michael Lewis 18:48
Re: Query with correlated join having slow performance Justin 19:43
Re: Query with correlated join having slow performance saket bansal 19:54
Re: Query with correlated join having slow performance saket bansal 20:04
Re: Query with correlated join having slow performance Pavel Stehule 20:14
Re: Upgrade PostgreSQL 9.6 to 10.6 github kran 22:37

Dec. 10, 2019

Thread Author Time
Re: Tuple concurrency issue in large objects Rene Romero Benavides 05:54
Identity columns, DEFAULT keyword and multi-row inserts Thomas Kellerer 07:41
Logical Replication of Multiple Schema Versions Dan shmidt 07:55
RE: Identity columns, DEFAULT keyword and multi-row inserts Patrick FICHE 07:56
Re: Identity columns, DEFAULT keyword and multi-row inserts Thomas Kellerer 08:15
Re: Upgrade PostgreSQL 9.6 to 10.6 Andreas Kretschmer 08:53
A question about upgrading on Debian/Ubuntu stan 11:21
server will not start (Debian) stan 11:48
tcp keep alive don't work when the backend is busy Олег Самойлов 12:53
PGUSER and initdb Олег Самойлов 13:21
PostgreSQL vs PostgresQL Олег Самойлов 13:27
Re: server will not start (Debian) stan 13:36
Re: tcp keep alive don't work when the backend is busy Tom Lane 15:06
Re: tcp keep alive don't work when the backend is busy Fabio Ugo Venchiarutti 15:17
Re: server will not start (Debian) stan 15:32
Re: tcp keep alive don't work when the backend is busy Justin 15:36
pgpool-II 3.7.5 with ssl Vikas Sharma 15:40
Re: A question about upgrading on Debian/Ubuntu Adrian Klaver 15:46
Re: PostgreSQL vs PostgresQL Adrian Klaver 15:59
Re: PGUSER and initdb Adrian Klaver 16:05
Re: pgpool-II 3.7.5 with ssl Tom Lane 16:08
Re: Identity columns, DEFAULT keyword and multi-row inserts Adrian Klaver 16:08
Re: server will not start (Debian) Adrian Klaver 16:11
Re: server will not start (Debian) Ray O'Donnell 16:13
Re: server will not start (Debian) Justin 16:13
Re: A question about upgrading on Debian/Ubuntu stan 16:14
Re: server will not start (Debian) stan 16:24
Re: Identity columns, DEFAULT keyword and multi-row inserts Tom Lane 16:53
Re: server will not start (Debian) stan 17:03
Re: server will not start (Debian) Adrian Klaver 17:03
Re: server will not start (Debian) Adrian Klaver 17:06
Re: A question about upgrading on Debian/Ubuntu Adrian Klaver 17:27
Fast, stable, portable hash function producing 4-byte or 8-byte values? Erwin Brandstetter 21:11
Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Laurenz Albe 22:13
Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Miles Elam 22:34
Re: PostgreSQL vs PostgresQL raf 23:10

Dec. 11, 2019

Thread Author Time
Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Ron 00:00
Re: pgpool-II 3.7.5 with ssl Tatsuo Ishii 00:11
Re: tcp keep alive don't work when the backend is busy Thomas Munro 04:35
Re: Tuple concurrency issue in large objects Shalini 05:12
AW: PostgreSQL HA FO question Zwettler Markus (OIZ) 09:14
Re: PGUSER and initdb Олег Самойлов 13:18
Re: tcp keep alive don't work when the backend is busy Олег Самойлов 13:25
Re: Identity columns, DEFAULT keyword and multi-row inserts Peter Eisentraut 15:24
AW: AW: secure deletion of archived logs Zwettler Markus (OIZ) 15:25
Re: AW: AW: secure deletion of archived logs Stephen Frost 15:52
Re: Logical Replication of Multiple Schema Versions Peter Eisentraut 16:13
Re: PGUSER and initdb Adrian Klaver 16:31
Re: PGUSER and initdb Tom Lane 17:06
Re: PGUSER and initdb Adrian Klaver 17:19
Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Erwin Brandstetter 18:01
Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Erwin Brandstetter 18:07
Encoding/collation question Rich Shepard 19:16
Re: Fast, stable, portable hash function producing 4-byte or 8-byte values? Tom Lane 19:20
Re: Encoding/collation question Tom Lane 19:25
Re: Encoding/collation question Rich Shepard 19:44
Counting number of sites with same number of sampling dates Rich Shepard 20:54
Re: Counting number of sites with same number of sampling dates Michael Lewis 20:58
Re: Counting number of sites with same number of sampling dates Rich Shepard 21:09
Re: Counting number of sites with same number of sampling dates Rich Shepard 21:11
Re: Logical Replication of Multiple Schema Versions Dan shmidt 21:17

Dec. 12, 2019

Thread Author Time
Logical replication DNS cache Mike Lissner 00:37
Re: Encoding/collation question Andrew Gierth 05:03
RE: PostgreSQL version compatibility with RHEL7.7 Deepti Sharma S 05:34
Re: Encoding/collation question Karsten Hilbert 09:37
Re: Encoding/collation question Tom Lane 13:35

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30 31