From 68ba7eaf55495c2cb7c714229b3f3270cb9b6db4 Mon Sep 17 00:00:00 2001 From: einhverfr 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') 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