'Re: [postgis-users] Cannot erase Table'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Cannot erase Table
From:       <vega_l () yahoo ! com>
Date:       2009-12-27 14:12:46
Message-ID: 235851.8235.qm () web110309 ! mail ! gq1 ! yahoo ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

It worked!

"DROP TABLE forestshape ; "

It's my first day with this system, sorry for the rookie mistake.

Thank you very much!

--- On Sun, 12/27/09, Guillaume Lelarge <guillaume@lelarge.info> wrote:

From: Guillaume Lelarge <guillaume@lelarge.info>
Subject: Re: [postgis-users] Cannot erase Table
To: vega_l@yahoo.com
Cc: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net>
Date: Sunday, December 27, 2009, 9:59 PM

Le 27/12/2009 12:49, vega_l@yahoo.com a écrit :
> Thank you very much for replying
> 
> I didn't add any ";" at the end.

You should. Did you try with?

> Perhaps some more details would help:
> 
> The "forestshape" table was created by importing a vector map with the command \
> "v.in.ogr" from GRASS 6.4" into the PostGIS database "luis". 
> Also, the user "luis" in PostGIS is associated to a password, lets say "1234".
> 
> I'm using Ubuntu 9.04 (amd64) with postgis 1.3.3 and postgresql 8.3 , which \
> according to the guys from UbuntuGIS, all these program versions work armoniously \
> with QGIS 1.3. (I'm trying to be careful with program versions to avoid \
> incompatibility issues while using OSGIS software) 
> Does "DROP TABLE" should be used indicating a password?
> 

No.

See http://www.postgresql.org/docs/8.3/interactive/sql-droptable.html
for more details.

-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

[Attachment #5 (text/html)]

<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: \
inherit;">It worked! "DROP TABLE forestshape ; " It's my first day with \
this system, sorry for the rookie mistake. Thank you very much! --- On \
Sun, 12/27/09, Guillaume Lelarge &lt;guillaume@lelarge.info&gt; \
wrote: <blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: \
5px; padding-left: 5px;"> From: Guillaume Lelarge \
&lt;guillaume@lelarge.info&gt; Subject: Re: [postgis-users] Cannot erase \
Table To: vega_l@yahoo.com Cc: "PostGIS Users Discussion" \
&lt;postgis-users@postgis.refractions.net&gt; Date: Sunday, December 27, 2009, \
9:59 PM <div class="plainMail">Le 27/12/2009 12:49, <a \
ymailto="mailto:vega_l@yahoo.com" \
href="/mc/compose?to=vega_l@yahoo.com">vega_l@yahoo.com</a> a écrit : &gt; Thank \
you very much for replying &gt; &gt; I didn't add any ";" at the \
end. You should. Did you try with? &gt; Perhaps some more details \
would help: &gt; &gt; The "forestshape" table was created by importing a \
vector map with the command "v.in.ogr" from GRASS 6.4" into the PostGIS database \
"luis". &gt; &gt; Also, the user "luis" in PostGIS is associated to a \
password, lets say "1234". &gt; &gt; I'm using Ubuntu 9.04 (amd64) with \
postgis 1.3.3 and postgresql 8.3 , which according to the guys from UbuntuGIS, all \
these program versions work armoniously with QGIS 1.3. (I'm trying to be careful with \
program versions to avoid incompatibility issues while using OSGIS software) &gt; \
 &gt; Does "DROP TABLE" should be used indicating a password? &gt; \
 No. See <a \
href="http://www.postgresql.org/docs/8.3/interactive/sql-droptable.html" \
target="_blank">http://www.postgresql.org/docs/8.3/interactive/sql-droptable.html</a> for \
more details. -- Guillaume. <a href="http://www.postgresqlfr.org" \
target="_blank">http://www.postgresqlfr.org</a> <a href="http://dalibo.com" \
target="_blank">http://dalibo.com</a> </div></blockquote></td></tr></table>

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 