diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-05-22 20:39:23 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-05-22 20:39:23 +0000 |
| commit | 74d0cf397487e7fe248990a3519b06b72595c87f (patch) | |
| tree | 9617935d0a16492480c26ab2c6523c6e800bdb01 /doc/src | |
| parent | 32bfb1c2974b6aa1fb4f5cefbdd83190a65fe5d5 (diff) | |
| download | postgresql-74d0cf397487e7fe248990a3519b06b72595c87f.tar.gz postgresql-74d0cf397487e7fe248990a3519b06b72595c87f.zip | |
Make "trigger" section:
> * Referential Integrity
>
> o Add MATCH PARTIAL referential integrity
> o Change foreign key constraint for array -> element to mean element
> in array?
> o Enforce referential integrity for system tables
>
>
< Referential Integrity
< =====================
<
< * Add MATCH PARTIAL referential integrity
> Triggers
> ========
< * Change foreign key constraint for array -> element to mean element
< in array?
801d804
< * Enforce referential integrity for system tables
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/FAQ/TODO.html | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index d79ec029e13..5ccb9e3eade 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@ <body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF"> <h1><a name="section_1">PostgreSQL TODO List</a></h1> <p>Current maintainer: Bruce Momjian (<a href="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/> -Last updated: Wed May 17 22:32:10 EDT 2006 +Last updated: Mon May 22 16:39:01 EDT 2006 </p> <p>The most recent version of this document can be viewed at<br/> <a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>. @@ -561,6 +561,13 @@ first. <p> This is basically the same as SET search_path. </p> </li></ul> + </li><li>Referential Integrity + <ul> + <li>Add MATCH PARTIAL referential integrity + </li><li>Change foreign key constraint for array -> element to mean element + in array? + </li><li>Enforce referential integrity for system tables + </li></ul> </li><li>Server-Side Languages <ul> <li>Fix PL/pgSQL RENAME to work on variables other than OLD/NEW @@ -701,17 +708,13 @@ first. non-E strings are used </li></ul> </li></ul> -<h1><a name="section_10">Referential Integrity</a></h1> - +<h1><a name="section_10">Triggers</a></h1> <ul> - <li>Add MATCH PARTIAL referential integrity - </li><li>Add deferred trigger queue file + <li>Add deferred trigger queue file <p> Right now all deferred trigger information is stored in backend memory. This could exhaust memory for very large trigger queues. This item involves dumping large queues into files. </p> - </li><li>Change foreign key constraint for array -> element to mean element - in array? </li><li>Allow DEFERRABLE UNIQUE constraints? </li><li>Allow triggers to be disabled in only the current session. <p> This is currently possible by starting a multi-statement transaction, @@ -725,7 +728,6 @@ first. </p> </li><li>Allow statement-level triggers to access modified rows </li><li>Support triggers on columns (Greg Sabino Mullane) - </li><li>Enforce referential integrity for system tables </li><li>Allow AFTER triggers on system tables <p> System tables are modified in many places in the backend without going through the executor and therefore not causing triggers to fire. To |