[SQL] Trigger for Large Object Modification

[Andreas Roth]

Hello,

I created a table with a OID Column to carry the identifier for a Large 
Object. 
Now i want to run a trigger is the data of the large object has changed. To do 
this I created an ON UPDATE-trigger on the table, but the trigger does get 
fired if i only change the data of the large object (not its id).

Is there any way to get notified if a large object has changed?

Thanks in advance,
A. Roth

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[SQL] Change definition of a view

[Andreas Roth]

Hello,

one question: Is it possible to add or remove a column from a view without 
drop the view and recreate it?

If one or more rules depend on a view, it's very hard to extend a view. 
I use the following procedure to extend a view:
- drop depending rules
- drop view
- recreate view with additional column
- recreate all rules

Any help is welcomed!

Thanks,
Andreas Roth

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings