Skip site navigation (1) Skip section navigation (2)

syntax error at or near "Hs" at character 1182

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: syntax error at or near "Hs" at character 1182
Date: 2004-10-15 21:15:45
Message-ID: 20041015211545.47555.qmail@web51407.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Dear Group, 
 I have a large file of 71 columns and 10K rows. 
I had to pass this whole document into a table and
using a python script I created insert statements :


INSERT INTO cdna_exp
(cdna_SPOT,cdna_NAME,cdna_Clone_ID,cdna_Gene_Symbol,cdna_Gene_Name,cdna_Cluster_ID,cdna_Accession,cdna_Preferred_name,cdna_SUID,cdna_CH1I_MEAN,cdna_CH1D_MEDIAN,cdna_CH1I_MEDIAN,cdna_CH1_PER_SAT,cdna_CH1I_SD,cdna_CH1B_MEAN,cdna_CH1B_MEDIAN,cdna_CH1B_SD,cdna_CH1D_MEAN,cdna_CH2I_MEAN,cdna_CH2D_MEAN,cdna_CH2D_MEDIAN,cdna_CH2I_MEDIAN,cdna_CH2_PER_SAT,cdna_CH2I_SD,cdna_CH2B_MEAN,cdna_CH2B_MEDIAN,cdna_CH2B_SD,cdna_CH2BN_MEDIAN,cdna_CH2DN_MEAN,cdna_CH2IN_MEAN,cdna_CH2DN_MEDIAN,cdna_CH2IN_MEDIAN,cdna_CORR,cdna_DIAMETER,cdna_FLAG,cdna_LOG_RAT2N_MEAN,cdna_LOG_RAT2N_MEDIAN,cdna_PIX_RAT2_MEAN,cdna_PIX_RAT2_MEDIAN,cdna_PERGTBCH1I_1SD,cdna_PERGTBCH1I_2SD,cdna_PERGTBCH2I_1SD,cdna_PERGTBCH2I_2SD,cdna_RAT1_MEAN,cdna_RAT1N_MEAN,cdna_RAT2_MEAN,cdna_RAT2_MEDIAN,cdna_RAT2_SD,cdna_RAT2N_MEAN,cdna_RAT2N_MEDIAN,cdna_REGR,cdna_SUM_MEAN,cdna_SUM_MEDIAN,cdna_TOT_BPIX,cdna_TOT_SPIX,cdna_X_COORD,cdna_Y_COORD,cdna_TOP,cdna_BOT,cdna_LEFT,cdna_RIGHT,cdna_SECTOR,cdna_SECTORROW,cdna_SECTORCOL,cdna_SOURCE,cdna_
 PLATE,cd
na_PROW,cdna_PCOL,cdna_FAILED,cdna_IS_VERIFIED,cdna_IS_CONTAMINATED,cdna_LUID)
VALUES ( 
"9216","18495","IMAGE:262035","NULL","ESTs","Hs.269034","H98688","NULL","107662","227","NULL","NULL","NULL","NULL","245","137","NULL","90","298","30","NULL","NULL","NULL","NULL","339","268","NULL","406","45","451","NULL","NULL","0.584","NULL","0","-0.987","NULL","NULL","0.302","40","NULL","19","NULL","3","1.981","0.333","NULL","NULL","0.505","NULL","0.484","NULL","NULL","1272","52","NULL","NULL","960","968","1005","1013","16","24","24","GF201:96(69H12):384(24P24)","24","P","24","0","Y","U");


I kept all these files into a chip.sql file.

I initialized this file from psql prompt. 

Myarray=> \i ../../../chip.sql

I get the following ERROR:
psql:/../../../../../sqls/2151.sql:9216: ERROR: 
syntax error at or near "Hs" at character 1182

IS it a proble if I have a value : "Hs.269034" in this
form.  I declared this as varchar(100). 

Also I have 9216 INSERT statements in this file. 

I am unable to sniff where the problem is. Can any one
suggest some solution. 

Thank you in advance. 

Kumar. 



		
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2004-10-15 21:39:44
Subject: Re: syntax error at or near "Hs" at character 1182
Previous:From: Keith WorthingtonDate: 2004-10-15 15:07:50
Subject: Re: copy error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group