<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Mark,<br>
<br>
I tryed what you recommended but I got another strange error again:<br>
<small><br>
<b>insert into</b> <font color="#009900">imoveis</font> (dsqf,
atividade,natureza,cod_lograd,num_imov,subunidade,num_bloco, bloco,
tipo_subun, propriet, area_terre, area_total,area_unida,test_princ,
test_fict,patrimonio, muro,calcada,pedologia,
topografia,formato,tip_estrut,tip_edif,acabamento,est_constr,pavimentac,geocodigo,inscricao,sequencial,
planta, quadra, desc_impo,cod_impo,desc_limpe,cod_limpe,desc_ilumi,
cod_ilumi,pontos_vu, log_tipo,
log_titulo,log_prepos,nome_do_lo,razao,fantazia,cgc,desc_ativi,codbairro,nomebairro,
zona,zona_nome, preserva,coleta,dtcadastro,dthabit ) <font
color="#009900">select</font>
(dsqf,atividade,natureza,cod_lograd,num_imov,subunidade,num_bloco,
bloco, tipo_subun, propriet, area_terre,
area_total,area_unida,test_princ, test_fict,patrimonio,
muro,calcada,pedologia,
topografia,formato,tip_estrut,tip_edif,acabamento,est_constr,pavimentac,geocodigo,inscricao,sequencial,
planta, quadra, desc_impo,cod_impo,desc_limpe,cod_limpe,desc_ilumi,
cod_ilumi,pontos_vu, log_tipo,
log_titulo,log_prepos,nome_do_lo,razao,fantazia,cgc,desc_ativi,codbairro,nomebairro,
zona,zona_nome, preserva,coleta,dtcadastro,dthabit ) <font
color="#009900">from</font> <font color="#009900">imoveis3</font>;<br>
<br>
<font color="#cc0000">ERROR: column "dsqf" is of type character
varying but expression is of type record<br>
HINT: You will need to rewrite or cast the expression.</font><br>
dbpotgis=#<br>
</small><br>
And now friend ?<br>
<br>
<br>
<br>
Mark Cave-Ayland escreveu:
<blockquote cite="mid200603231408.k2NE8Kd09040@webbased16.localdomain"
type="cite">
<blockquote type="cite">
<pre wrap="">From: <a class="moz-txt-link-abbreviated" href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>
</pre>
</blockquote>
<pre wrap=""><!---->[<a class="moz-txt-link-freetext" href="mailto:postgis-users-bounces@postgis.refractions.net">mailto:postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Ezequias
Rodrigues da Rocha
</pre>
<blockquote type="cite">
<pre wrap="">Sent: 23 March 2006 13:01
To: PostGIS Users Discussion
Subject: [postgis-users] Insert [off-topic]
</pre>
</blockquote>
<pre wrap=""><!---->
(cut)
</pre>
<blockquote type="cite">
<pre wrap="">I am trying to add a table inside of another using this command line:
dbpotgis=# INSERT INTO imoveis select * from imoveis3;
ERROR: value too long for type character varying(2)
But as you can see there is a small message that don't tell anything about
</pre>
</blockquote>
<pre wrap=""><!---->the problem.
Hi Ezequias,
The message is telling you that you're trying to put a string longer than 2
characters into a varchar(2) column. The most likely cause is that you
aren't specifying the column list manually and the column order is different
between the two tables. You should be able to solve this by manually
specifying the order of your columns, for example:
INSERT INTO imoveis (col1, col2... col3) SELECT col1, col2... col3
FROM imoveis3;
Kind regards,
Mark.
------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT
T: +44 (0)1752 797131
F: +44 (0)1752 791023
<a class="moz-txt-link-freetext" href="http://www.webbased.co.uk">http://www.webbased.co.uk</a>
<a class="moz-txt-link-freetext" href="http://www.infomapper.com">http://www.infomapper.com</a>
<a class="moz-txt-link-freetext" href="http://www.swtc.co.uk">http://www.swtc.co.uk</a>
This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ezequias Rodrigues da Rocha
<a class="moz-txt-link-freetext" href="http://ezequiasrocha.blogspot.com">http://ezequiasrocha.blogspot.com</a>
<a class="moz-txt-link-abbreviated" href="mailto:msn:ezequias@hotmail.com">msn:ezequias@hotmail.com</a>
"the worst of democracies is still better than the best of dictatorship"
</pre>
</body>
</html>