On Tue, Jan 22, 2013 at 2:31 PM, <Jan-Peter.Seifert@gmx.de> wrote:
> The statement:
> 'CREATE EXTENSION uuid-ossp'
>
> just gives me a syntax error:
>
> ERROR: syntax error at or near "-"
> LINE 1: CREATE EXTENSION uuid-ossp
> ^
> ********** Fehler **********
>
> ERROR: syntax error at or near "-"
> SQL Status:42601
> Zeichen:22
>
> Obviously "CREATE EXTENSION" expects underscores instead of hyphens.
>
> I had to replace the hyphen in file names and in the scripts to make the
> module work.
>
This is not a bug. You need to quote identifiers that have non-identifier
characters in them, like so:
CREATE EXTENSION "uuid-ossp";
Vik
