Search Postgresql Archives

For Tom Lane (Msg-ID: <IH5LKE$51FADB513BB3BB27F05E974EBE1A0558@xxxxxxxxx>)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> "gabriele zelasco" <rubensoda@xxxxxxxxx> writes:
> > I would like to start a transaction with a sql function.
> > When user press "edit" button on my form, i would lock the current row.
> > After user has modified data on form, pressing "save" button I would save t=
> > he modified row by sql update function and so commit.
>


> This is widely considered a very bad way to design an application.
> Consider what happens when the user leaves for lunch, or otherwise
> lets the app sit for a long time.  See the list archives for prior
> discussions of the issue.
>
> But in any case, the answer to your question is to use "SELECT FOR
> UPDATE" to retrieve the row.  And you can't start a transaction
> inside a function, because by definition you'll already be in one.
> 
> 			regards, tom lane
>

Thanks for answer Tom

"Consider what happens when the user leaves for lunch"

Well, I've already thought about it.But I'm working with
VS2003 and disconnected dataset.. so when user edit data
he's modifying an "old" disconnected row, while real updated row
is in the database..
So my strategy would be (as I already written):

1. refresh data recalling current row from database to the form's fields
2. lock the row
3. update modified data in the database through stored procedure (function)
4. commit and unlock the row

Have you another idea that could work better with disconnected objects ?



the answer to your question is to use "SELECT FOR UPDATE" to retrieve the row

Well, I've created a sql function with just sql command :
select * from table where condition FOR UPDATE
but it doesn't lock the row !

If I write "begin;" before command , inside function,
I get the error (begin is not allowed...)

So what I have to do if I would lock a row from inside vb net code?
Thanx in advance



____________________________________________________________
Navighi a 4 MEGA e i primi 3 mesi sono GRATIS. 
Scegli Libero Adsl Flat senza limiti su http://www.libero.it



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux