[GENERAL] UNIQUE constraint violations and transactions

2001-10-26 Thread Eric Ridge
Hi! I've got a UNIQUE constraint on a field, and obviously, when I try to insert a duplicate value, I get a WARNING via psql (and an Exception via the JDBC drivers) saying I tried to violate the constraint. No biggie. This is what I expect. The tricky part comes in when I violate the constraint

Re: [GENERAL] null != null ???

2001-10-26 Thread Tom Lane
Thomas Lockhart <[EMAIL PROTECTED]> writes: > Yes, this is an explicit feature in our parser to help out poor MSAccess > souls who have a product which generates illegal SQL queries. We put in > a specific rule to convert "anything=NULL" to "anything IS NULL", which > *is* legal syntax. It should