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

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #3479] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Sun 06/06/2004 at 23:27 (Australia/Melbourne)

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







/**************************************************************************/
[bugs #3479] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=3479>
Project: phpGroupWare
Submitted by: Johnson
On: Tue 05/06/2003 at 03:43

Category:  eTemplates
Item Group:  None
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  Caeies
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 16: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.












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=3479>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/