I would like to disable the DELETE statement on a table.
What I need to do is a SET a field value instead of removing the respective record.

So far I have tried the following:

```
CREATE TRIGGER delete_trg
INSTEAD OF DELETE
ON schema.tbl
FOR EACH ROW
EXECUTE PROCEDURE schema.tbl_delete_fn();

```

My `schema.tbl_delete_fn()` function is as follows:

```
CREATE OR REPLACE FUNCTION schema.tbl_delete_fn()
  RETURNS trigger AS
BEGIN
  NEW.deleted := true;

  RETURN NEW;
END;

```

So far this doesn't seem to work... any ideas?