patchphpGroupWare - Patches: patch #3173, Correct NULL constraint affecting...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

patch #3173: Correct NULL constraint affecting PostgreSQL

Submitter:  Steven E. Bourg <darius_>
Submitted:  Wed 30 Jun 2004 04:13:22 AM UTC
   
 
Category:  comic Priority:  5 - Normal
Item Group:  None Status:  Done
Privacy:  Public Assigned to:  skwashd
Open/Closed:  Closed

Wed 14 Jul 2004 11:58:04 PM UTC, comment #2: 

Fixed in 16 branch - will be merged to head shortly

Dave Hall <skwashd>
Group administrator
Wed 30 Jun 2004 05:10:26 AM UTC, comment #1: 

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.

Steven E. Bourg <darius_>
Wed 30 Jun 2004 04:13:22 AM UTC, 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.

Steven E. Bourg <darius_>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attached Files
file #7601:  patch_item_3358.diff added by darius_ (832B - application/octet-stream - Bypass NULL constraint w/ insert of empty string)
file #7598:  patch_item_3358.diff added by darius_ (927B - application/octet-stream - Bug 3358 patch - Remove NULL constraint)

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 5 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-07-14 skwashd StatusNone Done
    Open/ClosedOpen Closed
2004-06-30 skwashd Assigned toNone skwashd
2004-06-30 darius_ Attached File- Added patch_item_3358.diff, #3413
2004-06-30 darius_ Attached File- Added patch_item_3358.diff, #3410

Back to the top

Powered by Savane 3.13-caa5.
Corresponding source code