SF.net SVN: ledger-smb: [2062] branches/1.2/sql/fixes/tax_pkey_duplicate. sql

[..hidden..]

Revision: 2062
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2062&view=rev
Author:   tetragon
Date:     2008-01-27 17:52:53 -0800 (Sun, 27 Jan 2008)

Log Message:
-----------
fix syntax error in COMMENT ON INDEX statement

Modified Paths:
--------------
    branches/1.2/sql/fixes/tax_pkey_duplicate.sql

Modified: branches/1.2/sql/fixes/tax_pkey_duplicate.sql
===================================================================
--- branches/1.2/sql/fixes/tax_pkey_duplicate.sql	2008-01-22 22:34:10 UTC (rev 2061)
+++ branches/1.2/sql/fixes/tax_pkey_duplicate.sql	2008-01-28 01:52:53 UTC (rev 2062)
@@ -9,5 +9,5 @@
 $$Checks on the base uniqueness of the chart_id, validto combination$$;
 
 CREATE UNIQUE INDEX tax_null_validto_unique_idx ON tax(chart_id) WHERE validto IS NULL;
-COMMENT ON INDEX tax_null_validto_unique_idx ON tax IS
+COMMENT ON INDEX tax_null_validto_unique_idx IS
 $$Part of primary key emulation for the tax table, ensures at most one NULL validto for each chart_id$$;


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