Re: default_language

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: default_language
Date: 2010-01-25 14:30:56
Message-ID: 603c8f071001250630u3e42e012sb597cc23a12af08@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jan 25, 2010 at 3:55 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Mon, 2010-01-25 at 09:08 +0200, Peter Eisentraut wrote:
>> On sön, 2010-01-24 at 20:32 +0000, Simon Riggs wrote:
>> > Why do we have a parameter called "default_do_language" when we don't
>> > have a parameter called "default_language"?
>>
>> According to the SQL standard, the default language for CREATE FUNCTION
>> is SQL.  Should we implement that?
>
> So the SQL Standard supports the concept of a default language?
>
> So should we, though giving the user the choice of what the default
> should be, standard or otherwise.

I guess I'll add myself to the list of people who think this is a bad
idea, for all the reasons previously stated. This will turn into
another setting like search_path and standard_conforming_strings that
can break working code if the actual value doesn't match the
anticipated value. I can't figure out why someone would want to use
this even if we had it.

+1 for removing default_do_language, too.

...Robert

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2010-01-25 14:40:29 Re: default_language
Previous Message Simon Riggs 2010-01-25 14:25:53 Re: Re: pgsql: In HS, Startup process sets SIGALRM when waiting for buffer pin.