Automatic deleting views of table in PostgreSql

Hi

I have a problem with deleting all views od tables in PostgreSql.

I have the table with name "tab1" and it has a view with name "view1". Do you know how to dynamic delete all views when the name of the table "tab1" will be changed?

Sorry for my english

Thanks

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