Skip site navigation (1) Skip section navigation (2)

CHECK evaluation error when using more than one table

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: CHECK evaluation error when using more than one table
Date: 2000-11-26 15:57:33
Message-ID: 200011261557.eAQFvXE76510@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Pedro Alves (pmalves(at)cosmos(dot)inesc(dot)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 expression type 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


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-11-26 18:27:25
Subject: Re: CHECK evaluation error when using more than one table
Previous:From: Peter EisentrautDate: 2000-11-25 15:52:05
Subject: Re: Docs should clearly say that geometric types must be inserted as strings.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group