[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bug #4970] PGSQL: partial removing of database s
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [bug #4970] PGSQL: partial removing of database sequences |
Date: |
Wed, 27 Aug 2003 13:32:02 -0400 |
User-agent: |
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) |
=================== BUG #4970: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=4970&group_id=509
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
)
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=4970&group_id=509
_______________________________________________
Message sent via/by Savannah
http://savannah.gnu.org/