[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: Dave Hall <address@hidden>
Date: Fri 08/29/03 at 15:22 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Duplicate
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
Duplicate of bug #4860 - closing this one



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


Submitted by: drago                   Project: phpGroupWare                 
Submitted on: Thu 08/28/03 at 03:32
Category:  API - Setup                Bug Group:  0.9.14.004/5 release      
Severity:  5 - Major                  Priority:  Low                        
Resolution:  Duplicate                Assigned to:  None                    
Status:  Closed                       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: Fri 08/29/03 at 15:22         By: skwashd
Duplicate of bug #4860 - closing this one

-------------------------------------------------------
Date: Thu 08/28/03 at 03: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/