SET NOT NULL/DROP NOT NULL patch

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Patches" <pgsql-patches(at)postgresql(dot)org>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: SET NOT NULL/DROP NOT NULL patch
Date: 2002-03-27 06:22:09
Message-ID: GNELIHDDFBOCMGBFGEFOAEOECBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

This is a complete patch to implement changing the nullability of an
attribute. It passes all regressions tests. It includes its own quite
comprehensive regression test suite and documentation. It prevents you from
modifying system tables, non-table relations, system attributes, primary
keys and columns containing NULLs. It fully supports inheritance. I have
made some small changes to TODO to reflect this new functionality, plus
corrected some other TODO items.

The only thing I haven't checked are my ecpg changes. I would like someone
with more ecpg experience to check my preproc.y changes.

Please consider for 7.3!

Since I have now added two new large functions to command.c, I propose that
sometime before 7.3 beta, command.c is refactored and an alter.c created.
There is lots of common code in the Alter* functions that should be reused.

Chris

Attachment Content-Type Size
alternotnull.txt text/plain 26.2 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2002-03-27 06:30:40 Re: RI triggers and schemas
Previous Message Tom Lane 2002-03-27 06:16:40 Re: compile bug in HEAD?

Browse pgsql-patches by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-03-27 08:49:33 SET NOT NULL / DROP NOT NULL as an HREF!
Previous Message Barry Lind 2002-03-27 05:34:12 Re: [PATCHES] little error messages fix