diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-10-23 00:43:45 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-10-23 00:43:45 -0400 |
| commit | 18661c67e96ff4a81ab3844843a73676d161db0c (patch) | |
| tree | 6cc45485bd8ffda5563a07c9c2fa477d247b7711 /src/include | |
| parent | 8e8ac0894b196c4dd8618bca1f598f13bf5e18ea (diff) | |
| download | postgresql-18661c67e96ff4a81ab3844843a73676d161db0c.tar.gz postgresql-18661c67e96ff4a81ab3844843a73676d161db0c.zip | |
Don't trust deferred-unique indexes for join removal.
The uniqueness condition might fail to hold intra-transaction, and assuming
it does can give incorrect query results. Per report from Marti Raudsepp,
though this is not his proposed patch.
Back-patch to 9.0, where both these features were introduced. In the
released branches, add the new IndexOptInfo field to the end of the struct,
to try to minimize ABI breakage for third-party code that may be examining
that struct.
Diffstat (limited to 'src/include')
| -rw-r--r-- | src/include/nodes/relation.h | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/include/nodes/relation.h b/src/include/nodes/relation.h index f6592697e44..0aec1637c93 100644 --- a/src/include/nodes/relation.h +++ b/src/include/nodes/relation.h @@ -491,6 +491,9 @@ typedef struct IndexOptInfo bool amsearchnulls; /* can AM search for NULL/NOT NULL entries? */ bool amhasgettuple; /* does AM have amgettuple interface? */ bool amhasgetbitmap; /* does AM have amgetbitmap interface? */ + + /* Added at end of struct to avoid ABI breakage in released branches */ + bool immediate; /* is uniqueness enforced immediately? */ } IndexOptInfo; |