[SQL] Change definition of a view

2006-02-09 Thread Andreas Roth
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

[SQL] Trigger for Large Object Modification

2006-01-15 Thread 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 (