[Phpgroupware-tracker] [bug #4970] PGSQL: partial removing of database sequences

[nobody]

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

Changes by: Drago Bokal <address@hidden>
Date: Wed 08/27/03 at 19:36 (Europe/Ljubljana)

------------------ Additional Follow-up Comments ----------------------------
Obviously the default severity on Savannah is Major. Sorry for ommiting this 
data: of course this bug is not severe at all, it just annoys the developers.



=================== BUG #4970: FULL BUG SNAPSHOT ===================


Submitted by: drago                   Project: phpGroupWare                 
Submitted on: Wed 08/27/03 at 19:32
Category:  API - Setup                Bug Group:  0.9.14.004/5 release      
Severity:  5 - Major                  Priority:  Low                        
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  CVS               
Platform Version:  Linux - Debian     Reproducibility:  Every Time          

Summary:  PGSQL: partial removing of database sequences

Original Submission:  DB: PGSQL

1. Create tables in such way, that the SEQUENCE for the table is created, but 
the table itself is not:

...

'phpgw_someapp_ttt' => array(

  'fd' => array(

    'id' => array('type' => 'auto', 'nullable' => False),

    'name' => array('type' => 'int, 'precision' ),

   ),

  'pk' => array('id'),

  'fk' => array(),

  'ix' => array('id'),

  'uc' => array('id')

)...

The table would not be created due to a missing ' at int



2. Attempt to install the app.

3. Due to the error: deinstall the app.

4. Fix the error in the table definition

5. Attempt to reinstall the app

RESULT: the table is not created, as the sequence of the table was not removed. 
The error message is:



Database error: Invalid SQL: CREATE SEQUENCE seq_phpgw_someapp_ttt_seq 

PostgreSQL Error: 1 (ERROR: Relation 'seq_phpgw_someapp_ttt_seq' already exists 
)

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

-------------------------------------------------------
Date: Wed 08/27/03 at 19:36         By: drago
Obviously the default severity on Savannah is Major. Sorry for ommiting this 
data: of course this bug is not severe at all, it just annoys the developers.


CC list is empty


No files currently attached


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

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