PostgreSQL TODO List

====================

Current maintainer:Bruce Momjian (bruce@momjian.us)

Last updated:Fri Aug25 19:43:59 EDT 2006

Last updated:Mon Aug28 19:20:20 EDT 2006

The most recent version of this document can be viewed at

http://www.postgresql.org/docs/faqs.TODO.html.

memory. This could exhaust memory for very large trigger queues.

This item involves dumping large queues into files.

* Allow DEFERRABLE UNIQUE constraints?

* Allow DEFERRABLE and end-of-statement UNIQUE constraints?

This would allow UPDATE tab SET col = col + 1 to work if col has

a unique index. Currently, uniqueness checks are done while the

command is being executed, rather than at the end of the statement

or transaction.

* Allow triggers to be disabled in only the current session.

This is currently possible by starting a multi-statement transaction,

<bodybgcolor="#FFFFFF"text="#000000"link="#FF0000"vlink="#A00000"alink="#0000FF">

<h1><aname="section_1">PostgreSQL TODO List</a></h1>

<p>Current maintainer: Bruce Momjian (<ahref="mailto:bruce@momjian.us">bruce@momjian.us</a>)<br/>

Last updated:Fri Aug25 19:43:59 EDT 2006

Last updated:Mon Aug28 19:20:20 EDT 2006

<p>The most recent version of this document can be viewed at<br/>

<ahref="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.

memory. This could exhaust memory for very large trigger queues.

This item involves dumping large queues into files.

</li><li>Allow DEFERRABLE UNIQUE constraints?

</li><li>Allow DEFERRABLE and end-of-statement UNIQUE constraints?

<p> This would allow UPDATE tab SET col = col + 1 to work if col has

a unique index. Currently, uniqueness checks are done while the

command is being executed, rather than at the end of the statement

or transaction.

</li><li>Allow triggers to be disabled in only the current session.

<p> This is currently possible by starting a multi-statement transaction,

modifying the system tables, performing the desired SQL, restoring the