On 11.03.2011 20:59, Robert Haas wrote:
> On Tue, Mar 8, 2011 at 4:44 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>> Add missing keywords to gram.y's unreserved_keywords list.
>>
>> We really need an automated check for this ... and did VALIDATE really
>> need to become a keyword at all, rather than picking some other syntax
>> using existing keywords?
>
> I think we ought to try to do something about this, so that VALIDATE
> doesn't need to become a keyword.
>
> How about instead of VALIDATE CONSTRAINT we simply write ALTER
> CONSTRAINT ... VALID? (Patch attached, passes make check.)
ALTER CONSTRAINT ... VALID sounds like it just marks the constraint as
valid. "VALIDATE CONSTRAINT" sounds like it scans and checks that the
constraint is valid.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com