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

Quote:

Originally Posted by 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)

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

mateusz1984

Quote:

Originally Posted by rski

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

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

Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

re: Automatic deleting views of table in PostgreSql

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about