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 <[email protected]> wrote: From: Guillaume Lelarge <[email protected]> Subject: Re: [postgis-users] Cannot erase Table To: "PostGIS Users Discussion" <[email protected]> Cc: [email protected] Date: Sunday, December 27, 2009, 5:21 PM Le 27/12/2009 08:43, [email protected] 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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
