SF.net SVN: ledger-smb: [497] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 497
          http://svn.sourceforge.net/ledger-smb/?rev=497&view=rev
Author:   einhverfr
Date:     2006-11-08 10:28:25 -0800 (Wed, 08 Nov 2006)

Log Message:
-----------
Fixed bug:  custom field tables don't contain declared primary key

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2006-11-08 02:47:40 UTC (rev 496)
+++ trunk/sql/Pg-database.sql	2006-11-08 18:28:25 UTC (rev 497)
@@ -1092,7 +1092,7 @@
 			INSERT INTO custom_table_catalog (extends) 
 				VALUES (table_name);
 			EXECUTE ''CREATE TABLE custom_''||table_name || 
-				'' (row_id INT)'';
+				'' (row_id INT PRIMARY KEY)'';
 		EXCEPTION WHEN duplicate_table THEN
 			-- do nothing
 		END;


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