The following bug has been logged online:
Bug reference: 1816
Logged by: Rafael BArrios
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.02
Operating system: FEdora Core 2
Description: Insert null values on a null field
Details:
I have a table wich is referenced as foreing key for others, the problem is,
in my case my table is composed of 4 fields, 2 of them are FK but all of
them are not null by definition. If i insert the data for the FK and leave
the other 2 empty (null), the DB accept and insert the record without any
problem.
---------------------------(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
