I’ve got a problem with my app when installing into PostgreSQL.
This is part of tables current, and this is the only places where
perp_account_group are mentioned:
‘perp_account’ => array(
‘fd’ => array(
‘account_id’ => array(‘type’ =>
‘varchar’,‘precision’ => ‘7’),
‘account_name’ => array(‘type’ =>
‘varchar’,‘precision’ => ‘255’,‘nullable’ => False),
‘account_group’ => array(‘type’ =>
‘varchar’,‘precision’ => ‘4’,‘nullable’ => False)
),
‘pk’ => array(‘account_id’),
‘fk’ => array(‘account_group’ => ‘perp_account_group.group_id’),
‘ix’ => array(‘account_group’),
‘uc’ => array()
),
‘perp_account_group’ => array(
‘fd’ => array(
‘group_name’ => array(‘type’ =>
‘varchar’,‘precision’ => ‘255’),
‘group_section’ => array(‘type’ =>
‘varchar’,‘precision’ => ‘4’,‘nullable’ => False),
‘group_id’ => array(‘type’ =>
‘varchar’,‘precision’ => ‘4’),
‘asset_or_liability’ => array(‘type’ =>
‘int’,‘precision’ => ‘4’,‘nullable’ => False,‘default’ => ‘1’)
),
‘pk’ => array(‘group_id’),
‘fk’ => array(‘group_section’ =>
‘perp_account_section.section_id’),
‘ix’ => array(‘group_name’,‘group_section’),
‘uc’ => array(‘group_name’)
),
I get the following errors:
CreateTableSQL(‘perp_account_group’,‘group_name C(255), group_section
C(4) NOTNULL, group_id C(4) PRIMARY, asset_or_liability I4 NOTNULL
NOQUOTE DEFAULT 1’) sql=Array ( [0] => CREATE TABLE
"perp_account_group" ( “group_name” VARCHAR(255), "group_section"
VARCHAR(4) NOT NULL, “group_id” VARCHAR(4) NOT NULL,
“asset_or_liability” INT4 DEFAULT 1 NOT NULL, PRIMARY KEY (“group_id”)
) )
ERROR: relation “perp_account_group” already exists
CreateIndexSql(‘perp_account_group_name’,‘perp_account_group’,‘group_name’,Array
( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX
"perp_account_group_name" ON “perp_account_group” (“group_name”) )
ERROR: “perp_account_group” is an index
CreateIndexSql(‘perp_account_group_section’,‘perp_account_group’,‘group_section’,False)
sql=Array ( [0] => CREATE INDEX “perp_account_group_section” ON
"perp_account_group" (“group_section”) )
ERROR: “perp_account_group” is an index
The errors are fairly clear, but I’m not sure where the already
existing relation or index comes from, and how to fix it.
Nathan
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers