From 8821acd9cde150b10241e02841bc0bdd52b5cf3a Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 27 May 2016 15:17:32 -0400 Subject: [PATCH] syntax in INHERIT example Signed-off-by: Jason Etheridge --- sql/base/base.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 4e715d5..bd2b58a 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -23,7 +23,7 @@ -- SELECT migration_tools.build('foo'); -- SELECT * FROM foo.fields_requiring_mapping; -- \d foo.actor_usr --- create some incoming ILS specific staging tables, like CREATE foo.legacy_items ( l_barcode TEXT, .. ) INHERITS foo.asset_copy; +-- create some incoming ILS specific staging tables, like CREATE foo.legacy_items ( l_barcode TEXT, .. ) INHERITS (foo.asset_copy); -- Do some mapping, like UPDATE foo.legacy_items SET barcode = TRIM(BOTH ' ' FROM l_barcode); -- Then, to move into production, do: select migration_tools.insert_base_into_production('foo') -- 1.7.2.5