The following bug has been logged on the website: Bug reference: 14486 Logged by: Per Modin Email address: web+postgresql@modin.io PostgreSQL version: 9.6.1 Operating system: Linux 303a92173594 4.8.15-moby #1 SMP Sat Dec 17 0 Description: Found this bug in 9.4.8, tried it in docker towards psql 9.6.1 and it's in there as well. A minimum working example would be as follows: ``` postgres=# CREATE TABLE tbl AS SELECT 9223372036854 * interval '1 second' col; TABLE tbl; SELECT 1 ERROR: interval out of range ``` ``` postgres=# SELECT count(*) FROM tbl; count ------- 1 (1 row) ``` It seems that inserting and retrieving data have different constraints. As you can see from query 2, the data still gets inserted. ``` postgres=# select version(); version ------------------------------------------------------------------------------------------ PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit (1 row) ``` Best regards, Per Modin
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных