Re: DEFAULT of domain ignored in plpgsql (8.4.1)

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
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:51:50
Message-ID: 4B06D736.2080306@phlo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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...

best regards,
Florian Pflug

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-11-20 17:53:59 Re: DEFAULT of domain ignored in plpgsql (8.4.1)
Previous Message Joshua D. Drake 2009-11-20 17:30:36 Re: Summary and Plan for Hot Standby