pgsql-general since 2019-01-08 00:00

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

Browse Archives

Prev | Next

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
Re: Pulling data from Postgres DB table for every 5 seconds. Tony Shelver 12:41
Re: jdbc PGCopyOutputStream close() v. endCopy() Dave Cramer 13:09
Re: Not sure which part of the query needs optimization Alexander Farber 13:48
Re: jdbc PGCopyOutputStream close() v. endCopy() Rob Sargent 14:13
Re: Error on Windows Laurenz Albe 14:44
Re: log level of "drop cascade" lists Adrian Klaver 15:44
Re: log level of "drop cascade" lists Tom Lane 16:04
Benchmark of using JSON to transport query results in node.js Mitar 21:51

Jan. 11, 2019

Thread Author Time
Re: Benchmark of using JSON to transport query results in node.js Tony Shelver 11:06
Re: log level of "drop cascade" lists Willy-Bas Loos 12:50
How to always run UPDATE FROM despite missing records in the source table? Alexander Farber 12:50
RE: How to always run UPDATE FROM despite missing records in the source table? Kevin Brannen 15:42
Re: How to always run UPDATE FROM despite missing records in the source table? Adrian Klaver 15:55
Re: How to always run UPDATE FROM despite missing records in the source table? Andrew Gierth 16:51
Re: Benchmark of using JSON to transport query results in node.js Mitar 18:30
Re: Benchmark of using JSON to transport query results in node.js Michel Pelletier 18:56
insert into: NULL in date column Rich Shepard 22:56
Re: insert into: NULL in date column Rob Sargent 23:05
Re: insert into: NULL in date column Rich Shepard 23:21
Re: insert into: NULL in date column Rob Sargent 23:24
Re: insert into: NULL in date column Ken Tanzer 23:34
Re: insert into: NULL in date column Rich Shepard 23:57

Jan. 12, 2019

Thread Author Time
Re: insert into: NULL in date column Rich Shepard 00:00
Re: insert into: NULL in date column David G. Johnston 00:18
Re: insert into: NULL in date column David G. Johnston 00:19
Re: insert into: NULL in date column David G. Johnston 00:23
Re: insert into: NULL in date column Adrian Klaver 01:09
Re: insert into: NULL in date column Ricardo Martin Gomez 01:52
CREATE COLLATION to match pg_collation data rihad 07:19
Re: insert into: NULL in date column Rich Shepard 13:38
Re: insert into: NULL in date column Rich Shepard 13:39
Re: insert into: NULL in date column Rich Shepard 13:43
Re: CREATE COLLATION to match pg_collation data Tom Lane 15:13
Re: insert into: NULL in date column David G. Johnston 15:53
Re: insert into: NULL in date column Rich Shepard 16:01
Re: insert into: NULL in date column David G. Johnston 16:49
Re: insert into: NULL in date column Rich Shepard 16:54
Re: insert into: NULL in date column Ricardo Martin Gomez 17:08
Re: insert into: NULL in date column David G. Johnston 17:22
Re: insert into: NULL in date column David G. Johnston 17:23
Re: insert into: NULL in date column Rich Shepard 17:33
Re: CREATE COLLATION to match pg_collation data Peter Geoghegan 18:50

Jan. 13, 2019

Thread Author Time
Static PostgreSQL Binaries (Linux + Windows) Zach van Rijn 03:57
Re: Static PostgreSQL Binaries (Linux + Windows) Brent Wood 05:04
Re: Static PostgreSQL Binaries (Linux + Windows) Pratik Parikh 05:51
Re: How to always run UPDATE FROM despite missing records in the source table? Alexander Farber 10:11
Re: How to always run UPDATE FROM despite missing records in the source table? Andrew Gierth 11:25
Re: Static PostgreSQL Binaries (Linux + Windows) Zach van Rijn 14:13
Re: Static PostgreSQL Binaries (Linux + Windows) Pratik Parikh 14:15
Re: Static PostgreSQL Binaries (Linux + Windows) Tom Lane 14:35
Question about MemoryContextRegisterResetCallback Michel Pelletier 17:00
Re: Question about MemoryContextRegisterResetCallback Tom Lane 17:30
Re: Question about MemoryContextRegisterResetCallback Michel Pelletier 18:51
Logical replication issue with row level trigger Aleš Zelený 19:41
Re: Static PostgreSQL Binaries (Linux + Windows) Zach van Rijn 19:42
Array_agg and dimensions in Array Mike Martin 23:05

Jan. 14, 2019

Thread Author Time
the installation of pgadmin4 makes me weep in frustration robert 07:58
Re: the installation of pgadmin4 makes me weep in frustration Achilleas Mantzios 08:05
repmgr and SSH ROS Didier 09:29
Re: the installation of pgadmin4 makes me weep in frustration Steve Atkins 10:24
Re: the installation of pgadmin4 makes me weep in frustration Tony Shelver 11:00
Re: the installation of pgadmin4 makes me weep in frustration William Ivanski 12:48
Re: the installation of pgadmin4 makes me weep in frustration Murtuza Zabuawala 13:49
Re: the installation of pgadmin4 makes me weep in frustration Ravi Krishna 14:14
sha512sum (program) gives different result than sha512 in PG11 Andreas Joseph Krogh 15:16
Re: sha512sum (program) gives different result than sha512 in PG11 Thomas Markus 15:18
Sv: Re: sha512sum (program) gives different result than sha512 in PG11 Andreas Joseph Krogh 15:23
pg_restore restores privileges differently from psql Sherrylyn Branchaw 18:15
Re: Question about MemoryContextRegisterResetCallback Michel Pelletier 18:56
Re: pg_restore restores privileges differently from psql Adrian Klaver 19:11
Re: pg_restore restores privileges differently from psql Sherrylyn Branchaw 20:04
Re: pg_restore restores privileges differently from psql Adrian Klaver 20:45
Re: pg_restore restores privileges differently from psql Sherrylyn Branchaw 20:57
Re: Question about MemoryContextRegisterResetCallback Tom Lane 21:09
Re: pg_restore restores privileges differently from psql Tom Lane 21:21
Re: pg_restore restores privileges differently from psql Adrian Klaver 21:24

Jan. 15, 2019

Thread Author Time
Re: (Again) Column Store on PostGreSQL Simon AUBERT 07:36
Oracke BLOB to Postgres BYTEA using ora2pg Mihalidesová Jana 08:39
Re: Oracke BLOB to Postgres BYTEA using ora2pg Pavel Stehule 08:45
repmgr and STONIT - SPLIT BAIN ROS Didier 08:54
Re: Oracke BLOB to Postgres BYTEA using ora2pg Achilleas Mantzios 09:12
RE: Oracke BLOB to Postgres BYTEA using ora2pg Mihalidesová Jana 10:13
Re: Oracke BLOB to Postgres BYTEA using ora2pg Pavel Stehule 10:37
Re: Oracke BLOB to Postgres BYTEA using ora2pg Pavel Stehule 10:56
Read consistency when using synchronous_commit=off pshadangi 10:58
Re: Read consistency when using synchronous_commit=off Fabio Pardi 11:15
Re: Read consistency when using synchronous_commit=off Fabio Pardi 11:39
Re: repmgr and STONIT - SPLIT BAIN Ian Barwick 11:41
Re: Oracke BLOB to Postgres BYTEA using ora2pg Pavel Stehule 11:44
Re: repmgr and SSH Ian Barwick 11:53
Re: Read consistency when using synchronous_commit=off Ravi Krishna 11:54
RE: Oracke BLOB to Postgres BYTEA using ora2pg Daniel Verite 11:56
RE: repmgr and SSH ROS Didier 12:36
Re: pg_restore restores privileges differently from psql Sherrylyn Branchaw 12:57
Refining query statement Rich Shepard 15:39
Re: Refining query statement Thomas Kellerer 15:47
Using psql variables in DO-blocks Andreas Joseph Krogh 15:51
Re: Refining query statement Adrian Klaver 15:54
Re: Using psql variables in DO-blocks David G. Johnston 15:56
Sv: Using psql variables in DO-blocks Andreas Joseph Krogh 16:00
Re: Refining query statement Ron 16:02
Re: Refining query statement Rich Shepard 16:26
Re: Refining query statement Rich Shepard 16:34
Re: Refining query statement Rich Shepard 16:37
Re: Refining query statement Adrian Klaver 16:41
aggregate functions are not allowed in UPDATE Alexander Farber 16:42
Re: Refining query statement Adrian Klaver 16:44
Re: aggregate functions are not allowed in UPDATE David G. Johnston 16:46
Re: aggregate functions are not allowed in UPDATE Alexander Farber 16:52
Re: aggregate functions are not allowed in UPDATE David G. Johnston 16:58
Re: Refining query statement Rich Shepard 17:17
Re: Refining query statement Thomas Kellerer 17:45
Re: Refining query statement Rob Sargent 18:31
Re: aggregate functions are not allowed in UPDATE Alexander Farber 19:17
Re: aggregate functions are not allowed in UPDATE Alexander Farber 19:23
Re: aggregate functions are not allowed in UPDATE Alexander Farber 19:42
Can anyone please provide me list of customers using postgreSQL Ramamoorthi, Meenakshi 19:42
Re: Can anyone please provide me list of customers using postgreSQL Rob Sargent 19:44
Re: aggregate functions are not allowed in UPDATE David G. Johnston 19:49
Re: Can anyone please provide me list of customers using postgreSQL David G. Johnston 19:55
RE: Can anyone please provide me list of customers using postgreSQL Igor Neyman 20:00
Re: aggregate functions are not allowed in UPDATE Alexander Farber 20:26

Jan. 16, 2019

Thread Author Time
Re: Can anyone please provide me list of customers using postgreSQL Daevor The Devoted 00:57
Re: Read consistency when using synchronous_commit=off pshadangi 05:02
Re: Read consistency when using synchronous_commit=off Ravi Krishna 05:16
Re: Oracke BLOB to Postgres BYTEA using ora2pg Pavel Stehule 05:50
Re: Read consistency when using synchronous_commit=off pshadangi 08:27
Re: Read consistency when using synchronous_commit=off Ron 08:46
lost "left join" Олег Самойлов 10:54
Sv: lost "left join" Andreas Joseph Krogh 11:09
Re: Can anyone please provide me list of customers using postgreSQL Andreas Kretschmer 12:00
Re: lost "left join" Andrew Gierth 12:24
Weird behaviour of ROLLUP/GROUPING Guillaume Lelarge 12:51
Re: Weird behaviour of ROLLUP/GROUPING Pavel Stehule 13:15
problem in regard to hot standby aaaaaa 14:36
Re: Weird behaviour of ROLLUP/GROUPING Andrew Gierth 15:55
Re: Array_agg and dimensions in Array Alexey Bashtanov 16:34
Re: Weird behaviour of ROLLUP/GROUPING Andrew Gierth 16:40
Re: Weird behaviour of ROLLUP/GROUPING Guillaume Lelarge 17:05
Varlena with recursive data structures? Sam Patterson 22:08
Re: Varlena with recursive data structures? Tom Lane 22:22

Jan. 17, 2019

Thread Author Time
Re: Varlena with recursive data structures? George Neuner 03:15
Re: Can anyone please provide me list of customers using postgreSQL Brent Wood 03:17
Question about array_to_string()'s behavior and the behavior might be changed in the future or not Egashira, Yusuke 06:50
Re: Question about array_to_string()'s behavior and the behavior might be changed in the future or not Andrew Gierth 06:56
Re: Weird behaviour of ROLLUP/GROUPING Andrew Gierth 07:27
RE: Question about array_to_string()'s behavior and the behavior might be changed in the future or not Egashira, Yusuke 07:53
Re: Weird behaviour of ROLLUP/GROUPING Guillaume Lelarge 08:23
Re: Barman versus pgBackRest Achilleas Mantzios 11:09
Postgres Automated Failover AI Rumman 13:32
Re: Postgres Automated Failover Deepika S Gowda 13:58
Re: Postgres Automated Failover Jehan-Guillaume (ioguix) de Rorthais 14:06
Re: Barman versus pgBackRest Jehan-Guillaume (ioguix) de Rorthais 14:12
Re: Postgres Automated Failover Fabio Pardi 14:29
RE: Postgres Automated Failover ROS Didier 14:32
Re: Barman versus pgBackRest Achilleas Mantzios 15:15
pgbouncer Nicola Contu 15:18
Re: pgbouncer David G. Johnston 15:32
Identifying comments Rich Shepard 15:37
Re: Identifying comments [ANSWERED] Rich Shepard 15:39
Re: Identifying comments [ANSWERED] David G. Johnston 15:41
Re: pgbouncer Fabio Pardi 16:06
Re: Refining query statement Rich Shepard 16:14
Re: pgbouncer Nicola Contu 16:15

Browse Archives

Prev | Next