assigning to NULL?

From: redmonde(at)purdue(dot)edu
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: assigning to NULL?
Date: 2002-08-18 22:25:48
Message-ID: 1029709548.3d601eecd4610@webmail.purdue.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm trying to make postGIS work with pg7.3devel. But a problem is occuring that did not appear in pg7.2. When I execute:

ALTER TABLE geotest ADD CHECK ( geometrytype(geopoint)='POINT'
OR NULL=geopoint);

I get: "ERROR: copyObject: don't know how to copy node type 506"

But when I execute:

ALTER TABLE geotest ADD CHECK ( geometrytype(geopoint)='POINT');

It works fine, which, due to the error message it seems that it is trying to assign rather to NULL, rather than compare (else what object needs to be copied in "NULL=geopoint"?). Is this a bug, a change in NULL, or a change in user defined datatypes?
Thanks;
Eric

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-08-18 22:46:34 Re: assigning to NULL?
Previous Message Tom Lane 2002-08-18 22:25:11 Re: [PATCHES] Better handling of parse errors