On Thu, Jan 25, 2018 at 10:26 PM, Peter Eisentraut <peter.eisentr...@2ndquadrant.com> wrote: >> Does the SQL spec mention the matter? How do other systems >> handle such cases? > > In Oracle you get the same overflow error.
That seems awful. If a user says "SELECT * FROM tab" and it fails, how are they supposed to recover, or even understand what the problem is? I think we should really try to at least generate an errcontext here: ERROR: integer out of range CONTEXT: while generating virtual column "b" And maybe a hint, too, like "try excluding this column". -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company