Re: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-09 Thread Jaime Casanova
On 1/7/06, John Supplee <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > > OK, got it. Patch for 8.1 is attached if you need it. > > Thanks for the test case. > > Wow, thanks for the quick work. But since I can solve the problem with NOT > NULL constraints directly on the column I will wait for t

Re: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-08 Thread John Supplee
Tom Lane wrote: > OK, got it. Patch for 8.1 is attached if you need it. > Thanks for the test case. Wow, thanks for the quick work. But since I can solve the problem with NOT NULL constraints directly on the column I will wait for the next release to test it (I don't have the source on my ma

Re: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-06 Thread Tom Lane
"John Supplee" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Works for me: > You need to modify your test case slightly. OK, got it. Patch for 8.1 is attached if you need it. Thanks for the test case. regards, tom lane Index: rewriteManip.c

Re: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-06 Thread John Supplee
Tom Lane wrote: > Works for me: > > regression=# create domain dint as int not null; > CREATE DOMAIN > regression=# create table t1 (f1 dint); > CREATE TABLE > regression=# create view v1 as select * from t1; > CREATE VIEW > regression=# create rule r1 as on insert to v1 do instead > regression-#

Re: [BUGS] BUG #2144: Domain NOT NULL constraints ignored in rules

2006-01-04 Thread Tom Lane
"John Supplee" <[EMAIL PROTECTED]> writes: > Description:Domain NOT NULL constraints ignored in rules Works for me: regression=# create domain dint as int not null; CREATE DOMAIN regression=# create table t1 (f1 dint); CREATE TABLE regression=# create view v1 as select * from t1; CREATE V