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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-11-26 18:27:25 | Re: CHECK evaluation error when using more than one table |
Previous Message | Peter Eisentraut | 2000-11-25 15:52:05 | Re: Docs should clearly say that geometric types must be inserted as strings. |