Re: [SQL] triggers on commit

2004-03-19 Thread Erik Thiele
On Fri, 19 Mar 2004 10:13:56 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > Erik Thiele <[EMAIL PROTECTED]> writes: > > now. what i wanted to do is ensure that this is done correctly and > > otherwise abort the transaction. > > of course this check needs to be done at the commit time, because if > >

Re: [SQL] triggers on commit

2004-03-19 Thread Tom Lane
Erik Thiele <[EMAIL PROTECTED]> writes: > now. what i wanted to do is ensure that this is done correctly and > otherwise abort the transaction. > of course this check needs to be done at the commit time, because if i > do it on statement level, it cannot work, since i cannot change two > tables at

[SQL] triggers on commit

2004-03-19 Thread Erik Thiele
Hi! I am having a probably stupid question, but anyway I can't find it's solution. it should be a novice question, but lets see :)) I have 2 tables. calendar: person_id INTEGER when DATE type TEXT holiday: person_id INTEGER assigned_to DATE last_possible_assignment DATE the idea he