PG 7.1 pre-beta bug ... 
Author Message
 PG 7.1 pre-beta bug ...

Quote:

> All went well except for a handful of occurances of the following error:
> ERROR:  SS_finalize_plan: plan shouldn't reference subplan's variable

Fixed, I believe.  Your test case now gives

regression=# select user_group_add('group', 'shortname', 'prettyname', 'f');
ERROR:  ExecAppend: Fail to add null value in not null attribute registration_date

but that's correct AFAICT, and 7.0.2 agrees...

                        regards, tom lane



Sat, 10 May 2003 08:21:58 GMT
 PG 7.1 pre-beta bug ...


Quote:

>> All went well except for a handful of occurances of the following error:
>> ERROR:  SS_finalize_plan: plan shouldn't reference subplan's variable

>Fixed, I believe.  Your test case now gives

>regression=# select user_group_add('group', 'shortname', 'prettyname', 'f');
>ERROR:  ExecAppend: Fail to add null value in not null attribute
registration_date

>but that's correct AFAICT, and 7.0.2 agrees...

Yeah, I boiled down my example a bit too far for the case where the RDBMS
works, apparently :)   There's probably a trigger to fill the registration
date that I stripped out, something like that.

Thanks ... I'll not be able to get back to testing until later this week (I'm
busy with a client site, Oracle-based, boo-hoo).


  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.



Sat, 10 May 2003 08:49:39 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. PG 7.1 pre-beta bug ...

2. HOWTO for pg 7.1 installation from cvs

3. Too Many Open Files PG 7.1

4. big pg 6.5 and 7.1 problem in simple application

5. HOWTO for pg 7.1 installation from cvs

6. Authentication type 5 fails in PG 7.1 to 7.3 connect

7. Postgresql 7.1 Beta 5, Postmaster dead

8. Problems with Multibyte in 7.1 beta?

9. Beta 7.1 and Solaris

10. Postgresql 7.1 Beta 5, Postmaster dead

11. 7.1 Beta 1 & table size calculation

12. DB2 v. 7.1 beta - SQL sp problem


 
Powered by phpBB® Forum Software