Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-bugs by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group