Re: [GENERAL] ALTER FUNCTION

Adriaan Joubert <a(dot)joubert(at)albourne(dot)com> writes:

| Just drop the function, drop all triggers that use the function,
| re-create the function and recreate all triggers. If the function is
| called by other PL functions, you need to drop and re-install those as
| well. If you keep them all in a big file, every one preceded by drop,
| you can just reload the file (with \i into psql) whenever you have
| changed something. No need to dump any data.

When I use the function in a CHECK constrain of a table, I have to
destroy the table. Or is it possible to refresh the reference to the
function by an ALTER TABLE statement?

By the way: when I drop a table that is used by another table via
INHERITS, I get the warning, that the table is used and that I can not
drop it. Why are functions handled different? I is really a problem,
when there are broken tables in a database and nobody knows it.

Sascha