ource on my machine).
BTW, I also observed the same behavior in 8.0.5 as well.
John Supplee
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
with the NOT NULL constraint individually, but
I think this should be fixed.
John Supplee
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
The following bug has been logged online:
Bug reference: 2144
Logged by: John Supplee
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.1
Operating system: Fedore Core 4
Description:Domain NOT NULL constraints ignored in rules
Details:
I have a database with