On Mon, Aug 24, 2020 at 5:32 AM Greg Nancarrow <gregn4...@gmail.com> wrote: > For example, > > log_file_mode = 384.234 > max_connections = 1.0067e2 > port = 5432.123 > CREATE TABLE ... WITH (fillfactor = 23.45); > CREATE TABLE ... WITH (parallel_workers = 5.4);
I don't think any of these cases should be allowed. Surely if we allowed 384.234 to be inserted into an integer column, everyone would say that we'd lost our minds. These cases seem no different. The discussion to which the commit links is mainly about allowing 0.2s to work like 200ms, or something of that sort, when the value is specified as a fraction but works out to an integer when converted to the base unit. That is a completely different thing from letting people configure 5.4 parallel workers. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company