R: R: [postgresql-it] [HACKERS] no cascade triggers?

2007-07-02 Thread Manera, Villiam
> To be honest..No trigger necessary... I have 1300 triggers and 345 functions (53500 lines of code), most of them written 15 years ago for ALLBASE/SQL (the old Hewlett Packard relational dbms) and converted to pl/pgsql last year. I admit that some of them may look eccentric, but some of them a

Re: R: [postgresql-it] [HACKERS] no cascade triggers?

2007-06-27 Thread Martijn van Oosterhout
On Wed, Jun 27, 2007 at 11:37:01AM +0200, Manera, Villiam wrote: > To better explain my problem I attach one of my functions that is easy > to understand. > > For each of my products I must have one main supplier and I may have > also some secondary suppliers. > > Therefore for each of my articl

R: [postgresql-it] [HACKERS] no cascade triggers?

2007-06-27 Thread Manera, Villiam
Tom Lane wrote: We could possibly re-allow that (see the comments in AlterTable()) but it seems like an ugly and inefficient technique that we shouldn't be encouraging. (The implications for system catalog bloat alone seem enough reason to not recommend this.) Isn't there a cleaner way to design