On Tue, Jan 22, 2013 at 10:26 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Heikki Linnakangas <hlinnakan...@vmware.com> writes: >> On 22.01.2013 15:31, jan-peter.seif...@gmx.de wrote: >> Try: >> CREATE EXTENSION "uuid-ossp" > > Although this isn't a bug, it does seem like a usability fail. > Did we make a conscious decision not to call the extension uuid_ossp? > I can't remember one way or the other. It's probably too late to change > now, though :-(
I sort of have good recollection of the history here, I think, because people have asked me about it quite a few times.... uuid-ossp.sql, pre CREATE EXTENSION was always named as such, so carrying forward the most obvious port to CREATE EXTENSION results in a non-SQL safe identifier. Pre CREATE EXTENSION it didn't seem obvious that it would matter how the extension would be named, as long as it looked okay in psql -f or psql \i, which it did. Considering the history, most people seem to understand how things ended up in this way, although it's still a little annoying, and definitely confusing. -- fdr -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs