phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [ 100385 ] INSERT fails on columns of type 'auto'


From: nobody
Subject: [Phpgroupware-tracker] [ 100385 ] INSERT fails on columns of type 'auto'
Date: Sat, 07 Dec 2002 19:48:55 -0500


Support Request #100385, was updated on 2002-Feb-06 06:55
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100385&group_id=509

Category: Feature Request
Status: Open
Priority: 5
Summary: INSERT fails on columns of type 'auto'

By: skwashd
Date: 2002-Dec-08 11:48
Logged In: YES 
user_id=2480
Browser: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.1) Gecko/20020826

This is a feature request and has been marked as such.  The
request will be evaluated, and possibly included in the next (or
later) release.

----------------------------------------------------------------------

By: btb
Date: 2002-Feb-06 06:55
Logged In: YES 
user_id=4918
Browser: Mozilla/4.78 [en]C-CCK-MCD   (Windows NT 5.0; U)

Some parts of phpgw, for example, this patch:
http://savannah.gnu.org/cgi-bin/viewcvs/phpgroupware/setup/inc/class.setup.inc.php.diff?r1=1.9&r2=1.10
are trying to create their own values for insertion into a column which is 
defined as type 'auto' in it's 
respective tables_current.php
This fails on (at least) mssql.

The rationale for not letting the 'auto' column do its job was that eventually, 
someone wants to have 
'app_id' be centrally defined, so operations could be performed by specifying 
the app_id instead of the 
app_name.  The way I see it, there are three options:

Forget about the centrally defined app_id idea, and let the 'auto' column do 
its job.  How much speed 
could one possibly gain by converting everything to use a number instead of 
app_name?  Then again, if 
we always use app_name, we probably don't even need the app_id column.

redefine the app_id column to be 'non-auto', and ALWAYS specify the app_id when 
inserting.

Call a backend-specific function before and after insertion on a column of type 
'auto', which would allow 
the insertion to succeed.  For example, on mssql, one would have to execute:
     SET IDENTITY_INSERT $table_name ON
before insertion, and:
     SET IDENTITY_INSERT $table_name OFF
after insertion.


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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]