[postgis-users] Cannot erase Table

[vega_l at yahoo.com]

Thank you very much for replying

I didn't add any ";" at the end. 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?

Luis Alberto.

--- 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: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Cc: vega_l at yahoo.com
Date: Sunday, December 27, 2009, 5:21 PM

Le 27/12/2009 08:43, vega_l at yahoo.com a écrit :
> Hello everyone, I hope someone can help me.
> 
> This might sound very basic, but I can't erase the data table "forestshape".
> 
>             List of relations
>  Schema |       Name       | Type  | Owner 
> --------+------------------+-------+-------
>  public | forestshape      | table | luis
>  public | geometry_columns | table | luis
>  public | spatial_ref_sys  | table | luis
> (3 rows)
> 
> I'm the owner in this database named "luis" with user "luis". But when executing "DROP TABLE forestshape" and "DROP SEQUENCE forestshape", nothing happens, not even an error message is shown. When I execute "\dt", the table "forestshape" is still there.
> 

Did you put a ; behind forestshape? as in

DROP TABLE forestshape;

I don't see any other reason why you have no message telling you the
command failed.


-- 
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/bf68dc37/attachment.html>