Opened 17 years ago

Last modified 17 years ago

#28 closed defect (invalid)

syntax error at or near "quote_ident" in lwpostgis.sql and lwpostgis_upgrade.sql

Reported by: sysadmin.kooman Owned by:
Priority: medium Milestone:
Component: postgis Version:
Keywords: Cc:

Description

What steps will reproduce the problem?

  1. Run script lwpostgis.sql on a database without existing postgis funtions
  2. Run script lwpostgis_upgrade.sql on a database with postgis functions

What is the expected output? What do you see instead? Output 1: psql:lwpostgis.sql:2854: ERROR: syntax error at or near 'quote_ident'

Output 2: psql:lwpostgis_upgrade.sql:1667: ERROR: syntax error at or near 'quote_ident'

What version of the product are you using? On what operating system? 1.3.3 (2008/04/12) on Ubuntu 8.0.4 (Hardy Heron)

Please provide any additional information below. We found the bug as well. There are two pipe symbols missing at line number

2846 in file lwpostgis.sql. There are two pipe symbols missing at line

number 1659 in lwpostgis_upgrade.sql

EXECUTE DROP TABLE should be:

EXECUTE DROP TABLE

Change History (1)

comment:1 by pramsey, 17 years ago

Not seeing this problem in 1.3 branch. The two
signs in my copy show up on the

succeeding line.

Note: See TracTickets for help on using tickets.