From: Don Armstrong <don@donarmstrong.com>
Date: Mon, 12 Dec 2011 22:52:58 +0000 (-0800)
Subject:  * offset is a postgresql reserved word; cannot be used as a column name
X-Git-Url: https://git.donarmstrong.com/?p=dbsnp.git;a=commitdiff_plain;h=a6a0c2a4af80701e01b33097428d7a6b26a96176

 * offset is a postgresql reserved word; cannot be used as a column name
---

diff --git a/schema/human_9606_schema/human_9606_table_postgresql.sql b/schema/human_9606_schema/human_9606_table_postgresql.sql
index 7dc165a..a440728 100644
--- a/schema/human_9606_schema/human_9606_table_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_table_postgresql.sql
@@ -612,7 +612,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 ,
@@ -653,7 +653,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 ,