| From: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
|---|---|
| To: | Dr NoName <spamacct11(at)yahoo(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgresql locks the whole table! |
| Date: | 2003-12-03 22:20:27 |
| Message-ID: | BBF3AFBB.3B792%scott_ribe@killerbytes.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> The deferred foreign key checks are exactly
> what I needed. They are quite useful for other reasons
> too.
I believe Postgres is just following standards.
Yes, deferred is very useful for other things, like a real data model layer
mediating between UI and database--without it you have to worry about
performing inserts (and updates) in a particular order. That can be really
painful to code, and in some cases (cyclic relationships) impossible to do
except by leaving some constraints out.
--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boris Popov | 2003-12-03 22:47:23 | [Fedora Core 1] yum repositories with 7.4? |
| Previous Message | Eric Soroos | 2003-12-03 22:19:18 | Re: Upgrading from 7.2.3 to....?? |