SF.net SVN: ledger-smb:[2259] branches/1.2/sql/legacy/Pg-upgrade-2.6.17-2.6 .18.sql

[..hidden..]

Revision: 2259
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2259&view=rev
Author:   einhverfr
Date:     2008-08-13 21:08:44 +0000 (Wed, 13 Aug 2008)

Log Message:
-----------
Correcting bug 1987545:  upgrade script creates sequence with wrong name

Modified Paths:
--------------
    branches/1.2/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql

Modified: branches/1.2/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql
===================================================================
--- branches/1.2/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql	2008-08-13 19:29:14 UTC (rev 2258)
+++ branches/1.2/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql	2008-08-13 21:08:44 UTC (rev 2259)
@@ -7,9 +7,9 @@
 
 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


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.