pgsql-bugs - May 2018

If you find a bug, please use the bug reporting form.

Search the Archives

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

Browse Archives

Prev | Next

May 1, 2018

Thread Author Time
RE: power() function in Windows: "value out of range: underflow" Huong Dangminh 02:20
Usage of pg_waldump Dang Minh Huong 07:41
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Michael Paquier 12:44
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane 14:08
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Stephen Frost 14:29
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane 14:46
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Stephen Frost 14:51
Re: Usage of pg_waldump Andres Freund 16:26
Re: Usage of pg_waldump David G. Johnston 16:39
Re: power() function in Windows: "value out of range: underflow" Robert Haas 17:38
Re: power() function in Windows: "value out of range: underflow" Tom Lane 17:49
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane 18:47
Re: power() function in Windows: "value out of range: underflow" Robert Haas 19:08
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate David G. Johnston 19:24
Re: power() function in Windows: "value out of range: underflow" David G. Johnston 19:44
BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences when migrating 9.1 10.3 PG Bug reporting form 19:47
Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane 20:29

May 2, 2018

Thread Author Time
Re: power() function in Windows: "value out of range: underflow" Tom Lane 14:42
Re: BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences when migrating 9.1 10.3 Tom Lane 14:47

May 3, 2018

Thread Author Time
postgresql license question anderson.hsu 05:54
Re: postgresql license question Heikki Linnakangas 08:29
BUG #15184: Planner overestimates number of rows in empty table PG Bug reporting form 08:49
Asia/Jakarta Timezone problem postgresql_2016@163.com 09:29
Re: Asia/Jakarta Timezone problem Tom Lane 13:37
RE: postgresql license question Greg Clough 13:51
BUG #15185: pg_dump doesn't include statistics when specifying a table PG Bug reporting form 15:09
Re: BUG #15185: pg_dump doesn't include statistics when specifying a table Alvaro Herrera 15:17
Re: BUG #15184: Planner overestimates number of rows in empty table Andrew Gierth 15:40

May 4, 2018

Thread Author Time
Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least 9.5)? Heikki Linnakangas 07:05
BUG #15186: how get data from db files PG Bug reporting form 10:24
Re: BUG #15184: Planner overestimates number of rows in empty table Alexey Ermakov 12:09
BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication PG Bug reporting form 16:34
Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication Tom Lane 16:46
Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication Andres Freund 16:54
Re:Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication chenhj 17:16
Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least 9.5)? Heikki Linnakangas 22:49

May 5, 2018

Thread Author Time
BUG #15188: wrong count "tuples removed" in autovacuum log file PG Bug reporting form 13:53

May 6, 2018

Thread Author Time
Re:Re:Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication chenhj 15:45
Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication Andres Freund 19:57

May 8, 2018

Thread Author Time
[BUG] Re-entering malloc problem when use --enable-nls build postgresql 158306855 01:59
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane 05:32
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Andres Freund 05:57
BUG #15189: Could not connect to server PG Bug reporting form 06:02
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane 06:07
Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql 158306855 06:48
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Andres Freund 08:36
Invalid precision for money datatype SriRaghu Sai Kasyap 09:22
Re: Invalid precision for money datatype David G. Johnston 12:19
Re: Invalid precision for money datatype Andrew Gierth 13:07
BUG #15190: Build configure should have option to disable clock_gettime on MacOS 10.12 and up. PG Bug reporting form 17:55
Re: BUG #15190: Build configure should have option to disable clock_gettime on MacOS 10.12 and up. Tom Lane 19:10
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Andres Freund 19:51
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Thomas Munro 21:30
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Andres Freund 21:40
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane 22:04
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Andres Freund 22:11
Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane 22:15

May 9, 2018

Thread Author Time
BUG #15191: postgresql extension "uuid-ossp" Error PG Bug reporting form 06:38
Re: BUG #15191: postgresql extension "uuid-ossp" Error Michael Paquier 06:52
Re: BUG #15191: postgresql extension "uuid-ossp" Error Devrim Gündüz 07:04
Re: BUG #15190: Build configure should have option to disable clock_gettime on MacOS 10.12 and up. Marc Van Olmen 12:43
TOAST table repeatedly corrupted Niles Oien 18:54
TOAST table repeatedly corrupted David G. Johnston 19:31
Re: TOAST table repeatedly corrupted Tom Lane 20:47
Re: TOAST table repeatedly corrupted Niles Oien 21:34
Re: TOAST table repeatedly corrupted Peter Geoghegan 22:15
Re: TOAST table repeatedly corrupted Tom Lane 22:46

May 10, 2018

Thread Author Time
the postgres process is not killed when the postmaster is killed 范国腾 08:34
Re: the postgres process is not killed when the postmaster is killed Michael Paquier 09:04
BUG #15192: Implement option to use columns order defined at CSV PG Bug reporting form 11:18
PostgreSQL 2018-05-10 Security Update Release Stephen Frost 13:36
Re: BUG #15192: Implement option to use columns order defined at CSV Francisco Olarte 14:58
Re: BUG #15192: Implement option to use columns order defined at CSV KES 18:05

May 11, 2018

Thread Author Time
RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Jonathan Allen 00:37
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 03:36
BUG #15193: Postgres Coredumped in AIX PG Bug reporting form 14:26

May 12, 2018

Thread Author Time
Abnormal JSON query performance 007reader 04:32
Re: Abnormal JSON query performance Pavel Stehule 05:03
pg_upgradecluster 9.5 to 10.3 John Bester 05:37
Re: pg_upgradecluster 9.5 to 10.3 Christoph Berg 06:40
Re: Abnormal JSON query performance 007reader 07:12
Re: Abnormal JSON query performance Pavel Stehule 07:23
Re: Abnormal JSON query performance 007reader 07:31
Re: Abnormal JSON query performance Pavel Stehule 07:36

May 13, 2018

Thread Author Time
Re: Abnormal JSON query performance 007reader 17:16
Re: Abnormal JSON query performance Pavel Stehule 19:43
Cannot create an aggregate function with variadic parameters and enabled for parallel execution 📎 Alexey Bashtanov 23:44

May 14, 2018

Thread Author Time
BUG #15194: Strange results were displayed for select query. PG Bug reporting form 02:02
Re: BUG #15194: Strange results were displayed for select query. David G. Johnston 02:08
Re: BUG #15194: Strange results were displayed for select query. David Rowley 03:13
Re: Abnormal JSON query performance 007reader 03:48
Abnormal JSON query performance David G. Johnston 04:08
Re: Abnormal JSON query performance Pavel Stehule 05:04
Re: Abnormal JSON query performance Tom Lane 05:18
Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least 9.5)? Kyotaro HORIGUCHI 06:59
"REVOKE ... ON DATABASE template1 ..." has no effect Ralf Jung 09:15
BUG #15195: Creation two subscription with the same name in different databases PG Bug reporting form 09:22
Re: Abnormal JSON query performance Merlin Moncure 13:21
Re: Abnormal JSON query performance Tom Lane 14:49
Re: Abnormal JSON query performance David G. Johnston 15:01
BUG #15196: bogus data in lock file "postmaster.pid" PG Bug reporting form 15:06
Re: "REVOKE ... ON DATABASE template1 ..." has no effect Tom Lane 15:43
Re: Abnormal JSON query performance Tom Lane 15:53
Re: BUG #15196: bogus data in lock file "postmaster.pid" Tom Lane 16:02
Re: Abnormal JSON query performance David G. Johnston 16:09
BUG #15197: query tool not working PG Bug reporting form 19:46
Re: BUG #15197: query tool not working David G. Johnston 19:53
Re: "REVOKE ... ON DATABASE template1 ..." has no effect Gavin Flower 20:12
Re: Abnormal JSON query performance 007reader 21:37
Re:Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication chenhj 23:16

May 15, 2018

Thread Author Time
Re: Abnormal JSON query performance Dmitry Dolgov 08:42
Re: "REVOKE ... ON DATABASE template1 ..." has no effect Ralf Jung 09:11
Re: Cannot create an aggregate function with variadic parameters and enabled for parallel execution Alexey Bashtanov 14:06
pg_ctl -D PGDATA stop -m fast gets the following message 57P03 FATAL: the database system is shutting down 📎 AYahorau 15:36
Inconsistencies restoring public schema ownership from pg_dump Chris Pacejo 16:14
Re: Cannot create an aggregate function with variadic parameters and enabled for parallel execution Tom Lane 16:52
"order by" and "order by asc" returning different results on date field Rick Gentry 18:25
Re: "order by" and "order by asc" returning different results on date field Tom Lane 18:59
ERROR: subxact logged without previous toplevel record 📎 Euler Taveira 19:02
Re: ERROR: subxact logged without previous toplevel record Alvaro Herrera 19:08
Re: "order by" and "order by asc" returning different results on date field Rick Gentry 19:24
Re: ERROR: subxact logged without previous toplevel record Euler Taveira 19:43
Re: "order by" and "order by asc" returning different results on date field Tom Lane 20:06
Re: ERROR: subxact logged without previous toplevel record Euler Taveira 21:26

May 16, 2018

Thread Author Time
Re: Abnormal JSON query performance reader 1001 03:42
Re: Abnormal JSON query performance David G. Johnston 03:59
Re: Abnormal JSON query performance Dmitry Dolgov 07:12
BUG #15198: nextval() accepts tables/indexes when adding a default to a column PG Bug reporting form 09:29
BUG #15199: relfrozenxid related corruption in pg_authid PG Bug reporting form 09:47
JDBC problem in 10.3 / 10.4 John Bester 13:02
BUG #15200: Support ANSI OFFSET .. FETCH syntax with bind variables PG Bug reporting form 13:36
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Peter Eisentraut 14:00
issue with updatable cursors 📎 Peter Eisentraut 14:14
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column David G. Johnston 14:14
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Tom Lane 14:14
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Peter Eisentraut 14:20
Re: Abnormal JSON query performance Tom Lane 15:07
Re: Abnormal JSON query performance Pavel Stehule 15:10
Re: Cannot create an aggregate function with variadic parameters and enabled for parallel execution Alexey Bashtanov 15:18
Re: "order by" and "order by asc" returning different results on date field Rick Gentry 16:04
Re: "order by" and "order by asc" returning different results on date field Feike Steenbergen 16:44
BUG #15201: PostGIS 2.3 fails to install for 9.6 on Fedora 28 PG Bug reporting form 17:15
Re: "order by" and "order by asc" returning different results on date field Rick Gentry 17:17
Re: Abnormal JSON query performance 007reader 17:49
Re: Abnormal JSON query performance 007reader 17:56
BUG #15202: Unexpected behavior with trigger fired on logical replicaion using pg_notify PG Bug reporting form 18:26
BUG #15203: trigger does not recognize schema changes when passing on data PG Bug reporting form 21:06

May 17, 2018

Thread Author Time
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Feike Steenbergen 06:41
Re: pg_ctl -D PGDATA stop -m fast gets the following message 57P03 FATAL: the database system is shutting down 📎 Kyotaro HORIGUCHI 08:00
RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT 📎 Huong Dangminh 11:35
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column David G. Johnston 12:25
BUG #15204: Export to CSV doesn't work in Query tools PG Bug reporting form 13:50
Re: BUG #15204: Export to CSV doesn't work in Query tools David G. Johnston 13:56
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 15:43
Re: Abnormal JSON query performance reader 1001 16:17
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Andres Freund 16:21
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Alvaro Herrera 16:36
BUG #15205: ERROR: table row type and query-specified row type do not match PG Bug reporting form 20:11
Re: BUG #15205: ERROR: table row type and query-specified row type do not match David G. Johnston 20:15

May 18, 2018

Thread Author Time
Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Michael Paquier 01:12
Re: Abnormal JSON query performance Bruce Momjian 01:41
Re: BUG #15203: trigger does not recognize schema changes when passing on data Haribabu Kommi 02:55
RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT 📎 Huong Dangminh 05:21
help please ! Marco Palombo 05:23
Re: BUG #15203: trigger does not recognize schema changes when passing on data easteregg 06:48
Re: help please ! Fabio Pardi 07:45
Re: BUG #15203: trigger does not recognize schema changes when passing on data Haribabu Kommi 09:17
RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Huong Dangminh 12:40
Re: BUG #15203: trigger does not recognize schema changes when passing on data Tom Lane 14:13
Re: JDBC problem in 10.3 / 10.4 Dave Cramer 14:23
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 15:07
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 17:07
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 17:30
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 18:11

May 19, 2018

Thread Author Time
postgres_fdw misbehaviour using "DELETE ... RETURNING *" 📎 Fabrízio de Royes Mello 01:38
BUG #15206: Can not import CSV into PostgreSQL PG Bug reporting form 09:09
Re: BUG #15206: Can not import CSV into PostgreSQL Pavel Stehule 11:19
Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston 12:55
Re: BUG #15206: Can not import CSV into PostgreSQL 📎 Milorad Krstevski 13:57
Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston 14:03
Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski 14:06
Re: BUG #15206: Can not import CSV into PostgreSQL 📎 Milorad Krstevski 14:14
Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski 14:18
Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston 14:24
Re:Re:Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication chenhj 14:24
Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski 14:25
Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston 14:31
Re: BUG #15206: Can not import CSV into PostgreSQL 📎 Milorad Krstevski 14:36
Re: BUG #15206: Can not import CSV into PostgreSQL Andrew Gierth 14:53
Re: BUG #15206: Can not import CSV into PostgreSQL 📎 Milorad Krstevski 15:05
RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Huong Dangminh 15:41
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 16:45
Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston 19:05
Re: BUG #15200: Support ANSI OFFSET .. FETCH syntax with bind variables Andrew Gierth 20:57
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan 22:34
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 22:49
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan 23:23
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane 23:31
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan 23:33

May 20, 2018

Thread Author Time
Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan 03:16

Browse Archives

Prev | Next