diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-08 18:28:25 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2006-11-08 18:28:25 +0000 |
| commit | 68ba7eaf55495c2cb7c714229b3f3270cb9b6db4 (patch) | |
| tree | 5d65d29ca942381a89e1642387828e25c884954a | |
| parent | a93d38108b1274a92e6442bbc88b958503340c15 (diff) | |
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
| -rw-r--r-- | sql/Pg-database.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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; |