| From: | Hans-Juergen Schoenig <postgres(at)cybertec(dot)at> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5 |
| Date: | 2009-05-11 08:26:52 |
| Message-ID: | 4A07E14C.3030906@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
hello everybody,
i would like to propose an extension to our SELECT FOR UPDATE mechanism.
especially in web applications it can be extremely useful to have the
chance to terminate a lock after a given timeframe.
i would like to add this functionality to PostgreSQL 8.5.
the oracle syntax is quite clear and easy to use here:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2126016
informix should behave pretty much the same way.
are there any arguments from hackers' side against this feature?
many thanks,
hans
--
Cybertec Schönig & Schönig GmbH
Professional PostgreSQL Consulting, Support, Training
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: www.postgresql-support.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2009-05-11 08:29:46 | Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5 |
| Previous Message | Magnus Hagander | 2009-05-11 08:09:33 | Re: [PATCH] Automatic client certificate selection support for libpq v1 |