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

From: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: Marc Balmer <marc(at)msys(dot)ch>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error
Date: 2013-01-22 22:51:09
Message-ID: 50FF17DD.1070400@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2013-01-22 22:59:18 Re: BUG #7814: Rotation of the log is not carried out.
Previous Message rboudwin 2013-01-22 20:55:31 BUG #7825: pgAdmin III won't allow unchecking superuser