From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <peter_e(at)gmx(dot)net> |
Subject: | SHOW ALL as a query result |
Date: | 2002-04-03 01:49:32 |
Message-ID: | GNELIHDDFBOCMGBFGEFOGEPACBAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi All,
Now that Tom's modified the EXPLAIN output to appear as a query result,
maybe SHOW and SHOW ALL should also be modified in that way. The current
NOTICE: business is a bit messy, and it sure would assist projects just as
pgAccess, phpPgAdmin and pgAdmin with displaying configuration!
Also, what else could be usefully modified?
Chris
ps.
>>BTW, see: ~/pgsql/src/backend/commands/explain.c
>>for the new functions Tom Lane wrote which send explain results to the
>>front end as if they were from a select statement. Very informative.
>>Specifically see:
>> begin_text_output(CommandDest dest, char *title);
>> do_text_output(TextOutputState *tstate, char *aline);
>> do_text_output_multiline(TextOutputState *tstate, char *text);
>> end_text_output(TextOutputState *tstate);
>
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-04-03 01:51:47 | Re: ANALYZE after restore |
Previous Message | Gavin Sherry | 2002-04-03 01:47:29 | Re: Suggestions please: names for function cachability |