Re: BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

Am 22.01.2013 um 14:31 schrieb Jan-Peter.Seifert@gmx.de:

> The following bug has been logged on the website:
>=20
> Bug reference:      7820
> Logged by:          Jan-Peter Seifert
> Email address:      Jan-Peter.Seifert@gmx.de
> PostgreSQL version: 9.1.7
> Operating system:   Windows 7 64-bit
> Description:       =20
>=20
> The statement:
> 'CREATE EXTENSION uuid-ossp'
>=20
> just gives me a syntax error:
>=20
> ERROR:  syntax error at or near "-"
> LINE 1: CREATE EXTENSION uuid-ossp
>                           ^
> ********** Fehler **********
>=20
> ERROR: syntax error at or near "-"
> SQL Status:42601
> Zeichen:22
>=20
> Obviously "CREATE EXTENSION" expects underscores instead of hyphens.

no.  Your syntax is wrong.

>=20
> I had to replace the hyphen in file names and in the scripts to make =
the
> module work.
>=20

That is the wrong "fix".  The hyphen has a meaning in SQL.  So you need =
to properly enclose uuid-ossp in quotes.