aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2004-08-24 11:09:44 +0000
committerBruce Momjian <bruce@momjian.us>2004-08-24 11:09:44 +0000
commit4359ebed37b2387c7ef7c4fe078992ccc789ee93 (patch)
tree74031ceeb82515d82fbdc458e7b4ed88b5da0629
parentcda1bd6cfe8cad9943f0c1991b690313b5be9bef (diff)
downloadpostgresql-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/TODO11
1 files changed, 9 insertions, 2 deletions
diff --git a/doc/TODO b/doc/TODO
index 0204f371c70..0e53c090103 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -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 (?)