Error running topology.sql

[aperi2007]

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.

[strk]

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

[aperi2007]

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.

[strk]

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