Re: [GENERAL] Update more than one table

2005-07-12 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-12 12:11:45 -0500: > On Tue, Jul 12, 2005 at 17:35:35 +0200, > Roman Neuhauser <[EMAIL PROTECTED]> wrote: > > # [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500: > > > On Sun, Jul 10, 2005 at 15:05:30 -0300, > > > David Pratt <[EMAIL PROTECTED]> wrote: > > > > I was t

Re: [GENERAL] Update more than one table

2005-07-12 Thread David Pratt
Hi Bruno and Roman. I am attempting to implement your advice. Bruno, how do I make a foreign key deferable since this sounds like an interesting approach. I have got another problem on top of the first. For the first two inserts I need to insert a multi-dimensional array into one of the field

Re: [GENERAL] Update more than one table

2005-07-12 Thread Bruno Wolff III
On Tue, Jul 12, 2005 at 17:35:35 +0200, Roman Neuhauser <[EMAIL PROTECTED]> wrote: > # [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500: > > On Sun, Jul 10, 2005 at 15:05:30 -0300, > > David Pratt <[EMAIL PROTECTED]> wrote: > > > Hi Roman. Many thanks for your reply. This is interesting and will

Re: [GENERAL] Update more than one table

2005-07-12 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-12 10:08:37 -0500: > On Sun, Jul 10, 2005 at 15:05:30 -0300, > David Pratt <[EMAIL PROTECTED]> wrote: > > Hi Roman. Many thanks for your reply. This is interesting and will I > > give this a try and let you know how it works out. With this you are > > right, appl

Re: [GENERAL] Update more than one table

2005-07-12 Thread Bruno Wolff III
On Sun, Jul 10, 2005 at 15:05:30 -0300, David Pratt <[EMAIL PROTECTED]> wrote: > Hi Roman. Many thanks for your reply. This is interesting and will I > give this a try and let you know how it works out. With this you are > right, application logic and transaction don't have to be separate >

Re: [GENERAL] Update more than one table

2005-07-10 Thread David Pratt
Hi Roman. Many thanks for your reply. This is interesting and will I give this a try and let you know how it works out. With this you are right, application logic and transaction don't have to be separate which would be nice for this. I was thinking the only way to solve was a function that

Re: [GENERAL] Update more than one table

2005-07-10 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-09 22:55:26 -0300: > Hi. I have a form that collects information from the user but then I > need to update three separate tables from what the user has submitted. > I could do this with application logic but I would feel it would be > best handled in Postgres as a t

[GENERAL] Update more than one table

2005-07-09 Thread David Pratt
Hi. I have a form that collects information from the user but then I need to update three separate tables from what the user has submitted. I could do this with application logic but I would feel it would be best handled in Postgres as a transaction. I need to do things in this order to satisf