diff options
author | Bruce Momjian <bruce@momjian.us> | 2004-08-24 11:09:44 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2004-08-24 11:09:44 +0000 |
commit | 4359ebed37b2387c7ef7c4fe078992ccc789ee93 (patch) | |
tree | 74031ceeb82515d82fbdc458e7b4ed88b5da0629 | |
parent | cda1bd6cfe8cad9943f0c1991b690313b5be9bef (diff) | |
download | postgresql-4359ebed37b2387c7ef7c4fe078992ccc789ee93.tar.gz postgresql-4359ebed37b2387c7ef7c4fe078992ccc789ee93.zip |
Update item:
< * Implement dirty reads or shared row locks and use them in RI triggers (?)
> * Implement dirty reads or shared row locks and use them in RI triggers
>
> Adding shared locks requires recording the table/rows numbers in a
> shared area, and this could potentially be a large amount of data.
> One idea is to store the table/row numbers in a separate table and set
> a bit on the row indicating looking in this new table is required to
> find any shared row locks.
>
-rw-r--r-- | doc/TODO | 11 |
1 files changed, 9 insertions, 2 deletions
@@ -5,7 +5,7 @@ TODO list for PostgreSQL Bracketed items "[]" have more detail. Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) -Last updated: Mon Aug 23 17:56:39 EDT 2004 +Last updated: Tue Aug 24 07:09:37 EDT 2004 The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org. @@ -557,7 +557,14 @@ Referential Integrity memory. This could exhaust memory for very large trigger queues. This item involves dumping large queues into files. -* Implement dirty reads or shared row locks and use them in RI triggers (?) +* Implement dirty reads or shared row locks and use them in RI triggers + + Adding shared locks requires recording the table/rows numbers in a + shared area, and this could potentially be a large amount of data. + One idea is to store the table/row numbers in a separate table and set + a bit on the row indicating looking in this new table is required to + find any shared row locks. + * Enforce referential integrity for system tables * Change foreign key constraint for array -> element to mean element in array (?) |