From 68ba7eaf55495c2cb7c714229b3f3270cb9b6db4 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Wed, 8 Nov 2006 18:28:25 +0000
Subject: Fixed bug:  custom field tables don't contain declared primary key

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@497 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/Pg-database.sql')

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 169abbab..907ce363 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -1092,7 +1092,7 @@ BEGIN
 			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;
-- 
cgit v1.2.3

