some problems

Ahoy!

Hi!
I have the following table:

create table address
(
        id              int4 primary key,
        owner           int4 not null,
        content         varchar(80) not null
        CHECK (owner in (select id from id where t_name in ('org',
'person',
'router', 'dns')))
);
create trigger delete_id before delete
    on address for each row execute procedure delete_id();
create trigger set_id before insert
    on address for each row execute procedure set_id();

Everything seems OK, but when I type this:

ripv=# insert into address values(0, 18, 'Szeged');

I get an error:

ERROR:  ExecEvalExpr: unknown expression type 108

But these queries work:

ripv=# select 18 in (select id from id where t_name in ('org', 'person',
'router', 'dns'));
 ?column?
----------
 t
(1 row)

ripv=# select id from id where t_name in ('org', 'person', 'router',
'dns');
 id
----
  5
 18
(2 rows)

ripv=#

Any comment?


--
Roodie                    ICQ: 53623985
 Linux, C++, VB, SQL, PhotoShop, Lightwave
 Ars Magica,  AD&D,  Mutant Chronicles