[postgis-users] Cannot erase Table

[Guillaume Lelarge]

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