pgsql-general - November 2017

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 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Nov. 1, 2017

Thread Author Time
Re: PG 10 - Trouble with overlap of range partition of two dimensions Stephen Froehlich 01:39
Re: PG 10 - Trouble with overlap of range partition of two dimensions Arjen Nienhuis 06:24
Query plan for Merge Semi Join Peter J. Holzer 09:24
Re: Query plan for Merge Semi Join Laurenz Albe 12:19
Re: the database system is shutting down - terminating walsender process due to replication timeout Tom Lane 15:25
Re: Monitoring of a hot standby with a largely idle master Peter Eisentraut 18:36
explain analyze output: 0 rows, 1M loopa Scott Marlowe 18:59
Re: explain analyze output: 0 rows, 1M loopa David G. Johnston 19:19
Re: explain analyze output: 0 rows, 1M loops Justin Pryzby 19:25
Re: explain analyze output: 0 rows, 1M loops David G. Johnston 19:31
Re: explain analyze output: 0 rows, 1M loopa Scott Marlowe 19:48
Possible bug: could not open relation with OID [numbers] SQL State: XX000 📎 Adam Brusselback 20:11
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Justin Pryzby 22:03
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Adam Brusselback 23:02
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Adam Brusselback 23:30

Nov. 2, 2017

Thread Author Time
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Tom Lane 01:36
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Adam Brusselback 02:36
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Tom Lane 03:12
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Adam Brusselback 03:35
Re: Possible bug: could not open relation with OID [numbers] SQL State: XX000 Tom Lane 03:45
Building tds_fdw Extension for Windows 64bit Igal @ Lucee.org 06:34
Re: Building tds_fdw Extension for Windows 64bit Laurenz Albe 08:05
Re: Building tds_fdw Extension for Windows 64bit Igal @ Lucee.org 15:24
Re: Building tds_fdw Extension for Windows 64bit Tom Lane 15:40
Logical decoding error Mark Fletcher 16:34
Hot Standby syntax error nmmulla 16:38
syntax error Noor Mulla 16:54
Re: Logical decoding error Steve Atkins 16:59
Re: Building tds_fdw Extension for Windows 64bit Igal @ Lucee.org 18:00
Re: Logical decoding error Mark Fletcher 18:03
Re: Building tds_fdw Extension for Windows 64bit Tom Lane 19:18
Re: syntax error nmmulla 20:07
EXPLAIN <query> command just hangs... Rhhh Lin 20:51
Re: EXPLAIN <query> command just hangs... Justin Pryzby 21:02
Re: EXPLAIN <query> command just hangs... Rhhh Lin 21:13
Re: EXPLAIN <query> command just hangs... Tom Lane 21:40
Re: EXPLAIN <query> command just hangs... Justin Pryzby 21:49

Nov. 3, 2017

Thread Author Time
checkpoint and recovering process use too much memory tao tony 01:43
Re: checkpoint and recovering process use too much memory Justin Pryzby 02:21
Re: checkpoint and recovering process use too much memory Andres Freund 02:35
SSL and Encryption chiru r 03:16
Re: [HACKERS] SSL and Encryption Craig Ringer 03:19
Re: [HACKERS] SSL and Encryption Michael Paquier 04:39
Re: [HACKERS] SSL and Encryption John R Pierce 04:58
Re: [HACKERS] SSL and Encryption Jeff Janes 05:12
Re: [HACKERS] SSL and Encryption John R Pierce 05:22
Re: EXPLAIN <query> command just hangs... Peter J. Holzer 08:49
Re: [HACKERS] SSL and Encryption Daniele Varrazzo 10:49
Postgresql.conf not found Neto pr 11:51
Re: Postgresql.conf not found Stefan Fercot 11:57
Re: Postgresql.conf not found Andreas Kretschmer 12:20
[No subject] K. Brannen 14:35
Re: [HACKERS] SSL and Encryption Jeff Janes 16:12
Re: Postgres 10 manual breaks links with anchors Peter Eisentraut 18:24
Re: [HACKERS] SSL and Encryption Daniele Varrazzo 18:50
Adding 'serial' to existing column Robert Lakes 20:38
Re: Adding 'serial' to existing column Tom Lane 20:47
Re: EXPLAIN <query> command just hangs... Rhhh Lin 20:55
Re: Adding 'serial' to existing column rob stone 21:07
Re: EXPLAIN <query> command just hangs... Rhhh Lin 21:12
Re: EXPLAIN <query> command just hangs... Justin Pryzby 21:33
Re: gin index trouble Rob Sargent 23:11

Nov. 4, 2017

Thread Author Time
Re: EXPLAIN <query> command just hangs... Rhhh Lin 02:27
Re: Rhhh Lin 02:28
Re: EXPLAIN <query> command just hangs... Rhhh Lin 02:29
Re: EXPLAIN <query> command just hangs... Tom Lane 16:35
A possible use case for: "INSERT .. ON CONFLICT DO SELECT [FOR ..]" Marc-Olaf Jaschke 16:41
pg_logical/snapshots directory Mark Fletcher 17:45

Nov. 5, 2017

Thread Author Time
ERROR: invalid input syntax for integer: "INSERT" Robert Lakes 03:57
Re: ERROR: invalid input syntax for integer: "INSERT" David G. Johnston 04:05
Runtime analysis Neto pr 12:49
Re: A possible use case for: "INSERT .. ON CONFLICT DO SELECT [FOR ..]" Marko Tiikkaja 15:06
Re: Runtime analysis Tom Lane 15:41
Re: pg_logical/snapshots directory Mark Fletcher 16:11
Query Improvement?? Bret Stern 21:39

Nov. 6, 2017

Thread Author Time
Re: checkpoint and recovering process use too much memory tao tony 01:11
Combine multiple text search configuration hmidi slim 08:17
xmin increasing within a transaction block? Luca Ferrari 09:36
Naming conventions for column names Sachin Kotwal 10:33
Re: Naming conventions for column names Sachin Kotwal 10:36
Re: Naming conventions for column names Peter Eisentraut 12:51
Re: xmin increasing within a transaction block? Alvaro Herrera 12:53
Postgresql 9.3 service doesn't start on RedHat Linux 6.8 Vikas Sharma 13:28
Re: xmin increasing within a transaction block? Andres Freund 13:29
Re: Naming conventions for column names Sachin Kotwal 13:33
Re: xmin increasing within a transaction block? Luca Ferrari 13:59
Re: xmin increasing within a transaction block? Luca Ferrari 14:05
Re: xmin increasing within a transaction block? Alvaro Herrera 14:10
Converting AGE() to something human readable Ron Johnson 14:14
Re: xmin increasing within a transaction block? Tom Lane 14:26
Re: Naming conventions for column names Tom Lane 14:33
Re: Naming conventions for column names Rakesh Kumar 14:51
Re: Naming conventions for column names Sachin Kotwal 14:53
Re: xmin increasing within a transaction block? Luca Ferrari 15:01
Re: Naming conventions for column names Karsten Hilbert 15:04
Re: Naming conventions for column names Melvin Davidson 15:16
Re: Naming conventions for column names Alvaro Herrera 15:25
Re: Postgresql 9.3 service doesn't start on RedHat Linux 6.8 John R Pierce 18:18
idle in transaction, why Rob Sargent 19:32
Re: Combine multiple text search configuration Johannes Graën 19:43
Re: Combine multiple text search configuration Johannes Graën 19:46
postmaster deadlock while logging after syslogger exited David Pacheco 19:47
Re: idle in transaction, why David G. Johnston 20:09
Re: idle in transaction, why Tom Lane 20:17
Re: idle in transaction, why Rob Sargent 20:18
Re: idle in transaction, why Rob Sargent 20:24
Re: postmaster deadlock while logging after syslogger exited Tom Lane 20:35
Re: idle in transaction, why Tom Lane 20:41
Re: idle in transaction, why Rob Sargent 20:50
Re: idle in transaction, why Rob Sargent 21:03
Re: idle in transaction, why Merlin Moncure 21:38
Re: postmaster deadlock while logging after syslogger exited David Pacheco 21:46
Re: idle in transaction, why Rob Sargent 21:53
Re: idle in transaction, why Rob Sargent 22:09
Invalid client charset when using TDS_FDW Igal @ Lucee.org 22:16
Re: the database system is shutting down - terminating walsender process due to replication timeout Zarko Aleksic 22:52

Nov. 7, 2017

Thread Author Time
Re: Naming conventions for column names Sachin Kotwal 05:30
Incremental refresh - Materialized view Krithika Venkatesh 06:38
Re: Incremental refresh - Materialized view John R Pierce 07:06
Re: idle in transaction, why Thomas Kellerer 07:16
Re: Combine multiple text search configuration hmidi slim 07:27
Re: Incremental refresh - Materialized view Krithika Venkatesh 07:34
Re: Incremental refresh - Materialized view Laurenz Albe 07:54
Re: Incremental refresh - Materialized view Rakesh Kumar 12:08
Re: idle in transaction, why Rob Sargent 14:44
Re: Incremental refresh - Materialized view Melvin Davidson 15:05
Re: Naming conventions for column names David G. Johnston 15:07
Block duplications in a shared buffers pinker 15:15
Re: Block duplications in a shared buffers Tom Lane 15:27
Re: Naming conventions for column names Alvaro Herrera 15:41
Re: idle in transaction, why Scott Marlowe 16:09
Re: idle in transaction, why Rob Sargent 16:22
Re: Block duplications in a shared buffers pinker 17:16
Re: Block duplications in a shared buffers pinker 17:24
Re: Incremental refresh - Materialized view John R Pierce 18:07
standby stop replicating, then picked back up chris kim 20:04
Fwd: standby stop replicating, then picked back up chris kim 20:08
Re: Fwd: standby stop replicating, then picked back up Laurenz Albe 20:17
Re: idle in transaction, why Rob Sargent 23:16

Nov. 8, 2017

Thread Author Time
Re: Fwd: standby stop replicating, then picked back up Michael Paquier 00:32
Re: Naming conventions for column names Michael Paquier 00:43
DROP INDEX hangs Arnaud L. 09:19
filter records by substring match of an postgresql array column Arup Rakshit 10:32
Re: filter records by substring match of an postgresql array column Jeff Janes 11:49
Re: filter records by substring match of an postgresql array column Arup Rakshit 12:28
Re: Can master and slave on different PG versions? rammohan ganapavarapu 16:17
Re: filter records by substring match of an postgresql array column Jeff Janes 19:10
Because PostgreSQL is compiling in old versions of OS? DrakoRod 19:28
Migrating plattaform Valdir Kageyama 19:38
Re: Because PostgreSQL is compiling in old versions of OS? José María Terry Jiménez 20:11
wal configuration setting for fast streaming replication with logical decoding Weiping Qu 20:52
Re: Because PostgreSQL is compiling in old versions of OS? John R Pierce 21:34
database size changed after restoring using pg_restore Dylan Luong 22:59
Re: database size changed after restoring using pg_restore Andreas Joseph Krogh 23:23
Re: database size changed after restoring using pg_restore John R Pierce 23:24

Nov. 9, 2017

Thread Author Time
Migrating money column from MS SQL Server to Postgres Igal @ Lucee.org 00:32
Re: Migrating money column from MS SQL Server to Postgres Tom Lane 00:45
Re: Migrating money column from MS SQL Server to Postgres David G. Johnston 00:45
Re: Migrating money column from MS SQL Server to Postgres Allan Kamau 00:52
Re: Migrating money column from MS SQL Server to Postgres Igal @ Lucee.org 01:11
Re: Migrating money column from MS SQL Server to Postgres Allan Kamau 01:27
Re: Migrating money column from MS SQL Server to Postgres Igal @ Lucee.org 02:25
Re: Migrating money column from MS SQL Server to Postgres Igal @ Lucee.org 06:58
Re: Can master and slave on different PG versions? Shreeyansh Dba 07:45
PostgreSQL 9.5 showing unexpected behavior when installed with different locale other than default Mayank Agrawal 07:54
Re: Combine multiple text search configuration Johannes Graën 08:09
Fwd: Re: Combine multiple text search configuration Johannes Graën 08:11
Re: Migrating money column from MS SQL Server to Postgres Allan Kamau 08:59
Re: Combine multiple text search configuration Aleksandr Parfenov 09:28
Oracle to PostgreSQL Brahmam Eswar 10:34
Re: Oracle to PostgreSQL Laurenz Albe 11:18
Postgresql and github Poul Kristensen 11:27
Re: Oracle to PostgreSQL Brahmam Eswar 11:31
Re: Postgresql and github Michael Paquier 11:39
Re: Oracle to PostgreSQL Laurenz Albe 11:40
Re: Oracle to PostgreSQL Felix Kunde 12:16
Re: Migrating money column from MS SQL Server to Postgres Adam Brusselback 14:22
Migrating plattaform Valdir Kageyama 15:45
Re: Postgresql and github Igal @ Lucee.org 16:18
Re: Migrating money column from MS SQL Server to Postgres Merlin Moncure 16:19
Re: Can master and slave on different PG versions? rammohan ganapavarapu 16:22
Index not used when using expression Dingyuan Wang 16:27
Re: Index not used when using expression Tom Lane 16:33
Re: Migrating plattaform Jaime Soler 17:17
Re: Postgresql and github Poul Kristensen 17:37
Re: Postgresql and github Nicklas Avén 17:52
Re: Postgresql and github Steve Atkins 18:00
Re: Postgresql and github Poul Kristensen 18:45
OpeSSL - PostgreSQL chiru r 21:59
Re: OpeSSL - PostgreSQL John R Pierce 22:06
Re: OpeSSL - PostgreSQL Tom Lane 22:26
Re: [HACKERS] OpeSSL - PostgreSQL Joe Conway 22:46
Re: Postgresql and github Jeremy Schneider 23:00
Re: Migrating money column from MS SQL Server to Postgres Igal @ Lucee.org 23:41

Nov. 10, 2017

Thread Author Time
Re: [HACKERS] OpeSSL - PostgreSQL chiru r 01:52
Re: [HACKERS] OpeSSL - PostgreSQL Joe Conway 02:47
Spelling dictionaries hmidi slim 09:16
Re: Spelling dictionaries Arthur Zakirov 09:36
Client Authentication methods chiru r 13:25
Re: Client Authentication methods Berend Tober 13:56

Browse Archives

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