Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.2/8.9.1) with ESMTP id MAA34264
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 3 Mar 1999 12:22:01 -0500 (EST)
	(envelope-from byronn@insightdist.com)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id MAA00816
	for pgsql-interfaces@postgreSQL.org;
	Wed, 3 Mar 1999 12:07:01 -0500 (EST)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!byronn using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA18457; Wed, 3 Mar 1999 11:42:26 -0500
Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA39916; Wed, 3 Mar 1999 11:42:25 -0500
Message-Id: <36DD664D.E98ED4A9@insightdist.com>
Date: Wed, 03 Mar 1999 11:41:50 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Michael Davis <michael.davis@prevuenet.com>
Cc: "'pgsql-interfaces@postgreSQL.org'" <pgsql-interfaces@postgreSQL.org>,
	David Hartwig <daybee@bellatlantic.net>
Subject: Re: [INTERFACES] Foreign Keys
References: <93C04F1F5173D211A27900105AA8FCFC14521B@lambic.prevuenet.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Michael Davis wrote:

> I will fix the permission denied problem by granting access to these tables
> to the Admin user.  I don't think this is the real cause of my problem.  The
> null issue is the real problem  Considering your response, does this mean I
> am the first user to encounter this issue?  I am not very satisfied with
>

<snip>

> Could this problem be fixed in the ODBC driver of does it need to be fixed
> in PostgreSQL?  None of the commercial databases that I have used (including
> Oracle) support the syntax you are suggesting.  I wonder how this works with
> SQL Server?
>

It really should be fixed in the backend.  I don't want to get into parsing sql
strings too much.  From what I've heard, its a fairly simple change to make
"col=null" work like "col isnull", and someone else on the list mentioned they
did it.

Can we just get this into the next release of Postgres?

Byron