There was -- kinda alter table tab add constraint check (value not null); -- Rod Taylor
Your eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. You cannot imagine why you ever felt otherwise. ----- Original Message ----- From: "Christopher Kings-Lynne" <[EMAIL PROTECTED]> To: "Rod Taylor" <[EMAIL PROTECTED]> Cc: "Ferruccio Zamuner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 31, 2002 12:31 AM Subject: Re: [HACKERS] Data integrity and sanity check > > BTW. There are good reasons sometimes for having data that violates > > current constraints. The top of a tree may have a static record with > > a null parent. The NOT NULL constraint added after this entry (via > > alter table add constraint) should not affect the static record, so > > unless you know your data quite well this type of tool wouldn't be > > particularly useful anyway. > > As far as I am aware, there is no alter table add constraint syntax for > NOT NULLs atm. I've submitted a patch that allows alter table/alter > column set/drop not null though. > > Chris > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
