Help with SET NULL/SET NOT NULL

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Help with SET NULL/SET NOT NULL
Date: 2002-03-20 05:10:04
Message-ID: GNELIHDDFBOCMGBFGEFOEEMPCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I did an initial patch for ALTER TABLE / SET NULL that should just say 'not
implemented' when someone tries it, but I get this:

template1=# alter table test alter column a set null;
ERROR: parser: parse error at or near "null"
template1=# alter table test alter column a set null_p;
ERROR: parser: parse error at or near "null_p"
template1=# alter table test alter column a set not null;
ERROR: parser: parse error at or near "not"

What have I missed?

All regression tests pass...

Attached is context diff

I'm pretty sure that I haven't done preproc.y correctly either...

Chris

ps. DON'T COMMIT THIS PATCH!!!

Attachment Content-Type Size
null.txt text/plain 16.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-03-20 05:25:09 Re: 7.2 crash...
Previous Message Tom Lane 2002-03-20 05:05:59 Re: pg_clog troubles