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