[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [patch #3173] Correct NULL constraint affecting P
From: |
Dave Hall |
Subject: |
[Phpgroupware-tracker] [patch #3173] Correct NULL constraint affecting PostgreSQL |
Date: |
Wed, 30 Jun 2004 02:18:03 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040602 Firefox/0.8 |
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 06/30/2004 at 06:15 (Australia/Melbourne)
What | Removed | Added
---------------------------------------------------------------------------
Assigned to | None | skwashd
/**************************************************************************/
[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: None
Assigned to: skwashd
Originator Email:
Status: Open
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 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: 832KB By:
darius_
Bypass NULL constraint w/ insert of empty string
http://savannah.gnu.org/patch/download.php?item_id=3173&item_file_id=3413
-------------------------------------------------------
Date: Wed 06/30/2004 at 04:13 Name: patch_item_3358.diff Size: 927KB By:
darius_
Bug 3358 patch - Remove NULL constraint
http://savannah.gnu.org/patch/download.php?item_id=3173&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/