Automatic deleting views of table in PostgreSql

[mateusz1984]

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

[rski]

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

[mateusz1984]

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

[rski]

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ć :)

[mateusz1984]

Thanks

I'll try to do it now

Dzięki:)

[mateusz1984]

Hi

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

Thanks

[mateusz1984]

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)

[rski]

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?

[mateusz1984]

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

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