From: Don Armstrong <don@donarmstrong.com>
Date: Sat, 18 Aug 2012 13:40:21 +0000 (-0700)
Subject: offset is a reserved word and must be quoted
X-Git-Url: https://git.donarmstrong.com/?p=dbsnp.git;a=commitdiff_plain;h=1b24824fcd9bf26d1080ef7ab02e0a4be14c9102

offset is a reserved word and must be quoted
---

diff --git a/schema/human_9606_schema/human_9606_table_postgresql.sql b/schema/human_9606_schema/human_9606_table_postgresql.sql
index adbef0a..98023e0 100644
--- a/schema/human_9606_schema/human_9606_table_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_table_postgresql.sql
@@ -620,7 +620,7 @@ snp_type char(2) NOT NULL ,
 snp_id int NULL ,
 gi int NULL ,
 accession_how_cd int NULL ,
-offset int NULL ,
+"offset" int NULL ,
 asn_to int NULL ,
 lf_ngbr int NULL ,
 rf_ngbr int NULL ,
@@ -649,7 +649,7 @@ snp_type char(2) NOT NULL ,
 snp_id int NULL ,
 gi int NULL ,
 accession_how_cd int NOT NULL ,
-offset int NULL ,
+"offset" int NULL ,
 asn_to int NULL ,
 lf_ngbr int NULL ,
 rf_ngbr int NULL ,