Select Code to Download

 CREATE SEQUENCE asset_seq;
 CREATE TABLE assets (
...
 CREATE TABLE mediaasset (
     media_id integer not null unique
 ) INHERITS (assets);

 /* From your command prompt type
    createlang plpgsql <database name> 
...
 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
     HANDLER "plpgsql_call_handler"
     LANCOMPILER 'PL/pgSQL';

 CREATE FUNCTION asset_id_ins_upd () RETURNS OPAQUE AS '
 DECLARE
...
 
 CREATE TRIGGER assets_asset_id_ins_upd BEFORE INSERT OR UPDATE ON ass
+ets
     FOR EACH ROW EXECUTE PROCEDURE asset_id_ins_upd();