Re: [PATCHES] Patch for ALTER TABLE / TYPE

2006-01-30 Thread Tom Lane
NAKANO Yoshihisa <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> After looking at the test case a bit, I have an alternate approach: >> constraints on the column will have DEPENDENCY_AUTO type, while >> constraints using the column will have DEPENDENCY_NORMAL type. > O.K. It seems nicer than my

Re: [PATCHES] Patch for ALTER TABLE / TYPE

2006-01-29 Thread NAKANO Yoshihisa
Tom Lane wrote: > After looking at the test case a bit, I have an alternate approach: > constraints on the column will have DEPENDENCY_AUTO type, while > constraints using the column will have DEPENDENCY_NORMAL type. > Therefore, if we drop the NORMAL ones before the AUTO ones, that > should be en

Re: [PATCHES] Patch for ALTER TABLE / TYPE

2006-01-27 Thread Tom Lane
NAKANO Yoshihisa <[EMAIL PROTECTED]> writes: > Please find the patch attached. This is for the bug which is posted to > hackers before. > http://archives.postgresql.org/pgsql-hackers/2005-06/msg01442.php > We can see a problem by this bug in following way. > CREATE TABLE pktable (a int primary k

[PATCHES] Patch for ALTER TABLE / TYPE

2006-01-27 Thread NAKANO Yoshihisa
Hi, Please find the patch attached. This is for the bug which is posted to hackers before. http://archives.postgresql.org/pgsql-hackers/2005-06/msg01442.php We can see a problem by this bug in following way. CREATE TABLE pktable (a int primary key); CREATE TABLE fktable (b int references pktabl