Re: [GENERAL] Transactions, Triggers and Error Messages

2005-11-08 Thread Richard Huxton
Ledina Hido wrote: Thinking about it, the EXCEPTION statement would be inside my user- defined function (where I raise the exception in the first place), so I cannot see how that would help. As far as I could understand, I cannot call "ROLLBACK" (which is what I want to do) inside a user d

Re: [GENERAL] Transactions, Triggers and Error Messages

2005-11-08 Thread Ledina Hido
On Tue, Nov 08, 2005 at 11:03:50PM +, Ledina Hido wrote:> Quoting Tom Lane <[EMAIL PROTECTED]>:> > > What are you running this in?  ISTM this is a problem with bad  > structure> > of client-side code, not something to be fixed on the server side.> >> >                         regards, tom lane>

Re: [GENERAL] Transactions, Triggers and Error Messages

2005-11-08 Thread Ledina Hido
That's great. Thank you very much for you help.LedinaOn Tue, Nov 08, 2005 at 11:03:50PM +, Ledina Hido wrote:> Quoting Tom Lane <[EMAIL PROTECTED]>:> > > What are you running this in?  ISTM this is a problem with bad  > structure> > of client-side code, not something to be fixed on the server s

Re: [GENERAL] Transactions, Triggers and Error Messages

2005-11-08 Thread Jim C. Nasby
On Tue, Nov 08, 2005 at 11:03:50PM +, Ledina Hido wrote: > Quoting Tom Lane <[EMAIL PROTECTED]>: > > > What are you running this in? ISTM this is a problem with bad > structure > > of client-side code, not something to be fixed on the server side. > > > > regards, tom la

Re: [GENERAL] Transactions, Triggers and Error Messages

2005-11-08 Thread Ledina Hido
Quoting Tom Lane <[EMAIL PROTECTED]>: > What are you running this in? ISTM this is a problem with bad structure > of client-side code, not something to be fixed on the server side. > >regards, tom lane I'm using pgAdmin3. Basically when I run the query the first time it

Re: [GENERAL] Transactions, Triggers and Error Messages

2005-11-08 Thread Tom Lane
Ledina Hido <[EMAIL PROTECTED]> writes: > Now when I run the following (after inserting person with id=5 into > pers table): > begin; > set constraints all deferred; > insert into tasks (pid, task) values (5, 'firstTask'); > insert into tasks (pid, task) values (5, 'secondTask'); > insert into t