CHECK evaluation error when using more than one table - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject CHECK evaluation error when using more than one table
Date
Msg-id 200011261557.eAQFvXE76510@hub.org
Whole thread Raw
Responses Re: CHECK evaluation error when using more than one table
List pgsql-bugs
Pedro Alves (pmalves@cosmos.inesc.pt) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
CHECK evaluation error when using more than one table

Long Description
Creating a table with the code shown, everytime I try to insert values I get the same "ERROR: ExecEvalExpr: unknown
expressiontype 108" 

Sample Code
CREATE TABLE ninhada (
    c_id_mae int,
    n_id int,
    c_id_pai int,
    n_dta_nasc date,
    PRIMARY KEY (n_id, c_id_mae),
    FOREIGN KEY (c_id_mae) REFERENCES caes (c_id)
       ON DELETE CASCADE,
    FOREIGN KEY (c_id_pai) REFERENCES caes (c_id)
   ,
     CHECK (c_id_mae in
        (select c.c_id from caes c  where caes.c_id=c_id_mae AND c.c_sexo=0)
     )
);

No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Docs should clearly say that geometric types must be inserted as strings.
Next
From: Tom Lane
Date:
Subject: Re: CHECK evaluation error when using more than one table