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!!!
Wed, 20 Mar 2002 13:10:04 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Help with SET NULL/SET NOT NULL
seems like other systems keep very similar syntax to the CREATE TABLE 
command.  i.e.
 
ALTER TABLE blah ALTER COLUMN col datatype (precision.scale) NULL
ALTER TABLE blah ALTER COLUMN col datatype (precision.scale) NOT NULL

Dwayne



Fri, 22 Mar 2002 11:21:02 -0500
"Dwayne Miller" <dmiller@espgroup.net>
Re: SET NULL/SET NOT NULL