• Support for dark visual theme added.
• SSL implemented.
• Unicode names of objects are now supported.
• Support for Windows 11 ARM added.
• Updated SSH library with ECDSA, Ed25519 keys and Keyboard-interactive authentication method support.
• Support for PostgreSQL 16.
• JSON data type is now supported.
• Schema selection is now available.
• Encoding option for script file has been added.
• Files with test data are now supplied with the program installation pack.
• Many other improvements and fixes.

Example flow is on the image. Here I want to accomplish if playlist removed, make it delete image too.

I know I should've put FK on image table but Image is generic and its used more than once.

What are my options? Triggers and application-side comes to mind, but I'm not sure. Maybe there is a better way.

UPDATE: I guess I've found what I was looking for, rules:

CREATE RULE playlist_delete AS ON DELETE TO playlist WHERE (SELECT id FROM image WHERE image.id = OLD.image_id) IS NOT NULL DO INSTEAD NOTHING;