pgsql-general since 2018-08-29 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. 29, 2018

Thread Author Time
WAL replay issue from 9.6.8 to 9.6.10 Dave Peticolas 04:02
Re: WAL replay issue from 9.6.8 to 9.6.10 Andreas Kretschmer 04:20
Re: WAL replay issue from 9.6.8 to 9.6.10 Dave Peticolas 04:26
Re: WAL replay issue from 9.6.8 to 9.6.10 Andreas Kretschmer 04:48
using a plpgsql function argument as a table column. Shaun Savage 05:09
using a plpgsql function argument as a table column. ss 05:10
Re: using a plpgsql function argument as a table column. Thomas Boussekey 05:24
Re: using a plpgsql function argument as a table column. Tim Cross 05:37
Re: using a plpgsql function argument as a table column. Shaun Savage 05:38
Re: using a plpgsql function argument as a table column. ss 05:40
Re: using a plpgsql function argument as a table column. David G. Johnston 05:58
Re: using a plpgsql function argument as a table column. Pavel Stehule 05:58
Re: using a plpgsql function argument as a table column. David G. Johnston 06:03
Re: WAL replay issue from 9.6.8 to 9.6.10 Alexander Kukushkin 06:31
Re: "cache lookup failed for type ####" when running unit tests Wilhansen Li 06:51
Executing a Function with an INSERT INTO command fails TalGloz 09:12
RE: Executing a Function with an INSERT INTO command fails Charles Clavadetscher 10:50
RE: Executing a Function with an INSERT INTO command fails TalGloz 11:21
Re: WAL replay issue from 9.6.8 to 9.6.10 Michael Paquier 11:54
RE: Executing a Function with an INSERT INTO command fails Charles Clavadetscher 12:10
Re: Erroneous behavior of primary key Daniel J Peacock 12:20
Re: pg_sample Daniel Verite 12:23
Re: Erroneous behavior of primary key Daniel J Peacock 12:34
Re: using a plpgsql function argument as a table column. Adrian Klaver 13:40
Issue with psqlrc with command line. saurabh shelar 15:07
Re: Issue with psqlrc with command line. David G. Johnston 15:13
Re: Issue with psqlrc with command line. saurabh shelar 15:18
Re: Issue with psqlrc with command line. David G. Johnston 15:24
Re: Issue with psqlrc with command line. saurabh shelar 15:31
Re: Issue with psqlrc with command line. David G. Johnston 15:37
Re: WAL replay issue from 9.6.8 to 9.6.10 Dave Peticolas 16:15
Unscibscribe abhishekgautam009 16:21
RE: Executing a Function with an INSERT INTO command fails TalGloz 16:27
Re: Executing a Function with an INSERT INTO command fails Tom Lane 16:33
Re: Executing a Function with an INSERT INTO command fails David G. Johnston 16:34
Re: Executing a Function with an INSERT INTO command fails TalGloz 16:47
Re: Executing a Function with an INSERT INTO command fails David G. Johnston 16:54
Re: Executing a Function with an INSERT INTO command fails TalGloz 17:09
Re: Executing a Function with an INSERT INTO command fails TalGloz 17:24
RE: Executing a Function with an INSERT INTO command fails TalGloz 17:45
Re: Executing a Function with an INSERT INTO command fails Charles Clavadetscher 17:54
pg_upgrade fails saying function unaccent(text) doesn't exist Gunnlaugur Thor Briem 18:09
Re: Executing a Function with an INSERT INTO command fails TalGloz 18:23
Re: pg_upgrade fails saying function unaccent(text) doesn't exist Bruce Momjian 19:06
Re: WAL replay issue from 9.6.8 to 9.6.10 Michael Paquier 20:50

Aug. 30, 2018

Thread Author Time
Re: WAL replay issue from 9.6.8 to 9.6.10 Dave Peticolas 03:19
Re: Issue with psqlrc with command line. saurabh shelar 07:37
Ways to deal with large amount of columns; a 09:13
Re: pg_upgrade fails saying function unaccent(text) doesn't exist Gunnlaugur Thor Briem 09:24
Re: Ways to deal with large amount of columns; David G. Johnston 12:31
Re: Ways to deal with large amount of columns; Andreas Kretschmer 13:03
Re: Ways to deal with large amount of columns; Robert Zenz 13:15
Re: Ways to deal with large amount of columns; Andreas Kretschmer 13:27
Re: pg_upgrade fails saying function unaccent(text) doesn't exist Adrian Klaver 13:48
Re: pg_upgrade fails saying function unaccent(text) doesn't exist Gunnlaugur Thor Briem 16:03
searching a value in a variable/field in all tables in a schema Ruiqiang Chen 20:44
Re: searching a value in a variable/field in all tables in a schema David G. Johnston 20:51
Re: Ways to deal with large amount of columns; Tim Cross 22:24

Aug. 31, 2018

Thread Author Time
Re: Ways to deal with large amount of columns; a 00:46
Re: Ways to deal with large amount of columns; a 00:47
Re: searching a value in a variable/field in all tables in a schema Ruiqiang Chen 01:02
Re: Ways to deal with large amount of columns; Tim Cross 03:04
Re: Ways to deal with large amount of columns; Ben Madin 08:47
Re: Ways to deal with large amount of columns; Brent Wood 09:31
very slow largeobject transfers through JDBC Mate Varga 13:34
Re: very slow largeobject transfers through JDBC Dmitry Igrishin 13:58
Re: pg_upgrade fails saying function unaccent(text) doesn't exist Adrian Klaver 14:14
Re: very slow largeobject transfers through JDBC Mate Varga 14:15
Re: pg_upgrade fails saying function unaccent(text) doesn't exist Adrian Klaver 14:17
locate DB corruption Dave Peticolas 15:02
Re: locate DB corruption Adrian Klaver 15:14
Re: locate DB corruption Dave Peticolas 15:51
Autovacuum degrades all other operations by keeping all buffers dirty? David Pacheco 21:53
Re: Autovacuum degrades all other operations by keeping all buffers dirty? Alvaro Herrera 22:31
Re: Autovacuum degrades all other operations by keeping all buffers dirty? Andres Freund 22:50

Sept. 1, 2018

Thread Author Time
Re: locate DB corruption Adrian Klaver 00:18
Re: using a plpgsql function argument as a table column. Shaun Savage 00:27
Re: using a plpgsql function argument as a table column. ss 00:28
Re: locate DB corruption Dave Peticolas 03:48
Rules and decision logic triggered by / acting on JSONB nodes in Postgres Amit Kothari 14:14
TR: redundant constraint_schema Olivier LeprĂȘtre 15:50
Re: TR: redundant constraint_schema Andreas Kretschmer 16:27
Re: TR: redundant constraint_schema Adrian Klaver 16:41
Re: TR: redundant constraint_schema Adrian Klaver 16:44
Re: TR: redundant constraint_schema Andreas Kretschmer 16:47
RE: TR: redundant constraint_schema Olivier LeprĂȘtre 16:47
Re: TR: redundant constraint_schema Adrian Klaver 16:52
Re: TR: redundant constraint_schema Andreas Kretschmer 17:00
RE: TR: redundant constraint_schema Olivier LeprĂȘtre 17:13
Re: Rules and decision logic triggered by / acting on JSONB nodes in Postgres Guyren Howe 17:33
Re: very slow largeobject transfers through JDBC Dave Cramer 22:55
Re: locate DB corruption Dave Peticolas 23:45
error in vacuum Dave Peticolas 23:47
Re: error in vacuum Dave Peticolas 23:57

Sept. 2, 2018

Thread Author Time
Re: locate DB corruption Adrian Klaver 00:09
Re: error in vacuum Adrian Klaver 00:10
Re: error in vacuum Dave Peticolas 00:28
Re: locate DB corruption Dave Peticolas 00:53
Re: error in vacuum Dave Peticolas 01:31
Re: error in vacuum Tom Lane 01:56
Re: error in vacuum Dave Peticolas 02:02
Re: error in vacuum Andres Freund 02:24
Re: error in vacuum Dave Peticolas 02:40
pg_basebackup: could not receive data from WAL stream greigwise 04:06
Re: pg_basebackup: could not receive data from WAL stream greigwise 04:14
Re: locate DB corruption Stephen Frost 11:50
Re: pg_basebackup: could not receive data from WAL stream Adrian Klaver 13:41
Re: locate DB corruption Dave Peticolas 15:09
Re: pg_basebackup: could not receive data from WAL stream Kaixi Luo 21:32
WARNING: could not flush dirty data: Function not implemented Ravi Krishna 22:57
Re: WARNING: could not flush dirty data: Function not implemented Tom Lane 23:29
Re: WARNING: could not flush dirty data: Function not implemented Andres Freund 23:31

Sept. 3, 2018

Thread Author Time
dat names generated by pg_dump Ron 00:40
Re: dat names generated by pg_dump Adrian Klaver 01:41
Re: WARNING: could not flush dirty data: Function not implemented Ravi Krishna 02:05
Re: dat names generated by pg_dump Ron 02:07
Re: dat names generated by pg_dump Adrian Klaver 02:22
Re: dat names generated by pg_dump Tom Lane 02:26
Re: dat names generated by pg_dump Ron 02:47
Re: WARNING: could not flush dirty data: Function not implemented Andres Freund 03:04
Re: very slow largeobject transfers through JDBC Mate Varga 07:55
Re: very slow largeobject transfers through JDBC Dave Cramer 09:48
Re: very slow largeobject transfers through JDBC Mate Varga 09:52
Re: WARNING: could not flush dirty data: Function not implemented Ravi Krishna 11:59
Re: WARNING: could not flush dirty data: Function not implemented Tom Lane 13:33
Re: very slow largeobject transfers through JDBC Mate Varga 13:39
Re: WARNING: could not flush dirty data: Function not implemented Ravi Krishna 13:42
Re: very slow largeobject transfers through JDBC Dave Cramer 13:57
Re: WARNING: could not flush dirty data: Function not implemented Tom Lane 13:58
Re: very slow largeobject transfers through JDBC Mate Varga 14:38
Re: very slow largeobject transfers through JDBC Dave Cramer 14:40
Re: very slow largeobject transfers through JDBC Mate Varga 14:48
Re: very slow largeobject transfers through JDBC Dave Cramer 15:58
Re: timestamp arithmetics in C function Lutz Gehlen 16:11
Re: very slow largeobject transfers through JDBC Mate Varga 16:54
Re: very slow largeobject transfers through JDBC Mate Varga 16:59
Re: WARNING: could not flush dirty data: Function not implemented Dmitri Maziuk 17:32
Re: very slow largeobject transfers through JDBC Dave Cramer 17:35
Re: WARNING: could not flush dirty data: Function not implemented Austin Drenski 18:41
Re: WARNING: could not flush dirty data: Function not implemented Rob Sargent 19:19
Re: very slow largeobject transfers through JDBC Mate Varga 19:57
How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 20:52
Re: How to get shorter SERVER_VERSION in psql-prompt? Alvaro Herrera 21:03
Re: How to get shorter SERVER_VERSION in psql-prompt? Christoph Moench-Tegeder 21:34
Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 21:39
Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 21:41
Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Alvaro Herrera 21:42
Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Rob Sargent 21:43
Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Christoph Moench-Tegeder 21:46
Sv: Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 21:47
Re: WARNING: could not flush dirty data: Function not implemented Tim Cross 22:01
Re: WARNING: could not flush dirty data: Function not implemented Tim Cross 22:09

Sept. 4, 2018

Thread Author Time
Re: WARNING: could not flush dirty data: Function not implemented Michael Paquier 01:08
Re: Barman versus pgBackRest Ron 11:41
Re: Barman versus pgBackRest Thomas Poty 12:14
Re: Barman versus pgBackRest Ron 12:46
psqlODBC Kumar, Virendra 13:38
Re: Barman versus pgBackRest Thomas Poty 13:44
Re: psqlODBC Adrian Klaver 13:46
Re: Barman versus pgBackRest Ron 14:14
RE: psqlODBC Kumar, Virendra 14:18
Re: Barman versus pgBackRest Joshua D. Drake 14:24
Re: Barman versus pgBackRest Ron 14:52
increasing HA Thomas Poty 14:58
RE: increasing HA ROS Didier 15:09
Re: Barman versus pgBackRest Joshua D. Drake 15:24
Re: increasing HA Joshua D. Drake 15:25
Re: Barman versus pgBackRest Ron 15:51
Re: Barman versus pgBackRest David Steele 15:51
Re: Barman versus pgBackRest Ron 15:55
Re: Barman versus pgBackRest David Steele 16:00
Re: Barman versus pgBackRest Joshua D. Drake 16:01
Re: Barman versus pgBackRest David Steele 16:29
Re: Barman versus pgBackRest David Steele 16:33
PostgreSQL: Copy from File missing data error Holly Gibons 18:13
Re: PostgreSQL: Copy from File missing data error Ron 18:26
Re: PostgreSQL: Copy from File missing data error Dimitri Maziuk 18:46

Sept. 5, 2018

Thread Author Time
scram-sha-256 authentication broken in FIPS mode Alessandro Gherardi 03:29
Re: scram-sha-256 authentication broken in FIPS mode Michael Paquier 04:27
unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Gunnlaugur Thor Briem 08:49
Re: increasing HA Jehan-Guillaume (ioguix) de Rorthais 09:38
Re: increasing HA Thomas Poty 11:23
Re: increasing HA Jehan-Guillaume (ioguix) de Rorthais 12:15
Re: increasing HA Thomas Poty 13:06
Re: scram-sha-256 authentication broken in FIPS mode Alessandro Gherardi 13:19
Re: increasing HA Jehan-Guillaume (ioguix) de Rorthais 13:44
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Adrian Klaver 14:00
Re: increasing HA Thomas Poty 14:05
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Gunnlaugur Thor Briem 14:06
Re: increasing HA Dmitri Maziuk 14:42
PostgreSQL intenal scheduler? Thiemo Kellner 15:06
Re: PostgreSQL intenal scheduler? Tim Clarke 15:09
Re: PostgreSQL intenal scheduler? Thomas Kellerer 15:31
Re: increasing HA Thomas Poty 15:45
Full table lock dropping a foreign key Paul Jungwirth 16:35
Re: increasing HA Dmitri Maziuk 16:39
Re: increasing HA Thomas Poty 17:04
Re: increasing HA Nicolas Karolak 17:05
Re: increasing HA Dimitri Maziuk 17:32
Max number of WAL files in pg_xlog directory for Postgres 9.2 version Raghavendra Rao J S V 17:39

Browse Archives

Prev | Next