create view msaccess.countries as select CountryID::int4, Name from countries;

ALTER TABLE msaccess.countries ALTER COLUMN CountryID SET DEFAULT nextval('Countries_pk_seq'::regclass);

CREATE OR REPLACE RULE "_INSERT" AS
    ON INSERT TO msaccess.countries DO INSTEAD
       (
       SELECT FW_ObjectBeforeCreate( 0 , nextval('Countries_pk_seq')::int4,  79 , null, null);
       INSERT INTO countries (CountryID, name) VALUES (CURRVAL('Countries_pk_seq'),NEW.name);
       SELECT FW_ObjectAfterCreate( 0 , CURRVAL('Countries_pk_seq')::int4,  79 , true);

       );

CREATE OR REPLACE RULE "_INSERT" AS
    ON INSERT TO msaccess.countries DO INSTEAD   (
       SELECT msaccess.countrygen(NEW.name);
         );

CREATE OR REPLACE FUNCTION msaccess.countrygen(in_Name VARCHAR( 64 )) RETURNS ?ЧтоИменно?  AS $$
DECLARE
   seq_id  INT8;
BEGIN
   seq_id:=NEXTVAL('Countries_pk_seq');
   PERFORM FW_ObjectBeforeCreate( 0 , seq_id::int4,  79 , null, null);
   INSERT INTO countries (CountryID, name) VALUES (seq_id::int4, in_Name);
   PERFORM FW_ObjectAfterCreate( 0 , seq_id::int4,  79 , true);

RETURN   ?ЧтоИменно?  ;
END;
$$ language 'plpgsql' security definer;

CREATE OR REPLACE RULE "_INSERT" AS
    ON INSERT TO msaccess.countries DO INSTEAD   (
       SELECT msaccess.countrygen(NEW.name);
       INSERT INTO countries (CountryID, name) VALUES (NEXTVAL('Countries_pk_seq'), NEW.name);
      );