[Phpgroupware-tracker] [ 100628 ] postgresql 7.2 pb Version-0_9_14-branch

[nobody]

Support Request #100628, was updated on 2002-Mar-20 10:29
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100628&group_id=509

Category: Bug Report
Status: Open
Priority: 5
Summary: postgresql 7.2 pb Version-0_9_14-branch

By: lance
Date: 2002-Mar-20 10:29

Message:
Logged In: YES 
user_id=5300
Browser: Mozilla/5.0 Galeon/1.0.3 (X11; Linux i686; U;) Gecko/20020205

With postgresql 7.2, insert with data too long are
rejected. In prior version, data was truncated at
fields size.

Here an error on Version-0_9_14-branch using postgresql

Database error: Invalid SQL: INSERT INTO
phpgw_cdb_contact_addr_cat (address_category_id,
address_category_name) VALUES (5,'Vacation Home Address')
PostgreSQL Error: 1 (ERROR: value too long for type
character(20) )

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100628&group_id=509