pgsql-general - July 2016

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)

Browse Archives

Prev | Next

July 1, 2016

Thread Author Time
Re: Replication with non-read-only standby. Venkata Balaji N 03:21
Re: table name size Sridhar N Bamandlapally 06:40
Re: Replication with non-read-only standby. 📎 Moreno Andreo 08:55
Re: Log archiving failing. Seems to be wrong timeline Chris Lewis 10:04
Re: Sub-query having NULL row returning FALSE result Sridhar N Bamandlapally 10:18
Re: table name size Tom Lane 14:03
Update multiple rows in a table with different values shankha 14:26
Re: Update multiple rows in a table with different values Adrian Klaver 14:48
Re: Update multiple rows in a table with different values David G. Johnston 14:50
Re: Update multiple rows in a table with different values shankha 14:51
Re: Update multiple rows in a table with different values Tom Lane 14:59
PSQL does not remove obvious useless joins Sfiligoi, Igor 17:17
Re: Update multiple rows in a table with different values shankha 19:03
Re: PSQL does not remove obvious useless joins Merlin Moncure 19:41
Re: 9.6 beta2 win-x64 download links still point to beta1 Thomas Kellerer 20:12
Re: PSQL does not remove obvious useless joins Kevin Grittner 20:28
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Sfiligoi, Igor 20:28
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Sfiligoi, Igor 20:33
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Adrian Klaver 20:38
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Sfiligoi, Igor 20:42
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Kevin Grittner 20:57
Re: 9.6 beta2 win-x64 download links still point to beta1 Bruce Momjian 21:39

July 2, 2016

Thread Author Time
Re: How safe is pg_basebackup + continuous archiving? Jim Nasby 00:10
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Sfiligoi, Igor 00:15
Re: Stored procedure version control Jim Nasby 00:17
Re: Stored procedure version control Rob Sargent 00:22
Re: Stored procedure version control Karsten Hilbert 12:19
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Kevin Grittner 13:27
deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements trafdev 16:54
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements Adrian Klaver 18:14
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements trafdev 18:38
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements Adrian Klaver 19:45

July 3, 2016

Thread Author Time
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements trafdev 01:18
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements trafdev 04:01
Re: Stored procedure version control Mark Morgan Lloyd 15:02
9.3 to 9.5 upgrade problems Andy Colson 15:06
Re: 9.3 to 9.5 upgrade problems Vick Khera 15:11
Re: 9.3 to 9.5 upgrade problems Andy Colson 15:18
Re: 9.3 to 9.5 upgrade problems Adrian Klaver 15:35
Re: 9.3 to 9.5 upgrade problems Andy Colson 15:49
Re: 9.3 to 9.5 upgrade problems Adrian Klaver 16:04
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements Adrian Klaver 16:11
GRANTable Row Permissions James Keener 16:26
Re: GRANTable Row Permissions James Keener 16:33
Re: 9.3 to 9.5 upgrade problems Andy Colson 16:42
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements Adrian Klaver 19:28
Re: 9.3 to 9.5 upgrade problems Andy Colson 19:41
Re: 9.3 to 9.5 upgrade problems Adrian Klaver 19:46
Unable to recovery due missing wal_file Patrick B 21:48
Re: Unable to recovery due missing wal_file Patrick B 22:17
psql connection option: statement_timeout Craig Boyd 22:54
Re: psql connection option: statement_timeout Melvin Davidson 23:15
Re: psql connection option: statement_timeout Craig Boyd 23:47
Re: psql connection option: statement_timeout Scott Marlowe 23:51
Re: psql connection option: statement_timeout Scott Marlowe 23:52

July 4, 2016

Thread Author Time
Re: psql connection option: statement_timeout Melvin Davidson 00:00
Re: Unable to recovery due missing wal_file Adrian Klaver 00:18
Re: Unable to recovery due missing wal_file Adrian Klaver 00:20
Re: Unable to recovery due missing wal_file Patrick B 00:23
Re: Unable to recovery due missing wal_file Adrian Klaver 00:32
Re: Unable to recovery due missing wal_file Patrick B 00:36
Re: Unable to recovery due missing wal_file Adrian Klaver 00:55
Re: psql connection option: statement_timeout Craig Boyd 01:16
Re: Unable to recovery due missing wal_file Patrick B 01:21
Re: psql connection option: statement_timeout Craig Boyd 01:25
Re: Unable to recovery due missing wal_file Patrick B 01:42
Re: Unable to recovery due missing wal_file Patrick B 01:50
Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements trafdev 01:53
Re: Unable to recovery due missing wal_file Adrian Klaver 04:06
Cluster on NAS and data center. Krzysztof Kaczkowski 09:35
Re: Cluster on NAS and data center. Adrian Klaver 14:01
Re: Cluster on NAS and data center. Melvin Davidson 14:55
Re: psql connection option: statement_timeout Daniel Verite 16:01
Re: psql connection option: statement_timeout Craig Boyd 16:15
9.6 Beta 2 Performance Regression on Recursive CTE Nicholson, Brad (Toronto, ON, CA) 20:03
Re: Unable to recovery due missing wal_file Martín Marqués 23:37

July 5, 2016

Thread Author Time
Re: Question about "grant create on database" and pg_dump/pg_dumpall 📎 Haribabu Kommi 06:39
Re: Cluster on NAS and data center. Krzysztof Kaczkowski 11:36
Materialized view not created with import Aurelien Praga 13:28
Avoid deadlocks on alter table Christian Castelli 13:30
Re: How safe is pg_basebackup + continuous archiving? Kaixi Luo 13:31
Re: Avoid deadlocks on alter table Adrian Klaver 14:01
pg_dump fundenental question J. Cassidy 14:54
Re: Avoid deadlocks on alter table Tom Lane 15:24
Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins Sfiligoi, Igor 16:21
Re: Materialized view not created with import Adrian Klaver 16:47
Re: pg_dump fundenental question Adrian Klaver 16:52
Re: pg_dump fundenental question David G. Johnston 16:54
Re: pg_dump fundenental question Rob Sargent 17:03
Re: pg_dump fundenental question J. Cassidy 17:10
Re: 9.6 Beta 2 Performance Regression on Recursive CTE Tom Lane 17:11
Re: pg_dump fundenental question J. Cassidy 17:13
Re: pg_dump fundenental question J. Cassidy 17:20
Re: pg_dump fundenental question Alvaro Herrera 17:21
Re: pg_dump fundenental question Joshua D. Drake 17:22
Re: pg_dump fundenental question Francisco Olarte 17:23
Re: pg_dump fundenental question J. Cassidy 17:39
Re: pg_dump fundenental question 📎 J. Cassidy 17:42
Re: pg_dump fundenental question Sameer Kumar 17:54
Re: psql connection option: statement_timeout Jerry Sievers 19:57
Re: pg_dump fundenental question Paul Linehan 20:17
Possible to create canonicalized range type without being superuser? Paul Jungwirth 20:57
Re: Possible to create canonicalized range type without being superuser? Tom Lane 21:37
Re: pg_dump fundenental question Christofer C. Bell 22:13
Re: pg_dump fundenental question trafdev 22:21
Re: Possible to create canonicalized range type without being superuser? David G. Johnston 22:28

July 6, 2016

Thread Author Time
Is it possible to use an EVENT TRIGGER to validate a TRIGGER? Luís Eduardo Oliveira Lizardo 00:08
How sync settings or extensions in streaming replication 苏士涛 02:37
Re: How sync settings or extensions in streaming replication Michael Paquier 02:46
Re: Is it possible to use an EVENT TRIGGER to validate a TRIGGER? Alvaro Herrera 03:02
Re: Possible to create canonicalized range type without being superuser? Paul A Jungwirth 05:17
Re: Possible to create canonicalized range type without being superuser? Paul A Jungwirth 05:40
estimate Index size sangeetha 07:35
Re: Avoid deadlocks on alter table Christian Castelli 07:43
Update statement results in Out of memory Ivan Bianchi 09:13
Re: How sync settings or extensions in streaming replication Guillaume Lelarge 11:16
Re: Fastest memmove in C FarjadFarid(ChkNet) 12:01
Re: Is it possible to use an EVENT TRIGGER to validate a TRIGGER? Luís Eduardo Oliveira Lizardo 12:18
Re: Update statement results in Out of memory Adrian Klaver 13:23
Re: Update statement results in Out of memory Paul Ramsey 13:36
Re: Update statement results in Out of memory Rémi Cura 13:42
Re: Avoid deadlocks on alter table Christian Castelli 13:45
Re: pg_dump fundenental question Francisco Olarte 14:30
Broken after upgrade arnaud gaboury 18:13
Re: Broken after upgrade Adrian Klaver 18:27
Re: Broken after upgrade John R Pierce 18:56
Re: Replication with non-read-only standby. Sylvain Marechal 20:00
Re: Broken after upgrade arnaud gaboury 21:13
Re: Fastest memmove in C Alvaro Herrera 21:15
Monitorando WAL Files - PostgreSQL 9.2 Lucas Possamai 21:18
Re: Monitorando WAL Files - PostgreSQL 9.2 Lucas Possamai 21:27
Re: Broken after upgrade John R Pierce 21:31
Broken after upgrade Jerry LeVan 21:40
Re: Broken after upgrade Adrian Klaver 21:49
Re: Broken after upgrade Devrim Gündüz 22:14
Re: Broken after upgrade José María Terry Jiménez 23:00

July 7, 2016

Thread Author Time
Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 01:18
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce 01:25
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 01:30
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce 01:35
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 01:44
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 01:46
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 01:50
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 01:52
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 01:57
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce 01:58
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 02:03
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 02:06
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 02:10
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 02:10
Re: Cascade streaming replication + wal_files - Pgsql 9.2 John R Pierce 02:14
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 02:17
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 02:31
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 02:55
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 03:01
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 03:19
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Patrick B 03:36
Re: Cascade streaming replication + wal_files - Pgsql 9.2 Sameer Kumar 04:04
Best way to insert a row with two columns having the value based on the same argument generated by another postgres function. Silk Parrot 06:56
Re: Broken after upgrade arnaud gaboury 08:01
Re: Update statement results in Out of memory Ivan Bianchi 09:16
Re: Fastest memmove in C FarjadFarid(ChkNet) 11:12
Re: Best way to insert a row with two columns having the value based on the same argument generated by another postgres function. Sándor Daku 13:12
Re: Best way to insert a row with two columns having the value based on the same argument generated by another postgres function. David G. Johnston 13:14
Re: Best way to insert a row with two columns having the value based on the same argument generated by another postgres function. Thomas Kellerer 13:15
Where clause in pg_dump: need help Prashanth Adiyodi 14:06
Re: Where clause in pg_dump: need help David G. Johnston 15:08
Re: Where clause in pg_dump: need help Francisco Olarte 15:12
Re: Where clause in pg_dump: need help bricklen 16:10
Re: Fastest memmove in C Merlin Moncure 16:23
Re: Fastest memmove in C Stephen Frost 16:33
Re: Fastest memmove in C Tom Lane 17:01
pasting a lot of commands to psql Dmitry Shalashov 17:22
Re: pasting a lot of commands to psql Sameer Kumar 17:26
Re: pasting a lot of commands to psql Melvin Davidson 17:30
Re: pasting a lot of commands to psql Dmitry Shalashov 17:30
Re: pasting a lot of commands to psql Dmitry Shalashov 17:33
Re: pasting a lot of commands to psql Melvin Davidson 17:36
Re: pasting a lot of commands to psql Tom Lane 17:37
Re: pasting a lot of commands to psql Sameer Kumar 17:37
Re: pasting a lot of commands to psql Scott Mead 17:39
Re: pasting a lot of commands to psql Scott Mead 17:40
Re: pasting a lot of commands to psql Dmitry Shalashov 17:41
Re: pasting a lot of commands to psql John R Pierce 17:43
Re: pasting a lot of commands to psql Dmitry Shalashov 17:46
Re: pasting a lot of commands to psql Dmitry Shalashov 17:47
Re: pasting a lot of commands to psql Dmitry Shalashov 17:48
Re: pasting a lot of commands to psql Rob Sargent 17:58
Re: pasting a lot of commands to psql Adrian Klaver 18:03
Re: pasting a lot of commands to psql Alvaro Herrera 18:18
Re: pasting a lot of commands to psql Merlin Moncure 19:44
Re: pasting a lot of commands to psql Alvaro Herrera 19:48
Re: pasting a lot of commands to psql John R Pierce 20:09
Re: pasting a lot of commands to psql Merlin Moncure 20:31
Re: pasting a lot of commands to psql John R Pierce 20:40
Re: pasting a lot of commands to psql Alvaro Herrera 20:42
Re: Fastest memmove in C FarjadFarid(ChkNet) 20:48

July 8, 2016

Thread Author Time
Re: pasting a lot of commands to psql Tom Lane 00:04
Re: Where clause in pg_dump: need help Prashanth Adiyodi 02:40
Re: [BUGS] Where clause in pg_dump: need help Francisco Olarte 09:37

Browse Archives

Prev | Next