diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-13 21:08:44 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-13 21:08:44 +0000 |
| commit | 2fa51b2ee89c6d05d6cb87d31d7c926e2b070393 (patch) | |
| tree | d5376a014c6f64a33e979eb7e430ad36a8e91ad5 | |
| parent | 46d8183b0a81362c427202e304befcec93b4e570 (diff) | |
Correcting bug 1987545: upgrade script creates sequence with wrong name
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2259 4979c152-3d1c-0410-bac9-87ea11338e46
| -rw-r--r-- | sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql b/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql index 7d27c2a4..890627d6 100644 --- a/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql +++ b/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql @@ -7,9 +7,9 @@ ALTER TABLE chart ADD PRIMARY KEY (id); LOCK acc_trans in EXCLUSIVE mode; ALTER TABLE acc_trans ADD COLUMN entry_id bigint; -CREATE SEQUENCE acctrans_entry_id_seq; -ALTER TABLE acc_trans ALTER COLUMN entry_id SET DEFAULT nextval('acctrans_entry_id_seq'); -UPDATE acc_trans SET entry_id = nextval('acctrans_entry_id_seq'); +CREATE SEQUENCE acc_trans_entry_id_seq; +ALTER TABLE acc_trans ALTER COLUMN entry_id SET DEFAULT nextval('acc_trans_entry_id_seq'); +UPDATE acc_trans SET entry_id = nextval('acc_trans_entry_id_seq'); ALTER TABLE acc_trans ADD PRIMARY key (entry_id); -- We should probably add a foreign key to chart.id |