[Phpgroupware-tracker] [patch #3173] Correct NULL constraint affecting PostgreSQL

[Dave Hall]

This mail is an automated notification from the patch tracker
 of the project: phpGroupWare.

/**************************************************************************/
[patch #3173] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Wed 07/14/2004 at 23:58 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
Fixed in 16 branch - will be merged to head shortly






/**************************************************************************/
[patch #3173] Full Item Snapshot:

URL: <http://savannah.gnu.org/patch/?func=detailitem&item_id=3173>
Project: phpGroupWare
Submitted by: Steven E. Bourg
On: Wed 06/30/2004 at 04:13

Category:  comic
Priority:  5 - Normal
Resolution:  Fixed
Assigned to:  skwashd
Originator Email:  
Status:  Closed


Summary:  Correct NULL constraint affecting PostgreSQL

Original Submission:  Application: comic

Branch: TVersion-0_9_16-branch

Bug #: 3358

Date: 6/29/2004

Purpose: The database structure created for this application applies a NULL 
constraint on the comic_list column of the phpgw_comic table.  The comic 
application creates an initial record in the phpgw_comic table for each user 
when the application is first invoked, and it does not populate the comic_list 
field with the initial record.  The application's attempt to create an initial 
record fails because of the improper database constraint.  This patch removes 
the null constraint on comic_list that is applied at table creation.

Notes: The author of this application, Sam Wynn, has provided a description and 
confirmation of this intent by email.  This bug is known to affect 
configurations using the PostgreSQL database platform.

Follow-up Comments
------------------


-------------------------------------------------------
Date: Wed 07/14/2004 at 23:58       By: skwashd
Fixed in 16 branch - will be merged to head shortly

-------------------------------------------------------
Date: Wed 06/30/2004 at 05:10       By: darius_
The database schema for 0_9_16 is frozen.  This updated patch will 
alternatively place an empty string into the comic_list field which will 
prevent the NOT NULL constraint from being triggered.






File Attachments
-------------------

-------------------------------------------------------
Date: Wed 06/30/2004 at 05:10  Name: patch_item_3358.diff  Size: 832B   By: 
darius_
Bypass NULL constraint w/ insert of empty string
http://savannah.gnu.org/patch/download.php?item_id=3173&amp;item_file_id=3413

-------------------------------------------------------
Date: Wed 06/30/2004 at 04:13  Name: patch_item_3358.diff  Size: 927B   By: 
darius_
Bug 3358 patch - Remove NULL constraint
http://savannah.gnu.org/patch/download.php?item_id=3173&amp;item_file_id=3410






For detailed info, follow this link:
<http://savannah.gnu.org/patch/?func=detailitem&item_id=3173>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/