Обсуждение: triggers, rules and alter table

Hi, List!

I'm using pg 8.1.0

this version allows to create triggers on INSERT, DELETE and UPDATE and also allows to create rules on SELECT, UPDATE, INSERT and DELETE.
But I want to do some actions on ALTER TABLE ... ADD COLUMN and ALTER TABLE ... DROP COLUMN events. How I can handle that events in 8.1.x version?


Sergey Karin

Sergey Karin wrote:
> Hi, List!
>
> I'm using pg 8.1.0
>
> this version allows to create triggers on INSERT, DELETE and UPDATE and also
> allows to create rules on SELECT, UPDATE, INSERT and DELETE.
> But I want to do some actions on ALTER TABLE ... ADD COLUMN and ALTER TABLE
> ... DROP COLUMN events. How I can handle that events in 8.1.x version?

You can't. There aren't any hooks to attach triggers to for those actions.

Could you wrap your ALTER TABLE commands in a function?

--
   Richard Huxton
   Archonet Ltd