<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY
style="BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px 10px 10px; FONT-FAMILY: Arial"
bgColor=#ffffff background="" scroll=yes ORGYPOS="0">
<DIV><FONT color=#0000ff size=2>Hi</FONT></DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV>
<DIV><FONT color=#0000ff size=2>It is very easy to find the solution.
:-)</FONT></DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV>
<DIV><FONT color=#0000ff size=2>You forgot to add 'select' before
dropgeoemtrytable!</FONT></DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV>
<DIV>dbpotgis-# select DropGeometryTable('ezequias');</DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff size=2>and not</FONT></DIV>
<DIV><FONT color=#0000ff size=2></FONT> </DIV>
<DIV>dbpotgis-# DropGeometryTable('ezequias');</DIV>
<DIV><FONT
size=2>---------------------------------------------------------------<BR>TECHER
Jean David<BR>01MAP<BR>e-mail: <A
href="mailto:david@01map.net">david@01map.net</A><BR>Tél: 04 67 45 60
27<BR>Entreprise: <A
href="http://www.01map.net">http://www.01map.net</A><BR>Perso: <A
href="http://techer.pascal.free.fr/postgis/">http://techer.pascal.free.fr/postgis/</A><BR>---------------------------------------------------------------</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ezequias@recife.pe.gov.br
href="mailto:ezequias@recife.pe.gov.br">Ezequias Rodrigues da Rocha</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=nicky666@gmail.com
href="mailto:nicky666@gmail.com">Nicolas Ribot</A> ; <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, July 29, 2005 3:44 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Res: Re: [postgis-users]
dropping geometry tables</DIV>
<DIV><BR></DIV>
<TABLE id=INCREDIMAINTABLE cellSpacing=0 cellPadding=2 width="100%"
border=0><TBODY>
<TR>
<TD id=INCREDITEXTREGION
style="FONT-SIZE: 12pt; CURSOR: auto; FONT-FAMILY: Arial" width="100%">
<DIV>Thank you, but:</DIV>
<DIV> </DIV>
<DIV>dbpotgis-# DropGeometryTable('ezequias');<BR>ERROR: syntax
error at or near "DropGeometryTable" at character
1<BR>dbpotgis=#<BR> </DIV>
<DIV> </DIV>
<DIV id=IncrediOriginalMessage><I>-------Mensagem
original-------</I></DIV>
<DIV> </DIV>
<DIV id=receivestrings>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>De:</B></I> <A
href="mailto:nicky666@gmail.com">Nicolas Ribot</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Data:</B></I> 07/29/05
10:19:35</DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Para:</B></I> <A
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Assunto:</B></I> Re:
[postgis-users] dropping geometry tables</DIV></DIV>
<DIV> </DIV>
<DIV>> I am sending a</DIV>
<DIV>></DIV>
<DIV>> DROPGeometryTable(['dbpotgis'],ezequias);</DIV>
<DIV>> or</DIV>
<DIV>> DROPGeometryTable([dbpotgis],ezequias);</DIV>
<DIV>> or</DIV>
<DIV>> DROPGeometryTable('dbpotgis',ezequias);</DIV>
<DIV>></DIV>
<DIV>> Where dbpotgis is the database name (schema)</DIV>
<DIV>> and ezequias is the name of my geometry table.</DIV>
<DIV>></DIV>
<DIV>> The error reported in all cases is: ERROR: syntax
error at or near</DIV>
<DIV>> DROPGeometryTable" at character 2</DIV>
<DIV>></DIV>
<DIV> </DIV>
<DIV>Hi,</DIV>
<DIV>You have to quote schema name and table name:</DIV>
<DIV> </DIV>
<DIV>select dropGeometryColumn('dbpotgis', 'ezequias');</DIV>
<DIV> </DIV>
<DIV>(the brackets [] in the documentation indicate optional parameters
for</DIV>
<DIV>a function. In this case, meanning you can use dropGemetryTable()
with</DIV>
<DIV>only one parameter: the table name).</DIV>
<DIV> </DIV>
<DIV>Nicolas</DIV>
<DIV>_______________________________________________</DIV>
<DIV>postgis-users mailing list</DIV>
<DIV><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV>
<DIV><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV></TD></TR>
<TR>
<TD id=INCREDIFOOTER width="100%">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD width="100%"></TD>
<TD id=INCREDISOUND vAlign=bottom align=middle></TD>
<TD id=INCREDIANIM vAlign=bottom
align=middle></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><SPAN
id=IncrediStamp><SPAN dir=ltr><A
href="http://www.incredimail.com/index.asp?id=54760"><IMG
alt="Add FUN to your email - CLICK HERE!" hspace=0
src="http://www2.incredimail.com/contents/stamps/imstp_emo_pt.gif"
align=baseline border=0></A></SPAN></SPAN>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BLOCKQUOTE></BODY></HTML>