pgsql-general - August 2018

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
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

Aug. 1, 2018

Thread Author Time
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function 📎 Peter Geoghegan 01:48
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Andres Freund 02:02
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Peter Geoghegan 02:29
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Andres Freund 04:00
Settings for fast restores Ron 06:03
Re: Question on postgresql.conf Steven Lembark 07:37
Adding terminal title support for psqlrc ik 08:52
Template0 datfrozenxid age is 160million and progressing Rijo Roy 11:28
Re: Adding terminal title support for psqlrc Adrian Klaver 13:29
Re: Adding terminal title support for psqlrc Tom Lane 13:47
Re: Template0 datfrozenxid age is 160million and progressing Tom Lane 14:08
Re: Settings for fast restores Vick Khera 14:11
Re: Template0 datfrozenxid age is 160million and progressing Rijo Roy 14:15
Re: Template0 datfrozenxid age is 160million and progressing Tom Lane 14:24
Re: Template0 datfrozenxid age is 160million and progressing Rijo Roy 14:31
Re: Settings for fast restores Ron 14:39
Weird behaviour of the planner Guillaume Lelarge 14:48
Re: Template0 datfrozenxid age is 160million and progressing David Rowley 14:48
Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" . Achilleas Mantzios 14:56
Re: Weird behaviour of the planner David Rowley 14:59
Re: Weird behaviour of the planner Guillaume Lelarge 15:06
Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" . Tom Lane 15:12
Re: Template0 datfrozenxid age is 160million and progressing Andres Freund 15:39
Re: Template0 datfrozenxid age is 160million and progressing Tom Lane 16:07
Re: Template0 datfrozenxid age is 160million and progressing Andres Freund 16:12
Re: Template0 datfrozenxid age is 160million and progressing Alvaro Herrera 16:20
Re: Template0 datfrozenxid age is 160million and progressing Andres Freund 16:36
Re: Template0 datfrozenxid age is 160million and progressing Vik Fearing 17:16
Re: Adding terminal title support for psqlrc ik 17:55
Re: Adding terminal title support for psqlrc Adrian Klaver 18:15
Re: Template0 datfrozenxid age is 160million and progressing Stephen Eilert 20:08
Pg_rewind cannot load history wal Richard Schmidt 21:09

Aug. 2, 2018

Thread Author Time
Problem building libpq Igor Korot 01:08
Re: Pg_rewind cannot load history wal Abhinav Mehta 05:00
Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Alexandru Lazarev 05:53
ProjectSet Oliver Kohll 09:17
Re: Adding terminal title support for psqlrc ik 09:32
Re: ProjectSet David Rowley 12:21
ERROR: found xmin 54230249 from before relfrozenxid 61349053 rihad 12:38
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Adrian Klaver 12:47
Re: ProjectSet Oliver Kohll 13:16
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Alexandru Lazarev 13:26
Re: ProjectSet David Rowley 13:27
Error couldn't not serialize data due to concurrent read write update Om Prakash Jaiswal 13:28
Re: ProjectSet Oliver Kohll 13:30
Re: ERROR: found xmin 54230249 from before relfrozenxid 61349053 rihad 13:34
Re: ERROR: found xmin 54230249 from before relfrozenxid 61349053 rihad 14:08
List user who have access to schema Suresh Raja 17:49
Re: List user who have access to schema Tom Lane 17:58
Re: List user who have access to schema Suresh Raja 18:23
Re: List user who have access to schema David G. Johnston 18:42
Re: List user who have access to schema Adrian Klaver 18:47
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function 📎 Peter Geoghegan 20:00
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Andres Freund 20:05
FW: Pg_rewind cannot load history wal Richard Schmidt 23:48

Aug. 3, 2018

Thread Author Time
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Devrim Gündüz 06:08
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Christoph Berg 08:22
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Pavel Raiskup 08:30
how to install pgcrypto Ze Victor Harry 08:53
RE: how to install pgcrypto Charles Clavadetscher 09:21
Re: how to install pgcrypto Tim Clarke 09:31
WAL-dir filling up with wal_level = logical Andreas Joseph Krogh 10:12
Sv: WAL-dir filling up with wal_level = logical Andreas Joseph Krogh 10:33
Re: WAL-dir filling up with wal_level = logical Andreas Kretschmer 10:34
Re: Sv: WAL-dir filling up with wal_level = logical Andreas Kretschmer 10:40
SQL Programming Assistant for PostgreSQL Dmitry Igrishin 12:33
List of objects owned by a schema/owner Tiffany Thang 12:33
Re: List user who have access to schema pinker 14:26
Re: List of objects owned by a schema/owner Tom Lane 14:52
RE: how to install pgcrypto Charles Clavadetscher 15:32
Re: List of objects owned by a schema/owner Tiffany Thang 20:17
Eror while dropping a user Ertan Küçükoğlu 20:41
RE: How to prevent "no wait lock" after a connection drop Ertan Küçükoğlu 20:45
Re: Pg_rewind cannot load history wal Michael Paquier 20:59
Re: Eror while dropping a user Alessandro Aste 21:02
Re: Sv: WAL-dir filling up with wal_level = logical Michael Paquier 21:04
RE: Eror while dropping a user Ertan Küçükoğlu 21:33
RE: Eror while dropping a user Ertan Küçükoğlu 21:46
Re: Eror while dropping a user Tom Lane 22:22

Aug. 4, 2018

Thread Author Time
Re: Pg_rewind cannot load history wal Simon Riggs 06:44
Re: Pg_rewind cannot load history wal Michael Paquier 06:56
Re: Pg_rewind cannot load history wal Simon Riggs 09:54
Re: Pg_rewind cannot load history wal Andres Freund 11:59
Re: Pg_rewind cannot load history wal Michael Paquier 13:13
PANIC: could not open critical system index 2662 C GG 14:45
Re: Pg_rewind cannot load history wal Christophe Pettus 14:54
Re: PANIC: could not open critical system index 2662 Tom Lane 15:13
Add column with If Not Exists Simon White 15:56
Re: Add column with If Not Exists Adrian Klaver 17:41
Re: Add column with If Not Exists Dmitry Igrishin 17:45
Walsender waiting on SnapbuildSync Brent Kerby 19:34
Re: Pg_rewind cannot load history wal Michael Paquier 20:50
Re: Pg_rewind cannot load history wal Christophe Pettus 21:01
Re: jndi jdbc url with ssl authenticat in tomcat ... fails org.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl" must end with the ';' delimiter Dave Cramer 21:46
Re: jndi jdbc url with ssl authenticat in tomcat ... fails org.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl" must end with the ';' delimiter Peter Hicks 23:34

Aug. 5, 2018

Thread Author Time
ALTER TABLE .. SET STATISTICS Ron 06:03
Re: Walsender waiting on SnapbuildSync Andres Freund 14:36
Re: ALTER TABLE .. SET STATISTICS Alvaro Herrera 14:43
Re: ALTER TABLE .. SET STATISTICS Tom Lane 15:43
Conditional JOINs to optimise expensive views wouter-postgresql 17:05
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Devrim Gündüz 21:02

Aug. 6, 2018

Thread Author Time
How to avoid dead rows in tables. Raghavendra Rao J S V 07:04
Re: How to avoid dead rows in tables. Andreas Kretschmer 07:13
How to revoke privileged from PostgreSQL's superuser bejita0409 09:48
Re: [External] How to revoke privileged from PostgreSQL's superuser Vijaykumar Jain 10:19
RE: How to revoke privileged from PostgreSQL's superuser Charles Clavadetscher 10:33
Re: How to revoke privileged from PostgreSQL's superuser David G. Johnston 13:19
Re: How to revoke privileged from PostgreSQL's superuser Bear Giles 13:22
Re: How to revoke privileged from PostgreSQL's superuser Tom Lane 13:43
Re: How to revoke privileged from PostgreSQL's superuser Bear Giles 13:44
Re: How to revoke privileged from PostgreSQL's superuser Bear Giles 13:45
Re: How to revoke privileged from PostgreSQL's superuser Evan Bauer 14:13
Re: How to revoke privileged from PostgreSQL's superuser Bear Giles 14:45
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Alexandru Lazarev 20:49
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Alexandru Lazarev 20:51
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Dimitri Maziuk 20:57
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Devrim Gündüz 21:38
Re: PANIC: could not open critical system index 2662 C GG 21:51
Re: PANIC: could not open critical system index 2662 Ravi Krishna 22:21
Re: How to revoke privileged from PostgreSQL's superuser Tim Cross 22:27
Re: Re: How to revoke privileged from PostgreSQL's superuser bejita0409 22:46
Immutable function WAY slower than Stable function? Ken Tanzer 22:49
Re: Immutable function WAY slower than Stable function? Tom Lane 23:11
Re: Immutable function WAY slower than Stable function? Ken Tanzer 23:30
Re: Immutable function WAY slower than Stable function? Adrian Klaver 23:36
Re: Immutable function WAY slower than Stable function? Ken Tanzer 23:44

Aug. 7, 2018

Thread Author Time
Re: Immutable function WAY slower than Stable function? Adrian Klaver 00:36
Re: Re: How to revoke privileged from PostgreSQL's superuser Bear Giles 00:44
Re: Immutable function WAY slower than Stable function? Tom Lane 02:42
Re: Immutable function WAY slower than Stable function? Ken Tanzer 04:50
Re: Immutable function WAY slower than Stable function? Laurenz Albe 05:59
Re: Immutable function WAY slower than Stable function? 📎 Ken Tanzer 07:05
Re: Immutable function WAY slower than Stable function? 📎 Ken Tanzer 07:38
Re: Immutable function WAY slower than Stable function? Laurenz Albe 07:40
Re: Immutable function WAY slower than Stable function? Adrian Klaver 13:56
Re: Immutable function WAY slower than Stable function? Tom Lane 16:10
Re: Immutable function WAY slower than Stable function? Guyren Howe 16:57
Re: Immutable function WAY slower than Stable function? Ken Tanzer 18:42
Re: Immutable function WAY slower than Stable function? Christophe Pettus 18:53
Re: Immutable function WAY slower than Stable function? Tom Lane 18:59
Instead trigger on a view to update base tables ? Day, David 19:09
Re: Instead trigger on a view to update base tables ? David G. Johnston 19:16
check_function_bodies not doing much Marcelo Lacerda 19:17
Re: check_function_bodies not doing much Pavel Stehule 19:25
Re: check_function_bodies not doing much Tom Lane 19:31
Re: check_function_bodies not doing much David G. Johnston 19:38
Re: check_function_bodies not doing much Tom Lane 19:47
Re: check_function_bodies not doing much Merlin Moncure 21:44
FW: Pg_rewind cannot load history wal Richard Schmidt 21:50
Re: check_function_bodies not doing much Marcelo Lacerda 22:02
Re: check_function_bodies not doing much Pavel Stehule 22:21

Aug. 8, 2018

Thread Author Time
Re: check_function_bodies not doing much Marcelo Lacerda 03:32
Postgres - search for value throughout many tables? czezz 14:09
Re: Postgres - search for value throughout many tables? David G. Johnston 14:13
Re: Postgres - search for value throughout many tables? Achilleas Mantzios 14:33
Odp: Re: Postgres - search for value throughout many tables? czezz 15:05
Postgres replication -- .done file in slave Vijay Rajah 15:21
Re: Postgres - search for value throughout many tables? Christopher Browne 17:16
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Kyle Samson 17:23
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Peter Geoghegan 17:27
Re: Pg_rewind cannot load history wal Abhinav Mehta 17:54

Aug. 9, 2018

Thread Author Time
select version() with internal number version? Luca Ferrari 07:00
Re: select version() with internal number version? Wèi Cōngruì 07:10
postgresql-10-pldebugger in alpine linux distribution hmidi slim 10:50
Re: select version() with internal number version? Tom Lane 13:51
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Bruce Momjian 16:11
Re: Convert Existing Table to a Partition Table in PG10 Bruce Momjian 20:01
Re: When exactly is a TIMESTAMPTZ converted to the sessions time zone? Bruce Momjian 20:49
Re: When exactly is a TIMESTAMPTZ converted to the sessions time zone? Paul Jungwirth 21:08
Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL? Bruce Momjian 21:14

Aug. 10, 2018

Thread Author Time
timestamp arithmetics in C function Lutz Gehlen 07:05
Re: Postgres - search for value throughout many tables? Adrien NAYRAT 09:59
multiple conflict targets Torsten Förtsch 10:12
Re: Postgres - search for value throughout many tables? Daniel Verite 10:34
Re: select version() with internal number version? Luca Ferrari 11:35
Re: Ltree - how to sort nodes on parent node Saccilotto Ramon 12:34
Re: multiple conflict targets Adrian Klaver 13:28
Audit management dangal 14:01
Re: Audit management Achilleas Mantzios 14:11
Re: Audit management dangal 18:20
Re: User documentation vs Official Docs Bruce Momjian 19:00
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Bruce Momjian 19:22
Re: How to revoke privileged from PostgreSQL's superuser Bruce Momjian 19:41
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Christoph Berg 19:41
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Bruce Momjian 19:44
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Christoph Berg 19:49
Re: How to revoke privileged from PostgreSQL's superuser Benedict Holland 20:06
Re: How to revoke privileged from PostgreSQL's superuser Rui DeSousa 20:12
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Dimitri Maziuk 20:38
Re: How to revoke privileged from PostgreSQL's superuser Benedict Holland 23:21

Aug. 11, 2018

Thread Author Time
Re: How to revoke privileged from PostgreSQL's superuser Rui DeSousa 02:34
Re: User documentation vs Official Docs Pavel Stehule 06:14
Streaming Logical Decoding Events Matt Dee 13:34
Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/) Devrim Gündüz 14:39
Replication failure, slave requesting old segments Phil Endecott 15:18
Re: Replication failure, slave requesting old segments Adrian Klaver 18:30
Re: Replication failure, slave requesting old segments Phil Endecott 19:42
Re: Replication failure, slave requesting old segments Adrian Klaver 21:48
Re: Replication failure, slave requesting old segments Stephen Frost 22:53

Aug. 12, 2018

Thread Author Time
PostgreSQL C Language Extension with C++ Code TalGloz 17:05

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