[postgis-users] geometry column permission denied

[David Epstein]

Paul,

It has taken some time for me to get back to this problem. You were
indeed correct. Now that it is actually working I have some other
questions that I will post under another subject. Thank you again for
your help!

-david

------------

Date: Wed, 09 Jan 2008 09:13:35 -0800
From: Paul Ramsey <pramsey at refractions.net>
Subject: Re: [postgis-users] geometry column permission denied using
        shp2pgsql

Permission problems and encoding problems are quite separate, so let's  
examine the first problem first. Your first error is the permission  
problem. What happens when you log in as yourself with psql and try to  
insert a column into geometry_columns? Hopefully it should fail, since  
that's all the shp2pgsql-generated script is doing.

Run \d and see who owns that table. Probably it's owned by postgres  
and you don't have rights to it. Log in as postgres and do some GRANTS  
to provide yourself permissions and run from there.

The encoding issue is separate, and you seem to be on the right track  
with the -W switch, assuming that ISO-8859-8  is in fact the original  
encoding.