Re: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-08 Thread John Supplee
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

Re: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-06 Thread John Supplee
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

[BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-04 Thread John Supplee
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