[Phpgroupware-tracker] [Bug #3479] an existing field being retyped to an auto field should go through this process

[nobody]

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

Submitted by: jecinc                  Project: phpGroupWare                 
Submitted on: Tue 05/06/2003 at 03:43
Category:  eTemplates                 Bug Group:  None                      
Severity:  5 - Major                  Priority:  None                       
Resolution:  None                     Assigned to:  None                    
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



No Followups Have Been Posted


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