BUG #14296: weird check constraint clause in pg_constraint

From: ralf(at)rw7(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14296: weird check constraint clause in pg_constraint
Date: 2016-08-26 14:49:58
Message-ID: 20160826144958.15674.41360@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14296
Logged by: Ralf Wiebicke
Email address: ralf(at)rw7(dot)de
PostgreSQL version: 9.5.4
Operating system: Linux
Description:

I created two tables

CREATE Table tabgood ( col integer, CONSTRAINT checker CHECK ( col>0 ))
CREATE Table tabbad ( col integer, CONSTRAINT checker CHECK ( col>-1 ))

and fetch the check constraints from pg_constraint

SELECT ut.relname,uc.conname,uc.consrc
FROM pg_constraint uc INNER JOIN pg_class ut ON uc.conrelid=ut.oid
WHERE uc.contype='c'

the I get:

"tabgood";"checker";"(col > 0)"
"tabbad";"checker";"(col > '-1'::integer)"

The second clause is weird, although working. it should be just "col >
-1".

This problem is observed seen on PostgresSQL 9.5.4, it was not observed on
9.3.14.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2016-08-26 15:06:20 Re: Errors Installing PostgresSQL
Previous Message Joe Gitter 2016-08-26 14:32:03 Errors Installing PostgresSQL