RE: Raw constraint & pg_relcheck.rcsrc

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: Raw constraint & pg_relcheck.rcsrc
Дата
Msg-id 000501bffdbd$7997c8e0$2801007e@tpf.co.jp
обсуждение исходный текст
Ответ на Re: Raw constraint & pg_relcheck.rcsrc  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> -----Original Message-----
> From: Tom Lane
> 
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > Is there any way to convert rcbin(cooked text format) to the
> > raw(pre-cooked) Node expression?
> 
> No.
> 
> > Or is there a way to
> > convert rcsrc to the pre-cooked Node expression ?
> > Or is there a way to convert rcsrc to the cooked expression ?
>

[snip]
> Another possibility is to determine the mapping from parent columns
> to child columns, and then walk through the (cooked) expression tree
> and substitute varattno field values in Var nodes accordingly.  I'm
> not certain that's sufficient, but if it is it'd be a fairly small
> amount of code (in fact you might be able to just call the routines in
> the rewriter that do similar things).
>

OK,I would try this way using expression_tree_walker() which I
used once in my trial for ALTER TABLE DROP COLUMN.

Thanks.

Hiroshi Inoue
Inoue@tpf.co.jp


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: Anyone particularly wedded to func_tlist mechanism?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Anyone particularly wedded to func_tlist mechanism?