Automatic deleting views of table in PostgreSql

to be clear you want to delete views of a table when its (mean table) name changed?

Yes, I want to delete views of a table when its name changed

I didn't try it but there may be some solutions
1) with postgresql root privileges you can create trigger on pg_class wich will delete all views for a table which is altered (if i found comp with root accout on postgres i'll try do that and write it down here)
2) do alter on table and views removing via a some function, you should write.

Powinno zadziałać :)

Thanks

I'll try to do it now

Dzięki:)

Hi

Unfortunately I haven't done this problem yet :( I really need help

Thanks

Hi

I want to write some function in plpgsql which will be located into trigger later, this function must delete views of a table when its name was changed to another one (all views must be deleted)

What about views which are defined on more than one table?

All views created on many tables must be deleted when tables are altered