helpphpGroupWare - Support: sr #100385, INSERT fails on columns of type...

 
 

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

sr #100385: INSERT fails on columns of type 'auto'

Submitted by:  Bradley Bell <btb>
Submitted on:  Tue 05 Feb 2002 07:55:13 PM UTC  
 
Category: Feature RequestPriority: 5 - Normal
Severity: 2 - MinorStatus: None
Privacy: PublicAssigned to: None
Open/Closed: OpenOperating System: None

Sun 08 Dec 2002 12:48:54 AM UTC, comment #1:

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.

Dave Hall <skwashd>
Project Administrator
Tue 05 Feb 2002 07:55:13 PM UTC, original submission:

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.

Bradley Bell <btb>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follows 1 latest change.

Date Changed By Updated Field Previous Value => Replaced By
Sun 08 Dec 2002 12:48:54 AM UTCskwashdsupport_category_id10161=>

Back to the top


Powered by Savane 3.1-cleanup1