[postgis-users] Re: a newbie question

[Laurence Rowe]

Have you granted permission for the attaching user to access the table? 
Something like:

     GRANT select on foo to PUBLIC;

If you still don't have any luck then try looking for an error in the 
logfile to narrow down the possibilities.

Laurence

Gustavo Ces wrote:
> Sorry about this question,
>  
>     i want to create another table from selecting a previous one ( with 
> the_geom and gid)
>  
> create table foo as select gid, the_geom, other_columns from previous_table
>  
> this query creates the table with the other columns, gid and geom but if 
> try to open it in a client, it fails.
>  
> Which is the problem?
>  
> Thanks,
>  
> Galois
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users