Re: [GENERAL] INSTEAD rule bug?

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] INSTEAD rule bug?
Date: 2003-07-15 19:54:01
Message-ID: 3F145BD9.5030706@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Tom Lane wrote:

>Dmitry Tkach <dmitry(at)openratings(dot)com> writes:
>
>
>>Ok... What's wrong with this one then
>>
>>
>
>
>
>>testdb=# insert into test values (null, null);
>>ERROR: ExecInsert: Fail to add null value in not null attribute x
>>
>>
>
>Try inserting into test_view ...
>
> regards, tom lane
>
>
Damn!
Sorry about that....

Actually, believe it or not, I do actually have a similar problem on
7.2.4...
I was just trying to reproduce it with a simple example, and screwed up
the insert statement... :-(
Sorry...

I just checked this example on 7.2, and it works fine...

But what the hell is my problem then??? I swear, I do insert into the
view there :-)
It's a really huge view, looking at a whole bunch of different tables...
I'd hate having to post the whole thing...

Dima

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-07-15 20:05:44 Re: [GENERAL] INSTEAD rule bug?
Previous Message Tom Lane 2003-07-15 19:44:07 Re: [GENERAL] INSTEAD rule bug?

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-07-15 20:04:17 Re: perfromance impact of vacuum
Previous Message Tom Lane 2003-07-15 19:44:07 Re: [GENERAL] INSTEAD rule bug?