phpgroupware-tracker
[Top][All Lists]
Advanced

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

[Phpgroupware-tracker] [Bug #3479] an existing field being retyped to a


From: nobody
Subject: [Phpgroupware-tracker] [Bug #3479] an existing field being retyped to an auto field should go through this process
Date: Tue, 06 May 2003 12:59:02 -0400

=================== BUG #3479: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3479&group_id=509

Changes by: Ralf Becker <address@hidden>
Date: Tue 05/06/2003 at 18:59 (Europe/Berlin)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | ralfbecker


------------------ Additional Follow-up Comments ----------------------------
Again a useful feature request ;-)
Setting the sequenze-value alone is not enought, you have to create the sequenz 
first.

There are more issues, you should be aware with the db-tools, eg. if you change 
the columns of a primary key (eg. add an other column to a primary key) this is 
not and can not be handled by db-tools.

I leave the bugreport open, as feature-request.

Please post feature-request in the according section on savanah.



=================== BUG #3479: FULL BUG SNAPSHOT ===================


Submitted by: jecinc                  Project: phpGroupWare                 
Submitted on: Tue 05/06/2003 at 05:43
Category:  eTemplates                 Bug Group:  None                      
Severity:  5 - Major                  Priority:  None                       
Resolution:  None                     Assigned to:  ralfbecker              
Status:  Open                         Component Version:  None              
Platform Version:  None               Reproducibility:  None                

Summary:  an existing field being retyped to an auto field should go through 
this process 

Original Submission:  This is an example for postgresql to get the maximum 
value for a field and another example to set the sequance value to that value 
plus one

SELECT max(detail_id) from phpgw_ttrack_job_details
select setval('phpgw_ttrack_job__detail_id_seq',441);
alter table phpgw_ttrack_job_details alter detail_id set default 
nextval('phpgw_ttrack_job__detail_id_seq');

I thought this would be handy for dbtools

Follow-up Comments
*******************

-------------------------------------------------------
Date: Tue 05/06/2003 at 18:59       By: ralfbecker
Again a useful feature request ;-)
Setting the sequenze-value alone is not enought, you have to create the sequenz 
first.

There are more issues, you should be aware with the db-tools, eg. if you change 
the columns of a primary key (eg. add an other column to a primary key) this is 
not and can not be handled by db-tools.

I leave the bugreport open, as feature-request.

Please post feature-request in the according section on savanah.


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3479&group_id=509




reply via email to

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