Draft patch for bug: ALTER TYPE ... USING(NULL) / NOT NULL violation

Lists: pgsql-patches
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-patches(at)postgreSQL(dot)org
Subject: Draft patch for bug: ALTER TYPE ... USING(NULL) / NOT NULL violation
Date: 2006-07-04 22:35:11
Message-ID: 27920.1152052511@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

Attached is a rather hurried patch for Alexander Pravking's report that
ALTER TABLE fails to check pre-existing NOT NULL constraints properly:
http://archives.postgresql.org/pgsql-bugs/2006-07/msg00015.php

It seems to work but I'm out of time to do more with it, and am leaving
for Toronto in the morning. Anyone want to look it over, generate
back-patches as appropriate, and apply?

regards, tom lane

Attachment Content-Type Size
notnull.patch application/octet-stream 5.8 KB