Query Deparsing Support

Поиск
Список
Период
Сортировка
От Jason Petersen
Тема Query Deparsing Support
Дата
Msg-id 5E5BB0F8-B05E-47C2-8706-F85E70A6DF7D@citusdata.com
обсуждение исходный текст
Список pgsql-hackers
The DDL deparse support that just landed looks impressive, but I’ve needed <i class="">query</i> deparsing for some
timenow. Within <a class="" href="https://github.com/citusdata/pg_shard">pg_shard</a> we took the fast-and-dirty
approachof merging in a modified ruleutils.c, though I’d (obviously) like to get away from that.<div class=""><br
class=""/></div><div class="">Many of ruleutils.c’s functions already have a public interface; would there be any
objectionto exposing get_query_def to provide a way to turn a Query back into an SQL string?</div><div class=""><br
class=""/></div><div class="">A more structured approach analogous to the new DDL stuff would make my life easier, but
simplyhaving the Query-to-SQL function would be a huge improvement for now.</div><div class=""><br class=""
/></div><divclass="">I trawled through the archives but couldn’t find any discussion of why this function was kept
static.</div><divclass=""><br class="" /></div><div class=""><div apple-content-edited="true" class=""><div class=""
style="color:rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal;
font-weight:normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px;
text-transform:none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><font
class=""color="#919191">--</font></div><div class="" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size:
12px;font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal;
orphans:auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto;
word-spacing:0px; -webkit-text-stroke-width: 0px;"><font class="" color="#919191"><b class="">Jason
Petersen</b></font></div><divclass="" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style:
normal;font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto;
text-align:start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width:0px;"><span class="" style="color: rgb(145, 145, 145);"><font class="" size="1">Software
Engineer| Citus Data</font></span></div><div class="" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size:
12px;font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal;
orphans:auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto;
word-spacing:0px; -webkit-text-stroke-width: 0px;"><font class="" color="#919191"
size="1">303.736.9255</font></div><divclass="" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px;
font-style:normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans:
auto;text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width:0px;"><font class="" color="#919191" size="1"><a class=""
href="mailto:jason@citusdata.com">jason@citusdata.com</a></font></div></div><brclass="" /></div> 

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: BackendPidGetProc doesn't return PGPROC for background worker?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Patch for bug #12845 (GB18030 encoding)