[Top][All Lists]
[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