create rule

This won't work:

CREATE TABLE pub_gene (
pub_gene_id serial PRIMARY KEY,
name varchar(200) default NULL
);

CREATE TABLE term (
term_id serial PRIMARY KEY,
name varchar(200) default NULL,
pub_gene_id INTEGER references pub_gene
ON UPDATE CASCADE
ON DELETE SET NULL
);

CREATE RULE pub_gene_insert_term AS -- INSERT rule
ON INSERT TO pub_gene
DO
insert into term(term_id, name, date_entered,
entered_by )
values (nextval('term_term_id_seq'),
(select name from pub_gene where
pub_gene_id=currval('pub_gene_pub_gene_id_seq'))
)
);

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com