Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#585 closed defect (fixed)

Error running topology.sql

Reported by: aperi2007 Owned by: pramsey
Priority: medium Milestone: PostGIS 2.0.0
Component: topology Version: 1.5.X
Keywords: Cc:

Description

Try-ing to install the topology module, when I try to run

make psql -h localhost -f topology.sql

I have an error and all rollbacks.

…… psql:topology.sql:676: ERROR: syntax error at or near "table"

RIGA 60:
quote_literal(table) ,

psql:topology.sql:683: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:topology.sql:784: ERROR: current transaction is aborted, commands ignored until end of transaction block …..

I'm using

postgres 9.0rc1 postgis r5960 geos r3104 on Debian 5.0 Lenny 32 bit.

Attachments (1)

no_table.patch (3.9 KB ) - added by strk 12 years ago.

Download all attachments as: .zip

Change History (5)

by strk, 12 years ago

Attachment: no_table.patch added

comment:1 by strk, 12 years ago

Please try applying the attached patch (no_table.patch).

$ cd topology
$ wget http://trac.osgeo.org/postgis/raw-attachment/ticket/585/no_table.patch
$ patch -p0 < no_table.patch

I don't have 9.0 to test atm

comment:2 by aperi2007, 12 years ago

Hi,

I tested it. Now it was execute without errors.

Just an addendum:

I think the README must be enhanced . Now it say this:

make psql -f topology.sql

I think was better something like this (more general):

make psql -f -d <database postgis enabled> -U <username owner database> -f topology.sql

Regards,

Andrea.

comment:3 by strk, 12 years ago

Resolution: fixed
Status: newclosed

Thanks for testing. Committed in r5964. README updated to include the postgis-enable requirement in r5965.

comment:4 by robe, 12 years ago

Component: postgistopology
Note: See TracTickets for help on using tickets.