[postgis-users] AddGeometryColumn problem

[Bruno Patini Furtado]

Sorry about the mess on brazil_tiled(2). I've tried with the correct tables
in my scripts.

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.

Prior to my first email I'd tried to execute only the statement bellow
without success:

SELECT
AddGeometryColumn('gis_test','brazil_tiled','the_geom','-1','MULTIPOLYGON',2);

But the error message is the one I've posted, too generic to give at least a
hint about the error.

The first lines of the generated script I'm trying to execute are:

BEGIN;
CREATE TABLE "gis_test"."brazil_tiled2" (gid serial PRIMARY KEY,
"location" varchar(255));
SELECT
AddGeometryColumn('gis_test','brazil_tiled2','the_geom','-1','MULTIPOLYGON',2);
INSERT INTO "gis_test"."brazil_tiled2" ("location",the_geom) VALUES ('
NA-19-X-C.tif
','01060000000100000001030000000100000005000000007082D2064051C00000321126FF074000705BD206E050C00000321126FF074000705BD206E050C00000E41B4CFEFF3F007082D2064051C00000E41B4CFEFF3F007082D2064051C00000321126FF0740');

I've tried without the BEGIN|END transaction statements, without the create
table (as I created the table myself), only the select AddGeometryColumn,
etc. All with the same error messages.

Any Hints?


On 8/21/06, Michael Fuhr <mike at fuhr.org> wrote:
>
> On Mon, Aug 21, 2006 at 03:43:21PM -0300, Bruno Patini Furtado wrote:
> > I've just installed PostgreSQL 8.1.4 without the GIS extensions and
> after
> > that installed the postgis-pg81-setup-1.1.3-1.exe from
> > http://postgis.refractions.net/download/windows/. ]
> >
> > Everything went fine but when I try to run the SQL statements generated
> by
> > the shp2pgsql program, the error message "ERROR:  current transaction is
> > aborted, commands ignored until end of transaction block" is reported.
>
> Some previous command failed; no subsequent commands will be allowed
> until the transaction is rolled back.  What error messages do you see
> prior to the one shown above?  Whatever earlier command is failing is
> the one that needs attention.
>
> > I've tried to run only the create table statement, but the same error
> > message was reported.
> > So I've changed:
> > CREATE TABLE "gis_test"."brazil_tiled2" (gid serial PRIMARY KEY,
> > "location" varchar(255));
> > To:
> > CREATE TABLE gis_test.brazil_tiled
>
> Which name is it supposed to be -- brazil_tiled or brazil_tiled2?
> Does the schema gis_test exist?
>
> --
> Michael Fuhr
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
"Minds are like parachutes, they work best when open."

Bruno Patini Furtado
Software Developer
webpage: http://bpfurtado.net
software development blog: http://bpfurtado.livejournal.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060821/9ca5d16b/attachment.html>