[postgis-users] AddGeometryColumn problem

[Michael Fuhr]

On Mon, Aug 21, 2006 at 06:22:43PM -0300, Bruno Patini Furtado wrote:
> The schema gis_test does exist. There are no other error messages. I'm using
> the pgAdmin Query Tool and looked for other error messages in all output
> tabs.

Have you looked in the server logs?  The error "current transaction
is aborted, commands ignored until end of transaction block" occurs
when you execute a command in a transaction that has already failed
for some reason.  Example:

test=> BEGIN;
BEGIN
test=> SELECT * FROM no_such_table;
ERROR:  relation "no_such_table" does not exist
test=> SELECT 1;    
ERROR:  current transaction is aborted, commands ignored until end of transaction block

The original error should be in your server logs; if not then you
might need to adjust your logging configuration.

I don't use pgAdmin so I can't give any advice about getting it to
work.  Have you tried running the commands with psql, the command-line
client?  If you're in psql then you can load commands from a file
with "\i file_name", or from the command prompt you can do something
like this:

psql -d database_name -f file_name

If that command fails then please post all of its output.

-- 
Michael Fuhr