Re: Dash in Extension Names

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Dash in Extension Names
Date: 2011-11-11 05:45:08
Message-ID: CAJW2+qf6CHYO9VDzt2iR+rojocTv8K=FCnMoaKSAh-QLaARfAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 11, 2011 at 14:40, David E. Wheeler <david(at)kineticode(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikhil Sontakke 2011-11-11 06:04:09 Re: Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers
Previous Message David E. Wheeler 2011-11-11 05:40:43 Dash in Extension Names