Dash in Extension Names

Started by David E. Wheelerabout 14 years ago3 messages
#1David E. Wheeler
david@kineticode.com

Hackers,

So after Tom made "--" the separator between an extension name and the version information in extension file names -- because one might use "-" in the name itself, but probably not "--" -- it seems that the dash is not actually allowed:

create extension pgtap-core;
ERROR: syntax error at or near "-"
LINE 1: create extension pgtap-core;

Parser error?

Thanks,

David

#2Itagaki Takahiro
itagaki.takahiro@gmail.com
In reply to: David E. Wheeler (#1)
Re: Dash in Extension Names

On Fri, Nov 11, 2011 at 14:40, David E. Wheeler <david@kineticode.com> wrote:

one might use "-" in the name itself, but probably not "--" -- it seems that the dash is not actually allowed:

   create extension pgtap-core;
   ERROR:  syntax error at or near "-"
   LINE 1: create extension pgtap-core;

Parser error?

You need double-quotes around the name:
=# CREATE EXTENSION "uuid-ossp";
CREATE EXTENSION

--
Itagaki Takahiro

#3David E. Wheeler
david@kineticode.com
In reply to: Itagaki Takahiro (#2)
Re: Dash in Extension Names

On Nov 10, 2011, at 9:45 PM, Itagaki Takahiro wrote:

Parser error?

You need double-quotes around the name:
=# CREATE EXTENSION "uuid-ossp";
CREATE EXTENSION

Ah! Okay, thank you!

David