Le portail francophone de la géomatique

create table db_management.tableref (user_name varchar, date_action date, table_name name, action_type text, object_type text , objid oid) ;

create or replace function report_user ()
returns event_trigger 
as $$
declare 
r record ; 
begin
    for r in select * from pg_event_trigger_ddl_commands () loop 
        insert into db_management.tableref (user_name, date_action, table_name, action_type, object_type, objid)
        select current_user, current_date, pgc.relname, current_query(), r.object_type, r.objid
        from pg_clas as pgc where pgc.oid = r.oid ;
    end loop ;
end;
$$
language plpgsql ; 

create event trigger report_user_action on ddl_command_end
execute procedure report_user () ;

ERREUR: la fonction pg_event_trigger_ddl_commands() n'existe pas
État SQL :42883
Astuce : Aucune fonction ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.