Re: [SQL] transaction and triggers

2008-01-18 Thread D'Arcy J.M. Cain
On Fri, 18 Jan 2008 12:16:04 -0300 Gerardo Herzig <[EMAIL PROTECTED]> wrote: > Right. But today, that trigger do some other work, wich includes > writing some files to disk, so there is my problem. Crap, i guess i will > have to review the main logic. I built a replication system that syncs up

Re: [SQL] transaction and triggers

2008-01-18 Thread Gerardo Herzig
Alvaro Herrera wrote: Gerardo Herzig escribió: Right. But today, that trigger do some other work, wich includes writing some files to disk, so there is my problem. Crap, i guess i will have to review the main logic. Probably it's better to move the actual file writing to a listene

Re: [SQL] transaction and triggers

2008-01-18 Thread Alvaro Herrera
Gerardo Herzig escribió: > Right. But today, that trigger do some other work, wich includes writing > some files to disk, so there is my problem. Crap, i guess i will have to > review the main logic. Probably it's better to move the actual file writing to a listener external process -- the tr

Re: [SQL] transaction and triggers

2008-01-18 Thread Gerardo Herzig
Filip Rembiałkowski wrote: 2008/1/18, Gerardo Herzig <[EMAIL PROTECTED]>: Hi all. Im puzzled again. Just thinking: As im having fun trying to make my own replication system, im stuck in this situation: Consider a simple table with a unique index on the `id' field, and a function who will fa

Re: [SQL] transaction and triggers

2008-01-18 Thread Filip Rembiałkowski
2008/1/18, Gerardo Herzig <[EMAIL PROTECTED]>: > Hi all. Im puzzled again. Just thinking: > > As im having fun trying to make my own replication system, im stuck in > this situation: > Consider a simple table with a unique index on the `id' field, and a > function who will fail, such as > > insert

[SQL] transaction and triggers

2008-01-18 Thread Gerardo Herzig
Hi all. Im puzzled again. Just thinking: As im having fun trying to make my own replication system, im stuck in this situation: Consider a simple table with a unique index on the `id' field, and a function who will fail, such as insert into test (id) values (1); insert into test (id) values (