Re: Bug report CHECK CONSTRAINTS

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Pavel Veretennikov <vermut(at)kid(dot)lv>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Bug report CHECK CONSTRAINTS
Date: 2004-07-12 13:16:12
Message-ID: 40F28F1C.6050204@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Pavel Veretennikov wrote:

>
> CONSTRAINT "$1" CHECK sex >= 0,
> CONSTRAINT "$2" CHECK "type" >= 0
> )
> WITH OIDS;
>
> When trying to copy-paste-run it, it complains about CHECK
> contstraints, cause they should be written like
> CONSTRAINT "$1" CHECK (sex >= 0),
> CONSTRAINT "$2" CHECK ("type" >= 0)

You're right, table reengineering misses the parentheses (the constraint
itself shows it).
Fixed in CVS, thanks for reporting.

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2004-07-12 14:07:21 Re: Secure DB Systems - How to
Previous Message Pavel Veretennikov 2004-07-12 09:18:46 Bug report CHECK CONSTRAINTS