Re: DEFAULT of domain ignored in plpgsql (8.4.1)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
Cc: Postgresql-Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: DEFAULT of domain ignored in plpgsql (8.4.1)
Date: 2009-11-20 17:53:59
Message-ID: 603c8f070911200953k287adabbie007b50727e94983@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Nov 20, 2009 at 12:51 PM, Florian G. Pflug <fgp(at)phlo(dot)org> wrote:
> Robert Haas wrote:
>>
>> On Thu, Nov 19, 2009 at 9:06 PM, Florian G. Pflug <fgp(at)phlo(dot)org> wrote:
>>>
>>> I've tried to create a patch, but didn't see how I'd convert the result
>>> from get_typedefault() (A Node*, presumeably the parsetree corresponding
>>> to the default expression?) into a plan that I could store in a
>>> PLpgSQL_expr. I guess I'd need something like SPI_prepare_plan that
>>> takes a parse tree instead of a query string. Or am I on a completely
>>> wrong track there?
>>>
>>> While trying to cook up a patch I've also stumbled over what I perceive
>>> as a bug relating to DOMAINS and column DEFAULTs. I'll write that up in
>>> a second E-Mail to avoid confusion.
>>
>> I suggest adding this to the open CommitFest (2010-01) at
>> https://commitfest.postgresql.org/action/commitfest_view/open
>
> Hm, but I don't (yet) have a patch to add...

Woops, I saw an attachment and thought there was a patch, but it was
just smime.p7s... sorry for the noise.

...Robert

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2009-11-20 18:16:03 Re: Prettification versus dump safety
Previous Message Florian G. Pflug 2009-11-20 17:51:50 Re: DEFAULT of domain ignored in plpgsql (8.4.1)