pgsql-general since 2017-08-30 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

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

Browse Archives

Prev | Next

Aug. 30, 2017

Thread Author Time
Re: Serializable Isolation and read/write conflict with index and different keys Luca Looz 06:45
Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Christoph Berg 11:17
Veritas cluster management Ron Johnson 13:43
Re: Veritas cluster management Scott Mead 13:48
Re: Veritas cluster management Ron Johnson 13:54
Re: Serializable Isolation and read/write conflict with index and different keys Luca Looz 16:37
Re: plpython2.dll missing from Enterprise DB Postgres distribution Alan Millington 17:40

Aug. 31, 2017

Thread Author Time
clustered index benchmark comparing Postgresql vs Mariadb =?utf-8?B?7Jyg7IOB7KeA?= 02:03
Re: clustered index benchmark comparing Postgresql vs Mariadb Melvin Davidson 03:24
Re: clustered index benchmark comparing Postgresql vs Mariadb Thomas Kellerer 06:13
Table create time hamann.w 06:56
Re: Table create time Charles Clavadetscher 07:08
Re: Table create time Achilleas Mantzios 07:28
How to check streaming replication status Condor 07:35
Re: How to check streaming replication status Glyn Astill 08:24
Re: How to check streaming replication status Condor 08:41
Re: How to check streaming replication status Glyn Astill 09:14
ERROR: Undefined Reference to 📎 Stefan Wagner 09:50
Re: Table create time hamann.w 11:03
Re: How to check streaming replication status Condor 11:45
Try pglogical with postgres 9.6 basti 12:24
Re: Table create time David G. Johnston 12:29
Re: Table create time Achilleas Mantzios 13:12
Re: Table create time Melvin Davidson 13:21
Re: Table create time Achilleas Mantzios 13:45
Re: Table create time Michael Paquier 14:54
Re: Table create time Tom Lane 15:19
Re: Table create time Melvin Davidson 15:20
Re: Table create time Michael Paquier 15:26
Re: Table create time Achilleas Mantzios 15:26
Re: Table create time Melvin Davidson 15:27
Re: clustered index benchmark comparing Postgresql vs Mariadb Merlin Moncure 15:29
Re: Table create time Melvin Davidson 15:46
pgadmin - import a CSV with nulls? George Neuner 20:04
Re: pgadmin - import a CSV with nulls? David G. Johnston 20:20
Re: pgadmin - import a CSV with nulls? George Neuner 20:46
Problem with Lateral ? benj.dev 21:15
Re: Problem with Lateral ? Tom Lane 22:42

Sept. 1, 2017

Thread Author Time
Re: Table create time 📎 Melvin Davidson 00:53
RemoveIPC problem scott ribe 03:06
Re: RemoveIPC problem Tom Lane 03:08
Re: RemoveIPC problem scott ribe 03:10
Re: RemoveIPC problem Michael Paquier 03:48
Re: RemoveIPC problem scott ribe 03:49
Issue with json_agg() and ordering Bob Jones 08:11
pglogical bidirectional replication of sequences Peter J. Holzer 08:29
Re: Issue with json_agg() and ordering Charles Clavadetscher 11:22
Re: pglogical bidirectional replication of sequences Rob Sargent 15:57
Re: pglogical bidirectional replication of sequences Peter J. Holzer 17:28
Re: Issue with json_agg() and ordering Merlin Moncure 18:10
Re: pglogical bidirectional replication of sequences Peter J. Holzer 18:17
Re: Issue with json_agg() and ordering Bob Jones 21:17
Fields re-ordered on JOIN with * and USING Ken Tanzer 21:25
Strange SQL result - any ideas. Paul Linehan 22:08
Re: Strange SQL result - any ideas. Tom Lane 23:01

Sept. 2, 2017

Thread Author Time
Re: Fields re-ordered on JOIN with * and USING David G. Johnston 00:19
Re: Fields re-ordered on JOIN with * and USING Tom Lane 01:04
Re: Fields re-ordered on JOIN with * and USING Tom Lane 01:14
Re: Fields re-ordered on JOIN with * and USING Ken Tanzer 01:45
Numeric numbers Олег Самойлов 14:16
Re: Numeric numbers Francisco Olarte 15:54
Re: Numeric numbers Melvin Davidson 16:10
Re: Numeric numbers Vincenzo Romano 16:11
Re: Numeric numbers Vincenzo Romano 16:20
Re: Numeric numbers Scott Marlowe 16:31
Re: Numeric numbers Олег Самойлов 16:39
Re: Numeric numbers Francisco Olarte 16:55
Re: Numeric numbers Francisco Olarte 16:58
Re: Numeric numbers Олег Самойлов 17:04
pgFormatter v2.1 has been released Gilles Darold 17:10
Re: Numeric numbers Francisco Olarte 17:52
Re: Numeric numbers David G. Johnston 18:41
Re: Numeric numbers Олег Самойлов 19:18
Re: Numeric numbers Tom Lane 20:20
ENUM type size Олег Самойлов 20:23
Re: Numeric numbers Олег Самойлов 21:25
Re: ENUM type size Tom Lane 22:06
Re: ENUM type size Олег Самойлов 23:13

Sept. 3, 2017

Thread Author Time
Re: Strange SQL result - any ideas. Nico Williams 22:11
Re: Create Action for psql when NOTIFY Recieved Nico Williams 22:32
Re: Create Action for psql when NOTIFY Recieved Nico Williams 22:37

Sept. 4, 2017

Thread Author Time
Re: Create Action for psql when NOTIFY Recieved Nico Williams 03:02
Undefined Reference 📎 Stefan Wagner 09:32
Surprising locking behavior with CTE, FOR SHARE, and UPDATE Seamus Abshere 20:23
Re: Create Action for psql when NOTIFY Recieved Steve Atkins 21:18

Sept. 5, 2017

Thread Author Time
What's the best way in postgres to use ANY() with LIKE '%'? Ryan Murphy 02:10
hidden maintenance_work_mem limitations of a Windows build reugen1984 02:37
Re: What's the best way in postgres to use ANY() with LIKE '%'? Tom Lane 03:09
Re: What's the best way in postgres to use ANY() with LIKE '%'? Ryan Murphy 03:26
Re: What's the best way in postgres to use ANY() with LIKE '%'? Tom Lane 03:31
Re: What's the best way in postgres to use ANY() with LIKE '%'? Ryan Murphy 03:42
Re: Create Action for psql when NOTIFY Recieved Nico Williams 05:25
Not possible to compare regrole in a view query? Glen Huang 06:53
CREATE TABLE LIKE including all not including storage parameters? Milen Blagojevic 08:56
Re: CREATE TABLE LIKE including all not including storage parameters? Achilleas Mantzios 09:45
Re: CREATE TABLE LIKE including all not including storage parameters? Michael Paquier 10:26
Re: CREATE TABLE LIKE including all not including storage parameters? Achilleas Mantzios 10:34
Re: Not possible to compare regrole in a view query? Tom Lane 12:07
Re: Not possible to compare regrole in a view query? Glen Huang 12:22
Re: What's the best way in postgres to use ANY() with LIKE '%'? Hellmuth Vargas 13:01
Re: What's the best way in postgres to use ANY() with LIKE '%'? Ryan Murphy 14:19
Re: What's the best way in postgres to use ANY() with LIKE '%'? Thomas Kellerer 14:41
Re: Create Action for psql when NOTIFY Recieved Steve Atkins 15:19
Re: Create Action for psql when NOTIFY Recieved Nico Williams 16:29
Postgresql init and cleanup module functions Yan Pas 17:15
Accessiing database from inside of postgresql C function Yan Pas 17:21
Re: Accessiing database from inside of postgresql C function Tom Lane 17:32
BDR, wal segment has been removed, is it possible move forward? milist ujang 17:52
Re: Postgresql init and cleanup module functions Andres Freund 18:28

Sept. 6, 2017

Thread Author Time
Re: BDR, wal segment has been removed, is it possible move forward? Craig Ringer 00:21
Re: BDR, wal segment has been removed, is it possible move forward? milist ujang 00:47
Postgres logs showing error after replication Vijay Chaudhery 04:09
Re: Postgres logs showing error after replication Tatsuo Ishii 04:32
Re: Postgres logs showing error after replication Vijay Chaudhery 04:40
Re: Postgres logs showing error after replication Tatsuo Ishii 05:00
Re: Postgres logs showing error after replication Vijay Chaudhery 05:16
Inconsistent Postgres error when installing our product containing PostgreSQL 9.3.4 Diags101 07:13
Re: BDR, wal segment has been removed, is it possible move forward? Craig Ringer 09:07
Dealing with number formats when server and client are different locales Rob Northcott 10:42
Re: Postgres logs showing error after replication Vick Khera 11:09
Re: Postgresql init and cleanup module functions Yan Pas 11:55
Re: Dealing with number formats when server and client are different locales Tom Lane 12:35
Schema/table replication Marcin Giedz 13:00
Re: Dealing with number formats when server and client are different locales Rob Northcott 14:08
Re: Dealing with number formats when server and client are different locales Tom Lane 14:49
Re: Dealing with number formats when server and client are different locales Rob Northcott 15:09
Re: Schema/table replication Steve Atkins 15:22
Re: Schema/table replication Marcin Giedz 15:48
Re: Schema/table replication Steve Atkins 15:53
Hot standby failing with page # of relation # is unintitialized Adrian Heath 16:25
Hot standby failing with page # of relation # is uninitialized Adrian Heath 16:31
Confused about max_standby_streaming_delay Robert Inder 16:43
Re: Schema/table replication Nico Williams 16:54
logical replication API to read WAL file through replication slot Dipesh Dangol 18:55
Re: Confused about max_standby_streaming_delay Jeff Janes 19:47
pgcrypto encrypt Stephen Cook 20:19

Sept. 7, 2017

Thread Author Time
column names query hamann.w 07:18
Re: column names query Francisco Olarte 08:12
Re: Confused about max_standby_streaming_delay Robert Inder 08:16
pg_rewind issue James Sewell 12:06
Plans to lift no write limitation on parallelism? Alexander Stoddard 12:38
Re: column names query stimits 12:58
Re: BDR, wal segment has been removed, is it possible move forward? milist ujang 13:16
Re: column names query hamann.w 13:17
Re: column names query hamann.w 13:26
Re: column names query Manuel Gómez 13:29
WAL & ready files retained after turning off log shipping Ron Johnson 13:51
Re: WAL & ready files retained after turning off log shipping Tom Lane 14:08
Re: WAL & ready files retained after turning off log shipping Ron Johnson 14:25
Re: WAL & ready files retained after turning off log shipping Tom Lane 14:32
Re: column names query Francisco Olarte 15:11
Re: Confused about max_standby_streaming_delay Jeff Janes 16:08
Re: column names query John R Pierce 16:33
Re: WAL & ready files retained after turning off log shipping Michael Paquier 22:07
Re: WAL & ready files retained after turning off log shipping Ron Johnson 22:10
Re: Performance with high correlation in group by on PK Jeff Janes 22:23
Re: pg_rewind issue Michael Paquier 23:04

Sept. 8, 2017

Thread Author Time
B-tree index on a VARCHAR(4000) column Ron Johnson 03:48
Re: BDR, wal segment has been removed, is it possible move forward? Craig Ringer 04:12
Re: column names query hamann.w 06:16
Re: B-tree index on a VARCHAR(4000) column Tom Lane 11:56
Re: B-tree index on a VARCHAR(4000) column Merlin Moncure 12:50
SAP Application deployment on PostgreSQL chiru r 19:34
Re: SAP Application deployment on PostgreSQL John R Pierce 19:44
Aquameta 0.1 - Request for reviews, contributors Eric Hanson 21:41
Re: [HACKERS] SAP Application deployment on PostgreSQL Christopher Browne 21:48
Re: Aquameta 0.1 - Request for reviews, contributors Nico Williams 22:18
Re: B-tree index on a VARCHAR(4000) column John Turner 22:37
Re: Aquameta 0.1 - Request for reviews, contributors Nico Williams 23:26

Sept. 9, 2017

Thread Author Time
Analyzing performance regression from 9.2 to 9.6 Dave Peticolas 22:26

Sept. 10, 2017

Thread Author Time
pg_ident mapping Kerberos Usernames techmail+pgsql 01:44
Re: pg_ident mapping Kerberos Usernames rob stone 02:28
Re: Analyzing performance regression from 9.2 to 9.6 Tom Lane 03:24
Re: Analyzing performance regression from 9.2 to 9.6 Dave Peticolas 04:41
Re: pg_ident mapping Kerberos Usernames Magnus Hagander 07:39
Re: B-tree index on a VARCHAR(4000) column Merlin Moncure 15:42
Re: B-tree index on a VARCHAR(4000) column John Turner 18:00
Re: B-tree index on a VARCHAR(4000) column Tom Lane 18:24
Re: pg_ident mapping Kerberos Usernames techmail+pgsql 18:25
Re: B-tree index on a VARCHAR(4000) column John Turner 19:12
Re: pg_ident mapping Kerberos Usernames techmail+pgsql 20:54
Re: pg_ident mapping Kerberos Usernames Jeff Janes 21:27
Re: pg_ident mapping Kerberos Usernames techmail+pgsql 23:31

Sept. 11, 2017

Thread Author Time
BDR, limit number of groups in a cluster milist ujang 01:32
Re: BDR, limit number of groups in a cluster Craig Ringer 01:55
Final pg_dumpall should happen in Single-User-Mode Thomas Güttler 13:25
Re: pg_ident mapping Kerberos Usernames rob stone 13:51
Needing verification on instructions for streaming replication Dave Florek 14:02
Major Version Upgradation from 9.4 to 9.6 Amee Sankhesara - Quipment India 14:17
pg_restore error -- missing pg table kbrannen 16:08
Re: pg_ident mapping Kerberos Usernames techmail+pgsql 17:15
Re: pg_restore error -- missing pg table Tom Lane 17:43
Re: Needing verification on instructions for streaming replication Jeff Janes 18:38
Re: pg_restore error -- missing pg table kbrannen 18:38
Re: Needing verification on instructions for streaming replication Dave Florek 18:56
contrecord is requested Scott Marlowe 20:27
Re: pg_ident mapping Kerberos Usernames Jeff Janes 21:32
Re: contrecord is requested Michael Paquier 22:32

Sept. 12, 2017

Thread Author Time
Perl script is killed by SIGPIPE Yogesh Sharma 01:02
Joining 16 tables seems slow Frank Millman 06:45

Browse Archives

Prev | Next