From a6a0c2a4af80701e01b33097428d7a6b26a96176 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Mon, 12 Dec 2011 14:52:58 -0800 Subject: [PATCH] * offset is a postgresql reserved word; cannot be used as a column name --- schema/human_9606_schema/human_9606_table_postgresql.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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 , -- 2.39.2