On Tue, Jan 22, 2013 at 2:31 PM, <jan-peter.seif...@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
