[postgis-users] Cannot erase Table

[vega_l at yahoo.com]

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 at lelarge.info> wrote:

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

Le 27/12/2009 12:49, vega_l at 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



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091227/1c695f10/attachment.html>