Обсуждение: Dash in Extension Names

Поиск
Список
Период
Сортировка

Dash in Extension Names

От
"David E. Wheeler"
Дата:
Hackers,

So after Tom made "--" the separator between an extension name and the version information in extension file names --
becauseone 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




Re: Dash in Extension Names

От
Itagaki Takahiro
Дата:
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


Re: Dash in Extension Names

От
"David E. Wheeler"
Дата:
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