Mailing lists [pgsql-bugs]
- RE: power() function in Windows: "value out of range: underflow" Huong Dangminh
 - RE: power() function in Windows: "value out of range: underflow" Huong Dangminh
 - Usage of pg_waldump Dang Minh Huong
 - Usage of pg_waldump Dang Minh Huong
 - Re: BUG #15180: Alter table add column if not exists with uniqueconstraint will add extra duplicate Michael Paquier
 - Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane
 - Re: BUG #15180: Alter table add column if not exists with uniqueconstraint will add extra duplicate Stephen Frost
 - Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane
 - Re: BUG #15180: Alter table add column if not exists with uniqueconstraint will add extra duplicate Stephen Frost
 - Re: Usage of pg_waldump Andres Freund
 - Re: Usage of pg_waldump Andres Freund
 - Re: Usage of pg_waldump David G. Johnston
 - Re: Usage of pg_waldump David G. Johnston
 - Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane
 - Re: BUG #15180: Alter table add column if not exists with uniqueconstraint will add extra duplicate David G. Johnston
 - BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences whenmigrating 9.1 10.3 PG Bug reporting form
 - Re: BUG #15180: Alter table add column if not exists with unique constraint will add extra duplicate Tom Lane
 
- Re: BUG #15183: pg_upgrade and pg_upgrade.exe both corrupt sequences when migrating 9.1 10.3 Tom Lane
 
- postgresql license question
 - Re: postgresql license question Heikki Linnakangas
 - BUG #15184: Planner overestimates number of rows in empty table PG Bug reporting form
 - Asia/Jakarta Timezone problem [email protected]
 - Re: Asia/Jakarta Timezone problem Tom Lane
 - RE: postgresql license question Greg Clough
 - BUG #15185: pg_dump doesn't include statistics when specifying a table PG Bug reporting form
 - Re: BUG #15185: pg_dump doesn't include statistics when specifying atable Alvaro Herrera
 - Re: BUG #15184: Planner overestimates number of rows in empty table Andrew Gierth
 
- BUG #15186: how get data from db files PG Bug reporting form
 - Re: BUG #15184: Planner overestimates number of rows in empty table Alexey Ermakov
 - BUG #15187: When use huge page,there may be a lot of hanged connections with status startup orauthentication PG Bug reporting form
 - Re: BUG #15187: When use huge page, there may be a lot of hanged connections with status startup or authentication Tom Lane
 - Re: BUG #15187: When use huge page, there may be a lot of hangedconnections with status startup or authentication Andres Freund
 - Re:Re: BUG #15187: When use huge page, there may be a lot of hangedconnections with status startup or authentication chenhj
 
- BUG #15188: wrong count "tuples removed" in autovacuum log file PG Bug reporting form
 
- Re:Re:Re: BUG #15187: When use huge page, there may be a lot ofhanged connections with status startup or authentication chenhj
 - Re: BUG #15187: When use huge page, there may be a lot of hangedconnections with status startup or authentication Andres Freund
 
- [BUG] Re-entering malloc problem when use --enable-nls build postgresql 158306855
 - Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane
 - Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql Andres Freund
 - BUG #15189: Could not connect to server PG Bug reporting form
 - Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane
 - Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql 158306855
 - Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql Andres Freund
 - Invalid precision for money datatype SriRaghu Sai Kasyap
 - Re: Invalid precision for money datatype David G. Johnston
 - Re: Invalid precision for money datatype Andrew Gierth
 - BUG #15190: Build configure should have option to disableclock_gettime on MacOS 10.12 and up. PG Bug reporting form
 - Re: BUG #15190: Build configure should have option to disable clock_gettime on MacOS 10.12 and up. Tom Lane
 - Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql Andres Freund
 
- Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Thomas Munro
 - Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql Andres Freund
 - Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane
 - Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql Andres Freund
 - Re: [BUG] Re-entering malloc problem when use --enable-nls build postgresql Tom Lane
 - BUG #15191: postgresql extension "uuid-ossp" Error PG Bug reporting form
 - Re: BUG #15191: postgresql extension "uuid-ossp" Error Michael Paquier
 - Re: BUG #15191: postgresql extension "uuid-ossp" Error Devrim Gündüz
 - Re: BUG #15190: Build configure should have option to disableclock_gettime on MacOS 10.12 and up. Marc Van Olmen
 - TOAST table repeatedly corrupted Niles Oien
 - TOAST table repeatedly corrupted David G. Johnston
 - Re: TOAST table repeatedly corrupted Tom Lane
 
- Re: TOAST table repeatedly corrupted Niles Oien
 - Re: TOAST table repeatedly corrupted Peter Geoghegan
 - Re: TOAST table repeatedly corrupted Tom Lane
 - the postgres process is not killed when the postmaster is killed 范国腾
 - Re: the postgres process is not killed when the postmaster is killed Michael Paquier
 - BUG #15192: Implement option to use columns order defined at CSV PG Bug reporting form
 - Re: BUG #15192: Implement option to use columns order defined at CSV Francisco Olarte
 - Re: BUG #15192: Implement option to use columns order defined at CSV KES
 
- RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Jonathan Allen
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - BUG #15193: Postgres Coredumped in AIX PG Bug reporting form
 
- Abnormal JSON query performance [email protected]
 - Re: Abnormal JSON query performance Pavel Stehule
 - Re: pg_upgradecluster 9.5 to 10.3 Christoph Berg
 - Re: Abnormal JSON query performance 007reader
 - Re: Abnormal JSON query performance Pavel Stehule
 - Re: Abnormal JSON query performance [email protected]
 - Re: Abnormal JSON query performance Pavel Stehule
 
- Re: Abnormal JSON query performance [email protected]
 - Re: Abnormal JSON query performance Pavel Stehule
 
- Cannot create an aggregate function with variadic parameters andenabled for parallel execution Alexey Bashtanov
 - BUG #15194: Strange results were displayed for select query. PG Bug reporting form
 - Re: BUG #15194: Strange results were displayed for select query. David G. Johnston
 - Re: BUG #15194: Strange results were displayed for select query. David Rowley
 - Re: Abnormal JSON query performance [email protected]
 - Abnormal JSON query performance David G. Johnston
 - Re: Abnormal JSON query performance Pavel Stehule
 - Re: Abnormal JSON query performance Tom Lane
 - "REVOKE ... ON DATABASE template1 ..." has no effect Ralf Jung
 - BUG #15195: Creation two subscription with the same name in differentdatabases PG Bug reporting form
 - Re: Abnormal JSON query performance Merlin Moncure
 - Re: Abnormal JSON query performance Tom Lane
 - Re: Abnormal JSON query performance David G. Johnston
 - BUG #15196: bogus data in lock file "postmaster.pid" PG Bug reporting form
 - Re: "REVOKE ... ON DATABASE template1 ..." has no effect Tom Lane
 - Re: Abnormal JSON query performance Tom Lane
 - Re: BUG #15196: bogus data in lock file "postmaster.pid" Tom Lane
 - Re: Abnormal JSON query performance David G. Johnston
 - BUG #15197: query tool not working PG Bug reporting form
 - Re: BUG #15197: query tool not working David G. Johnston
 - Re: "REVOKE ... ON DATABASE template1 ..." has no effect Gavin Flower
 
- Re: Abnormal JSON query performance 007reader
 - Re:Re: BUG #15187: When use huge page, there may be a lot of hangedconnections with status startup or authentication chenhj
 - Re: Abnormal JSON query performance Dmitry Dolgov
 - Re: "REVOKE ... ON DATABASE template1 ..." has no effect Ralf Jung
 - Re: Cannot create an aggregate function with variadic parameters andenabled for parallel execution Alexey Bashtanov
 - pg_ctl -D PGDATA stop -m fast gets the following message 57P03 FATAL: thedatabase system is shutting down [email protected]
 - Inconsistencies restoring public schema ownership from pg_dump Chris Pacejo
 - Re: Cannot create an aggregate function with variadic parameters and enabled for parallel execution Tom Lane
 - "order by" and "order by asc" returning different results on date field Rick Gentry
 - Re: "order by" and "order by asc" returning different results on date field Tom Lane
 - ERROR: subxact logged without previous toplevel record Euler Taveira
 - Re: ERROR: subxact logged without previous toplevel record Alvaro Herrera
 - Re: "order by" and "order by asc" returning different results on date field Rick Gentry
 - Re: ERROR: subxact logged without previous toplevel record Euler Taveira
 - Re: "order by" and "order by asc" returning different results on date field Tom Lane
 
- Re: ERROR: subxact logged without previous toplevel record Euler Taveira
 - Re: Abnormal JSON query performance reader 1001
 - Re: Abnormal JSON query performance David G. Johnston
 - Re: Abnormal JSON query performance Dmitry Dolgov
 - BUG #15198: nextval() accepts tables/indexes when adding a default toa column PG Bug reporting form
 - BUG #15199: relfrozenxid related corruption in pg_authid PG Bug reporting form
 - BUG #15200: Support ANSI OFFSET .. FETCH syntax with bind variables PG Bug reporting form
 - Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column Peter Eisentraut
 - issue with updatable cursors Peter Eisentraut
 - Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column David G. Johnston
 - Re: BUG #15198: nextval() accepts tables/indexes when adding a default to a column Tom Lane
 - Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column Peter Eisentraut
 - Re: Abnormal JSON query performance Tom Lane
 - Re: Abnormal JSON query performance Pavel Stehule
 - Re: Cannot create an aggregate function with variadic parameters andenabled for parallel execution Alexey Bashtanov
 - Re: "order by" and "order by asc" returning different results on date field Rick Gentry
 - Re: "order by" and "order by asc" returning different results on date field Feike Steenbergen
 - BUG #15201: PostGIS 2.3 fails to install for 9.6 on Fedora 28 PG Bug reporting form
 - Re: "order by" and "order by asc" returning different results on date field Rick Gentry
 - Re: Abnormal JSON query performance 007reader
 - Re: Abnormal JSON query performance 007reader
 - BUG #15202: Unexpected behavior with trigger fired on logicalreplicaion using pg_notify PG Bug reporting form
 
- BUG #15203: trigger does not recognize schema changes when passing ondata PG Bug reporting form
 - Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column Feike Steenbergen
 - Re: pg_ctl -D PGDATA stop -m fast gets the following message 57P03FATAL: the database system is shutting down Kyotaro HORIGUCHI
 - RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Huong Dangminh
 - Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column David G. Johnston
 - BUG #15204: Export to CSV doesn't work in Query tools PG Bug reporting form
 - Re: BUG #15204: Export to CSV doesn't work in Query tools David G. Johnston
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: Abnormal JSON query performance reader 1001
 - Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column Andres Freund
 - Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column Alvaro Herrera
 - BUG #15205: ERROR: table row type and query-specified row type do notmatch PG Bug reporting form
 - Re: BUG #15205: ERROR: table row type and query-specified row type donot match David G. Johnston
 
- Re: BUG #15198: nextval() accepts tables/indexes when adding adefault to a column Michael Paquier
 - Re: Abnormal JSON query performance Bruce Momjian
 - Re: BUG #15203: trigger does not recognize schema changes whenpassing on data Haribabu Kommi
 - RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Huong Dangminh
 - help please ! Marco Palombo
 - Re: BUG #15203: trigger does not recognize schema changes whenpassing on data [email protected]
 - Re: help please ! Fabio Pardi
 - Re: BUG #15203: trigger does not recognize schema changes whenpassing on data Haribabu Kommi
 - RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Huong Dangminh
 - Re: BUG #15203: trigger does not recognize schema changes when passing on data Tom Lane
 - Re: JDBC problem in 10.3 / 10.4 Dave Cramer
 - Re: JDBC problem in 10.3 / 10.4 Dave Cramer
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 
- postgres_fdw misbehaviour using "DELETE ... RETURNING *" Fabrízio de Royes Mello
 - BUG #15206: Can not import CSV into PostgreSQL PG Bug reporting form
 - Re: BUG #15206: Can not import CSV into PostgreSQL Pavel Stehule
 - Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston
 - Re:Re:Re: BUG #15187: When use huge page, there may be a lot ofhanged connections with status startup or authentication chenhj
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15206: Can not import CSV into PostgreSQL Andrew Gierth
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - RE: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Huong Dangminh
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: BUG #15206: Can not import CSV into PostgreSQL David G. Johnston
 - Re: BUG #15200: Support ANSI OFFSET .. FETCH syntax with bind variables Andrew Gierth
 
- Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 - Re: BUG #15206: Can not import CSV into PostgreSQL Peter J. Holzer
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15206: Can not import CSV into PostgreSQL Pavel Stehule
 - Re: BUG #15206: Can not import CSV into PostgreSQL Milorad Krstevski
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Andrew Dunstan
 - Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT Tom Lane
 
- Re: [BUG] Re-entering malloc problem when use --enable-nls buildpostgresql 158306855
 - crash while decoding INSERT ON CONFLICT Euler Taveira
 - Re: crash while decoding INSERT ON CONFLICT Andres Freund
 - Re: crash while decoding INSERT ON CONFLICT Peter Geoghegan
 - Re: crash while decoding INSERT ON CONFLICT Euler Taveira
 - Re: crash while decoding INSERT ON CONFLICT Peter Geoghegan
 - Re: crash while decoding INSERT ON CONFLICT Peter Geoghegan
 - Re: crash while decoding INSERT ON CONFLICT Euler Taveira
 
- Re: crash while decoding INSERT ON CONFLICT Peter Geoghegan
 - Re: crash while decoding INSERT ON CONFLICT Euler Taveira
 
- Re: [BUG] Re-entering malloc problem when use --enable-nlsbuildpostgresql Andres Freund
 - Re: postgres_fdw misbehaviour using "DELETE ... RETURNING *" Kyotaro HORIGUCHI
 - Re: [BUG] Re-entering malloc problem when use --enable-nlsbuildpostgresql 158306855
 - BUG #15207: In crash recovery,SyncDataDirectory() will fall into recursion trap PG Bug reporting form
 - Re: BUG #15207: In crash recovery, SyncDataDirectory() will fall into recursion trap Tom Lane
 - Re: BUG #15207: In crash recovery, SyncDataDirectory() will fallinto recursion trap Michael Paquier
 - Primary key error in INFORMATION_SCHEMA views SQLpro
 - Re: Primary key error in INFORMATION_SCHEMA views Tom Lane
 
- Re: BUG #14820: Standby crash with "could not access status oftransaction" (for track_commit_timestamp) Jeremy Schneider
 - 答复: BUG #15207: In crash recovery, SyncDataDirectory() will fall into recursion trap shao bret
 - PGADMIN4 V3.0 Error Anjul Tyagi
 - Re: PGADMIN4 V3.0 Error Anjul Tyagi
 - Re: PGADMIN4 V3.0 Error Anjul Tyagi
 - Re: Primary key error in INFORMATION_SCHEMA views SQLpro
 - Primary key error in INFORMATION_SCHEMA views David G. Johnston
 
- RE: PostgreSQL 2018-05-10 Security Update Release Huong Dangminh
 - Re: PostgreSQL 2018-05-10 Security Update Release Magnus Hagander
 - BUG #15208: COALESCE with CTE returns NULL PG Bug reporting form
 - Re: BUG #15208: COALESCE with CTE returns NULL Sergei Kornilov
 - Re: BUG #15208: COALESCE with CTE returns NULL Tom Lane
 - BUG #15209: Problem with string value in installer PG Bug reporting form
 - Re: BUG #15208: COALESCE with CTE returns NULL Rick Gabriel
 - BUG #15210: Internal Server Error When Attempting to Look at TriggerFunctions PG Bug reporting form
 - Re: BUG #15210: Internal Server Error When Attempting to Look atTrigger Functions David G. Johnston
 - Re: BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions Tom Lane
 - Re: BUG #15210: Internal Server Error When Attempting to Look atTrigger Functions Petty, Diana
 - Re: BUG #15210: Internal Server Error When Attempting to Look at Trigger Functions Tom Lane
 - BUG #15211: Urjent PG Bug reporting form
 - Re: BUG #15211: Urjent David G. Johnston
 - Re: Primary key error in INFORMATION_SCHEMA views Sve@r
 
- BUG #15212: Default values in partition tables don't work as expectedand allow NOT NULL violation PG Bug reporting form
 - RE: PostgreSQL 2018-05-10 Security Update Release Huong Dangminh
 
- BUG #15213: unable to login on PostgreSQL by postgres user PG Bug reporting form
 - Re: BUG #15213: unable to login on PostgreSQL by postgres user Arthur Zakirov
 - BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit PG Bug reporting form
 - Re: BUG #15213: unable to login on PostgreSQL by postgres user dhirendra Singh
 - Re: BUG #15213: unable to login on PostgreSQL by postgres user Arthur Zakirov
 - Re: BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit Jeff Janes
 - RE: BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit Narayanan, Senthilkumar
 - Re: BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit Thomas Kellerer
 - BUG #15215: Error BACKUP PLAIN PG Bug reporting form
 - BUG #15216: for test new Web ERP/CRM PG Bug reporting form
 
- [BUG] postgresql replaying WAL slowly when master drop a large number of relations in one transaction 158306855
 - BUG #15217: Valgrind - writing uninitialised byte(s) in FileWrite PG Bug reporting form
 - Re: BUG #15217: Valgrind - writing uninitialised byte(s) in FileWrite Peter Geoghegan
 - Re: BUG #15217: Valgrind - writing uninitialised byte(s) in FileWrite Alexander Lakhin
 - BUG #15218: compilation of a function is correct while its executionis in error PG Bug reporting form
 - Re: BUG #15218: compilation of a function is correct while itsexecution is in error Heikki Linnakangas
 - Re: BUG #15218: compilation of a function is correct while its execution is in error Sergei Kornilov
 - BUG #15219: Increase Max Open Files issue PG Bug reporting form
 - BUG #15220: upgrade PG Bug reporting form
 - Re: BUG #15220: upgrade David G. Johnston
 - Re: [BUG] postgresql replaying WAL slowly when master drop a largenumber of relations in one transaction Michael Paquier
 - BUG: postgresql.auto.conf location Alexandr Blinov
 - Re: BUG: postgresql.auto.conf location David G. Johnston
 - Re: BUG: postgresql.auto.conf location Tom Lane
 
- Re: [BUG] postgresql replaying WAL slowly when master drop a largenumber of relations in one transaction 158306855
 - Re: BUG #15214: Pg 10.4 windows 64 bit installer is 32 bit Vik Fearing
 - BUG #15221: Could not open file "pg_subtrans/0013" PG Bug reporting form
 - Re: BUG #15221: Could not open file "pg_subtrans/0013" Tom Lane
 - BUG #15222: pg_isready fails connection after previous pg_isreadyclaims success PG Bug reporting form
 - Re: BUG #15222: pg_isready fails connection after previous pg_isready claims success Tom Lane