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

From Jan-Peter Seifert
Subject Re: BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error
Date
Msg-id 50FF17DD.1070400@gmx.de
Whole thread Raw
In response to Re: BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error  (Marc Balmer <marc@msys.ch>)
List pgsql-bugs
Am 22.01.2013 14:47, schrieb Marc Balmer:

> no.  Your syntax is wrong.

Well - it's not exactly 'my' syntax - see:
uuid-ossp--1.0.sql
uuid-ossp--unpackaged--1.0.sql

>> I had to replace the hyphen in file names and in the scripts to make the
>> module work.
>>
> That is the wrong "fix".  The hyphen has a meaning in SQL. So you need to properly enclose uuid-ossp in quotes.

I didn't think about the fact that extensions are database objects, too.
It's a bit annoying that this extension has non-standard characters in
its name though. It's the only one from all that currently exist.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error
Next
From: Jeff Janes
Date:
Subject: Re: BUG #7814: Rotation of the log is not carried out.