Message-ID: <20050307082943.2333.qmail@web51402.mail.yahoo.com>
Date: Mon, 7 Mar 2005 09:29:43 +0100 (CET)
From: Mauro Bertoli <bertolima@yahoo.it>
Subject: Re: Postgres performance
To: PFC <lists@boutiquenumerique.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: 6667
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> > Yes, you are rigth... my insert/update are very
> simple
> > and without problems and so I think to use
> 'foreign
> > key' coded to make faster/simpler the management
> and
> > don't overloading the db (and use exception code
> > management )... but I had a problem with pgSQL
> because
> > server was very busy and the same query was
> replicate
> > (because users refresh the page... :( ) so now
> I've
> > foreign keys...
> 
> 	It's a typical case, program being stopped between
> insertion of parent  
> and child row. Although in this case FK's is not the
> solution,  
> transactions are.
I insert a tuple (in the table answers) if the key
'iduser->idquestion' don't exists but when the key
exists I update the value; this is coded in php
because I have thought that otherwise I must use
functions... there's no parent/child rows... how can I
use transactions here?

Mauro


___________________________________ 
Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… Scaricalo ora! 
http://it.messenger.yahoo.it