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

Jan. 1, 2019

Thread Author Time
Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL Adrian Klaver 18:40
Re: Thoughts on row-level security for webapps? Adrian Klaver 18:49
Query help Chuck Martin 19:05
RE: Query help Scot Kreienkamp 19:14
Re: Query help John W Higgins 19:26
Query help David G. Johnston 19:28
Re: Query help David G. Johnston 19:29
Re: Query help Adrian Klaver 19:40
Re: Query help Adrian Klaver 19:44
Re: Query help David G. Johnston 20:05
Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL Brent Wood 20:53
Re: Query help Adrian Klaver 22:10

Jan. 2, 2019

Thread Author Time
Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL chiru r 00:18
Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL Rob Sargent 01:21
Re: [GENERAL] Incremental refresh - Materialized view Nguyễn Trần Quốc Vinh 08:44
Re: Thoughts on row-level security for webapps? Achilleas Mantzios 10:31
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Mark 12:15
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Mark 12:27
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Ron 14:04
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Mark 15:28
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Ron 15:44
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Mark 16:04
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Tom Lane 16:11
Implementing standard SQL's DOMAIN constraint Rich Shepard 17:12
Re: Implementing standard SQL's DOMAIN constraint David G. Johnston 17:34
Re: Implementing standard SQL's DOMAIN constraint Rich Shepard 17:47
Re: Implementing standard SQL's DOMAIN constraint David G. Johnston 17:52
Re: Implementing standard SQL's DOMAIN constraint Rich Shepard 17:58
Re: Implementing standard SQL's DOMAIN constraint David G. Johnston 18:02
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Mark 18:04
Re: Implementing standard SQL's DOMAIN constraint [RESOLVED] Rich Shepard 18:05
Re: Implementing standard SQL's DOMAIN constraint [RESOLVED] Ron 18:13
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Tom Lane 18:19
RE: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL Kevin Brannen 18:25
Re: Implementing standard SQL's DOMAIN constraint [RESOLVED] Rich Shepard 18:28
Default for date field: today vs CURRENT_DATE Rich Shepard 21:49
Re: Default for date field: today vs CURRENT_DATE Tom Lane 22:01
Re: Default for date field: today vs CURRENT_DATE [RESOLVED] Rich Shepard 22:12

Jan. 3, 2019

Thread Author Time
[unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209} Mihalidesová Jana 10:59
Re: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209} Pavel Stehule 11:26
Re: Memory exhaustion due to temporary tables? Thomas Carroll 11:55
RE: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209} Mihalidesová Jana 11:59
Re: [unixODBC]Unrecognized key passed to SQLGetInfo. {S1C00,NativeErr = 209} Pavel Stehule 12:11
Re: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL chiru r 17:23
query with regular expression Glenn Schultz 17:57
Re: query with regular expression David G. Johnston 18:58
Re: query with regular expression Glenn Schultz 20:31
Re: Memory exhaustion due to temporary tables? Tom Lane 20:38
Re: getting pg_basebackup to use remote destination Stephen Frost 20:46
Re: Thoughts on row-level security for webapps? Stephen Frost 20:49
Re: Thoughts on row-level security for webapps? Siegfried Bilstein 21:04
Re: getting pg_basebackup to use remote destination Chuck Martin 23:41

Jan. 4, 2019

Thread Author Time
SPI Interface to Call Procedure with Transaction Control Statements Jack LIU 07:14
Function `set_config` doesn't work in with query? Zexuan Luo 09:36
Re: Function `set_config` doesn't work in with query? Rene Romero Benavides 10:18
Re: Function `set_config` doesn't work in with query? Andrew Gierth 10:27
Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger Kristjan Tammekivi 10:45
RE: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger Charles Clavadetscher 10:56
Re: Function `set_config` doesn't work in with query? Zexuan Luo 10:57
Use bytearray for blobs or not? Thomas Güttler 11:41
Refresh using barman Rijo Roy 11:42
Re: Use bytearray for blobs or not? Achilleas Mantzios 11:48
Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger Kristjan Tammekivi 12:20
Re: Use bytearray for blobs or not? Thomas Güttler 13:15
Multiple postgresql clusters with same version and separate binaries Erika Knihti-Van Driessche 14:21
Re: Multiple postgresql clusters with same version and separate binaries MichaelDBA 14:32
Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger Adrian Klaver 14:32
Re: Multiple postgresql clusters with same version and separate binaries Adrian Klaver 14:36
Re: Multiple postgresql clusters with same version and separate binaries Ray O'Donnell 14:46
Re: Multiple postgresql clusters with same version and separate binaries Shreeyansh Dba 14:50
Re: Multiple postgresql clusters with same version and separate binaries Ron 15:03
RE: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL Kevin Brannen 15:08
Re: Multiple postgresql clusters with same version and separate binaries Erika Knihti-Van Driessche 15:30
Re: Multiple postgresql clusters with same version and separate binaries Adrian Klaver 15:38
Re: Multiple postgresql clusters with same version and separate binaries Ron 15:38
Re: Multiple postgresql clusters with same version and separate binaries Rui DeSousa 15:53
Re: Multiple postgresql clusters with same version and separate binaries MichaelDBA 15:59
Re: Use bytearray for blobs or not? Rob Sargent 16:02
Showing table comments with psql Mark Jeffcoat 16:02
(Again) Column Store on PostGreSQL Simon AUBERT 16:12
Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger Tom Lane 16:44
Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger Pavel Stehule 16:47
Comparing dates in DDL Rich Shepard 16:53
Re: Showing table comments with psql Pavel Stehule 17:00
Re: Comparing dates in DDL Igor Korot 17:12
Re: Comparing dates in DDL Andreas Kretschmer 17:16
Re: Comparing dates in DDL Rob Sargent 17:18
Re: Comparing dates in DDL Rich Shepard 17:21
Re: Comparing dates in DDL David G. Johnston 17:24
Re: (Again) Column Store on PostGreSQL legrand legrand 17:25
Re: Comparing dates in DDL Rich Shepard 17:26
Re: Comparing dates in DDL Rich Shepard 17:30
Re: Comparing dates in DDL Rich Shepard 17:32
Re: Showing table comments with psql Mark Jeffcoat 17:32
Re: Comparing dates in DDL David G. Johnston 17:33
Re: (Again) Column Store on PostGreSQL Pavel Stehule 17:35
Re: Comparing dates in DDL Rich Shepard 17:36
Re: Comparing dates in DDL David G. Johnston 17:48
Re: Comparing dates in DDL Rob Sargent 17:53
Re: Comparing dates in DDL Rich Shepard 17:59
Re: Comparing dates in DDL Andreas Kretschmer 20:30
32-bit supporting binaries for version 11 Ken Benson 20:44
Re: Comparing dates in DDL Rich Shepard 21:12
Re: Comparing dates in DDL Rich Shepard 21:21
Re: Comparing dates in DDL David G. Johnston 21:52
Re: Comparing dates in DDL Rich Shepard 22:19
Immutable way to cast timestamp TEXT to DATE? (for index) Ken Tanzer 22:21
Re: Immutable way to cast timestamp TEXT to DATE? (for index) Adrian Klaver 22:27
Re: Immutable way to cast timestamp TEXT to DATE? (for index) Ken Tanzer 22:37
Re: Immutable way to cast timestamp TEXT to DATE? (for index) Andrew Gierth 22:54
Re: Immutable way to cast timestamp TEXT to DATE? (for index) Ken Tanzer 23:20
RE: Immutable way to cast timestamp TEXT to DATE? (for index) Kevin Brannen 23:46
Re: Comparing dates in DDL Jeremy Finzel 23:49
Re: Comparing dates in DDL Rich Shepard 23:59

Jan. 5, 2019

Thread Author Time
ALTER TABLE with multiple SET NOT NULL Allison Kaptur 00:28
Re: ALTER TABLE with multiple SET NOT NULL Tom Lane 01:05
Re: Immutable way to cast timestamp TEXT to DATE? (for index) Andrew Gierth 01:09
Get LSN at which a cluster was promoted on previous timeline Jeremy Finzel 01:36
Re: Get LSN at which a cluster was promoted on previous timeline Jerry Sievers 02:41
Re: Get LSN at which a cluster was promoted on previous timeline Michael Paquier 03:54
Dropping and creating a trigger Mitar 09:59
Re: Dropping and creating a trigger Ron 10:16
Adding LEFT JOIN to a query has increased execution time 10 times Alexander Farber 16:43
Re: Dropping and creating a trigger Adrian Klaver 17:35
Re: Adding LEFT JOIN to a query has increased execution time 10 times Andrew Gierth 20:18
Re: Adding LEFT JOIN to a query has increased execution time 10 times Alexander Farber 20:19
Re: Adding LEFT JOIN to a query has increased execution time 10 times Alexander Farber 20:29
Re: Dropping and creating a trigger 📎 Mitar 22:25

Jan. 6, 2019

Thread Author Time
Adding new collations after pg_upgrade? rihad 08:08
About SSL connection John Mikel 14:10
Is it impolite to dump a message Thiemo Kellner 14:34
Re: Is there something wrong with my test case? Peter J. Holzer 14:52
Re: Is it impolite to dump a message Stephen Frost 15:33
Re: Adding new collations after pg_upgrade? Tom Lane 15:51
Re: Adding new collations after pg_upgrade? rihad 15:57
Re: Adding new collations after pg_upgrade? rihad 16:05
Re: Adding new collations after pg_upgrade? rihad 16:08
Re: Is it impolite to dump a message Ron 16:56
Re: About SSL connection Ron 16:59
Re: Adding LEFT JOIN to a query has increased execution time 10 times Alexander Farber 19:29
Re: About SSL connection Adrian Klaver 20:01
Re: Adding LEFT JOIN to a query has increased execution time 10 times legrand legrand 20:37
Re: Adding LEFT JOIN to a query has increased execution time 10 times Andrew Gierth 23:00

Jan. 7, 2019

Thread Author Time
Re: Is there something wrong with my test case? David Rowley 03:21
Re: Watching for view changes Mitar 05:40
Optimizing the same PREPAREd static query (without parameters) Mitar 05:53
Re: Use bytearray for blobs or not? Achilleas Mantzios 07:35
Re: Optimizing the same PREPAREd static query (without parameters) David Rowley 08:08
Re: Optimizing the same PREPAREd static query (without parameters) Mitar 08:40
Re: Optimizing the same PREPAREd static query (without parameters) David Rowley 08:44
Re: Use bytearray for blobs or not? Thomas Güttler 10:12
Re: Is there something wrong with my test case? Thiemo Kellner 10:30
Re: Is there something wrong with my test case? Thiemo Kellner 10:43
Re: Is there something wrong with my test case? Fabio Pardi 10:53
Re: Is there something wrong with my test case? Thiemo Kellner 12:06
Which queries have run query trace form .exe. Vimal Kanzariya 12:52
Re: Which queries have run query trace form .exe. Ron 13:49
Not sure which part of the query needs optimization Alexander Farber 13:50
Re: Adding LEFT JOIN to a query has increased execution time 10 times Alexander Farber 13:56
Re: Multiple postgresql clusters with same version and separate binaries Stéphane KANSCHINE 14:36
Re: About SSL connection Adrian Klaver 14:44
Re: Optimizing the same PREPAREd static query (without parameters) Mitar 17:45
Re: Not sure which part of the query needs optimization Andrew Gierth 19:40
Re: Memory exhaustion due to temporary tables? Thomas Carroll 20:54

Jan. 8, 2019

Thread Author Time
Re: Multiple postgresql clusters with same version and separate binaries Erika Knihti-Van Driessche 07:13
Re: Multiple postgresql clusters with same version and separate binaries Stéphane KANSCHINE 08:50
Re: Multiple postgresql clusters with same version and separate binaries Erika Knihti-Van Driessche 09:08
(multiplatform) replication problem W.P. 15:48
multiple configurations with repmgr ROS Didier 16:17
jdbc PGCopyOutputStream close() v. endCopy() Rob Sargent 21:29
Re: Optimizing the same PREPAREd static query (without parameters) David Rowley 22:39

Jan. 9, 2019

Thread Author Time
Re: multiple configurations with repmgr Nicolas Karolak 06:51
Re: ALTER TABLE with multiple SET NOT NULL Sergei Kornilov 11:11
Re: (multiplatform) replication problem Jeff Janes 16:27
Re: Pulling data from Postgres DB table for every 5 seconds. github kran 17:02
Re: Pulling data from Postgres DB table for every 5 seconds. Rob Sargent 17:10
Re: Pulling data from Postgres DB table for every 5 seconds. Ron 17:16
Re: Pulling data from Postgres DB table for every 5 seconds. github kran 17:21
Re: multiple configurations with repmgr Martín Marqués 17:23
Re: Pulling data from Postgres DB table for every 5 seconds. Mark Fletcher 17:24
postgres operational Steve Clark 17:58
Re: Pulling data from Postgres DB table for every 5 seconds. Rob Sargent 18:01
RE: postgres operational Scot Kreienkamp 18:02
Re: Pulling data from Postgres DB table for every 5 seconds. github kran 18:10
Re: Pulling data from Postgres DB table for every 5 seconds. github kran 18:11
Re: postgres operational Martín Marqués 18:19
Re: Pulling data from Postgres DB table for every 5 seconds. Rob Sargent 18:25
Re: Pulling data from Postgres DB table for every 5 seconds. Mark Fletcher 18:35
Re: postgres operational Ron 20:38
Re: Pulling data from Postgres DB table for every 5 seconds. github kran 20:50
Re: Pulling data from Postgres DB table for every 5 seconds. github kran 20:58
Re: Pulling data from Postgres DB table for every 5 seconds. Mark Fletcher 23:22
Re: Pulling data from Postgres DB table for every 5 seconds. Martín Marqués 23:40
Re: postgres operational Martín Marqués 23:43

Jan. 10, 2019

Thread Author Time
CREATE OR REPLACE MATERIALIZED VIEW Aidan Samuel 00:25
Re: CREATE OR REPLACE MATERIALIZED VIEW Tom Lane 01:13
Re: CREATE OR REPLACE MATERIALIZED VIEW Aidan Samuel 03:10
log level of "drop cascade" lists Willy-Bas Loos 11:28
Lost synchronization with server: got message type"0" , length 879046704 Arun Menon 12:19
Postgres wont remove useless joins, when the UNIQUE index is partial 📎 Kim Rose Carlsen 12:30

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 31