Re: show() function - updated patch

Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Joe Conway wrote:
> Joe Conway wrote:
> > 2. This patch includes the same Table Function API fixes that I
> > submitted on July 9:
> >
> > http://archives.postgresql.org/pgsql-patches/2002-07/msg00056.php
> >
> > Please disregard that one *if* this one is applied. If this one is
> > rejected please go ahead with the July 9th patch.
>
> The July 9th Table Function API patch mentioned above is now in CVS, so
> here is an updated version of the guc patch which should apply cleanly
> against CVS tip.
>
> If there are no objections, please apply.
>
> Thanks,
>
> Joe

> Index: src/backend/commands/explain.c
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/src/backend/commands/explain.c,v
> retrieving revision 1.80
> diff -c -r1.80 explain.c
> *** src/backend/commands/explain.c 20 Jun 2002 20:29:27 -0000 1.80
> --- src/backend/commands/explain.c 18 Jul 2002 17:54:10 -0000
> ***************
> *** 15,20 ****
> --- 15,21 ----
> #include "access/heapam.h"
> #include "catalog/pg_type.h"
> #include "commands/explain.h"
> + #include "executor/executor.h"
> #include "executor/instrument.h"
> #include "lib/stringinfo.h"
> #include "nodes/print.h"
> ***************
> *** 38,52 ****
> List *rtable; /* range table */
> } ExplainState;
>
> - typedef struct TextOutputState
> - {
> - TupleDesc tupdesc;
> - DestReceiver *destfunc;
> - } TextOutputState;
> -
> static StringInfo Explain_PlanToString(Plan *plan, ExplainState *es);
> static void ExplainOneQuery(Query *query, ExplainStmt *stmt,
> ! TextOutputState *tstate);
> static void explain_outNode(StringInfo str, Plan *plan, Plan *outer_plan,
> int indent, ExplainState *es);
> static void show_scan_qual(List *qual, bool is_or_qual, const char *qlabel,
> --- 39,47 ----
> List *rtable; /* range table */
> } ExplainState;
>
> static StringInfo Explain_PlanToString(Plan *plan, ExplainState *es);
> static void ExplainOneQuery(Query *query, ExplainStmt *stmt,
> ! TupOutputState *tstate);
> static void explain_outNode(StringInfo str, Plan *plan, Plan *outer_plan,
> int indent, ExplainState *es);
> static void show_scan_qual(List *qual, bool is_or_qual, const char *qlabel,
> ***************
> *** 59,69 ****
> static void show_sort_keys(List *tlist, int nkeys, const char *qlabel,
> StringInfo str, int indent, ExplainState *es);
> static Node *make_ors_ands_explicit(List *orclauses);
> - static TextOutputState *begin_text_output(CommandDest dest, char *title);
> - static void do_text_output(TextOutputState *tstate, char *aline);
> - static void do_text_output_multiline(TextOutputState *tstate, char *text);
> - static void end_text_output(TextOutputState *tstate);
> -
>
> /*
> * ExplainQuery -
> --- 54,59 ----
> ***************
> *** 73,88 ****
> ExplainQuery(ExplainStmt *stmt, CommandDest dest)
> {
> Query *query = stmt->query;
> ! TextOutputState *tstate;
> List *rewritten;
> List *l;
>
> ! tstate = begin_text_output(dest, "QUERY PLAN");
>
> if (query->commandType == CMD_UTILITY)
> {
> /* rewriter will not cope with utility statements */
> ! do_text_output(tstate, "Utility statements have no plan structure");
> }
> else
> {
> --- 63,85 ----
> ExplainQuery(ExplainStmt *stmt, CommandDest dest)
> {
> Query *query = stmt->query;
> ! TupOutputState *tstate;
> ! TupleDesc tupdesc;
> List *rewritten;
> List *l;
>
> ! /* need a tuple descriptor representing a single TEXT column */
> ! tupdesc = CreateTemplateTupleDesc(1);
> ! TupleDescInitEntry(tupdesc, (AttrNumber) 1, "QUERY PLAN",
> ! TEXTOID, -1, 0, false);
> !
> ! /* prepare for projection of tuples */
> ! tstate = begin_tup_output_tupdesc(dest, tupdesc);
>
> if (query->commandType == CMD_UTILITY)
> {
> /* rewriter will not cope with utility statements */
> ! PROJECT_LINE_OF_TEXT("Utility statements have no plan structure");
> }
> else
> {
> ***************
> *** 92,98 ****
> if (rewritten == NIL)
> {
> /* In the case of an INSTEAD NOTHING, tell at least that */
> ! do_text_output(tstate, "Query rewrites to nothing");
> }
> else
> {
> --- 89,95 ----
> if (rewritten == NIL)
> {
> /* In the case of an INSTEAD NOTHING, tell at least that */
> ! PROJECT_LINE_OF_TEXT("Query rewrites to nothing");
> }
> else
> {
> ***************
> *** 102,113 ****
> ExplainOneQuery(lfirst(l), stmt, tstate);
> /* put a blank line between plans */
> if (lnext(l) != NIL)
> ! do_text_output(tstate, "");
> }
> }
> }
>
> ! end_text_output(tstate);
> }
>
> /*
> --- 99,110 ----
> ExplainOneQuery(lfirst(l), stmt, tstate);
> /* put a blank line between plans */
> if (lnext(l) != NIL)
> ! PROJECT_LINE_OF_TEXT("");
> }
> }
> }
>
> ! end_tup_output(tstate);
> }
>
> /*
> ***************
> *** 115,121 ****
> * print out the execution plan for one query
> */
> static void
> ! ExplainOneQuery(Query *query, ExplainStmt *stmt, TextOutputState *tstate)
> {
> Plan *plan;
> ExplainState *es;
> --- 112,118 ----
> * print out the execution plan for one query
> */
> static void
> ! ExplainOneQuery(Query *query, ExplainStmt *stmt, TupOutputState *tstate)
> {
> Plan *plan;
> ExplainState *es;
> ***************
> *** 125,133 ****
> if (query->commandType == CMD_UTILITY)
> {
> if (query->utilityStmt && IsA(query->utilityStmt, NotifyStmt))
> ! do_text_output(tstate, "NOTIFY");
> else
> ! do_text_output(tstate, "UTILITY");
> return;
> }
>
> --- 122,130 ----
> if (query->commandType == CMD_UTILITY)
> {
> if (query->utilityStmt && IsA(query->utilityStmt, NotifyStmt))
> ! PROJECT_LINE_OF_TEXT("NOTIFY");
> else
> ! PROJECT_LINE_OF_TEXT("UTILITY");
> return;
> }
>
> ***************
> *** 192,198 ****
> do_text_output_multiline(tstate, f);
> pfree(f);
> if (es->printCost)
> ! do_text_output(tstate, ""); /* separator line */
> }
> }
>
> --- 189,195 ----
> do_text_output_multiline(tstate, f);
> pfree(f);
> if (es->printCost)
> ! PROJECT_LINE_OF_TEXT(""); /* separator line */
> }
> }
>
> ***************
> *** 836,914 ****
>
> return (Node *) make_orclause(args);
> }
> - }
> -
> -
> - /*
> - * Functions for sending text to the frontend (or other specified destination)
> - * as though it is a SELECT result.
> - *
> - * We tell the frontend that the table structure is a single TEXT column.
> - */
> -
> - static TextOutputState *
> - begin_text_output(CommandDest dest, char *title)
> - {
> - TextOutputState *tstate;
> - TupleDesc tupdesc;
> -
> - tstate = (TextOutputState *) palloc(sizeof(TextOutputState));
> -
> - /* need a tuple descriptor representing a single TEXT column */
> - tupdesc = CreateTemplateTupleDesc(1);
> - TupleDescInitEntry(tupdesc, (AttrNumber) 1, title,
> - TEXTOID, -1, 0, false);
> -
> - tstate->tupdesc = tupdesc;
> - tstate->destfunc = DestToFunction(dest);
> -
> - (*tstate->destfunc->setup) (tstate->destfunc, (int) CMD_SELECT,
> - NULL, tupdesc);
> -
> - return tstate;
> - }
> -
> - /* write a single line of text */
> - static void
> - do_text_output(TextOutputState *tstate, char *aline)
> - {
> - HeapTuple tuple;
> - Datum values[1];
> - char nulls[1];
> -
> - /* form a tuple and send it to the receiver */
> - values[0] = DirectFunctionCall1(textin, CStringGetDatum(aline));
> - nulls[0] = ' ';
> - tuple = heap_formtuple(tstate->tupdesc, values, nulls);
> - (*tstate->destfunc->receiveTuple) (tuple,
> - tstate->tupdesc,
> - tstate->destfunc);
> - pfree(DatumGetPointer(values[0]));
> - heap_freetuple(tuple);
> - }
> -
> - /* write a chunk of text, breaking at newline characters */
> - /* NB: scribbles on its input! */
> - static void
> - do_text_output_multiline(TextOutputState *tstate, char *text)
> - {
> - while (*text)
> - {
> - char *eol;
> -
> - eol = strchr(text, '\n');
> - if (eol)
> - *eol++ = '\0';
> - else
> - eol = text + strlen(text);
> - do_text_output(tstate, text);
> - text = eol;
> - }
> - }
> -
> - static void
> - end_text_output(TextOutputState *tstate)
> - {
> - (*tstate->destfunc->cleanup) (tstate->destfunc);
> - pfree(tstate);
> }
> --- 833,836 ----
> Index: src/backend/executor/execTuples.c
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/src/backend/executor/execTuples.c,v
> retrieving revision 1.54
> diff -c -r1.54 execTuples.c
> *** src/backend/executor/execTuples.c 18 Jul 2002 04:40:30 -0000 1.54
> --- src/backend/executor/execTuples.c 18 Jul 2002 17:54:10 -0000
> ***************
> *** 790,792 ****
> --- 790,862 ----
> return tuple;
> }
>
> + /*
> + * Functions for sending tuples to the frontend (or other specified destination)
> + * as though it is a SELECT result. These are used by utility commands that
> + * need to project directly to the destination and don't need or want full
> + * Table Function capability. Currently used by EXPLAIN and SHOW ALL
> + */
> + TupOutputState *
> + begin_tup_output_tupdesc(CommandDest dest, TupleDesc tupdesc)
> + {
> + TupOutputState *tstate;
> +
> + tstate = (TupOutputState *) palloc(sizeof(TupOutputState));
> +
> + tstate->tupdesc = tupdesc;
> + tstate->destfunc = DestToFunction(dest);
> +
> + (*tstate->destfunc->setup) (tstate->destfunc, (int) CMD_SELECT,
> + NULL, tupdesc);
> +
> + return tstate;
> + }
> +
> + /*
> + * write a single tuple
> + *
> + * values is a list of the external C string representations of the values
> + * to be projected.
> + */
> + void
> + do_tup_output(TupOutputState *tstate, char **values)
> + {
> + /* build a tuple from the input strings using the tupdesc */
> + AttInMetadata *attinmeta = TupleDescGetAttInMetadata(tstate->tupdesc);
> + HeapTuple tuple = BuildTupleFromCStrings(attinmeta, values);
> +
> + /* send the tuple to the receiver */
> + (*tstate->destfunc->receiveTuple) (tuple,
> + tstate->tupdesc,
> + tstate->destfunc);
> + /* clean up */
> + heap_freetuple(tuple);
> + }
> +
> + /* write a chunk of text, breaking at newline characters
> + * NB: scribbles on its input!
> + * Should only be used for a single TEXT attribute tupdesc.
> + */
> + void
> + do_text_output_multiline(TupOutputState *tstate, char *text)
> + {
> + while (*text)
> + {
> + char *eol;
> +
> + eol = strchr(text, '\n');
> + if (eol)
> + *eol++ = '\0';
> + else
> + eol = text + strlen(text);
> + do_tup_output(tstate, &text);
> + text = eol;
> + }
> + }
> +
> + void
> + end_tup_output(TupOutputState *tstate)
> + {
> + (*tstate->destfunc->cleanup) (tstate->destfunc);
> + pfree(tstate);
> + }
> Index: src/backend/utils/misc/guc.c
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/src/backend/utils/misc/guc.c,v
> retrieving revision 1.72
> diff -c -r1.72 guc.c
> *** src/backend/utils/misc/guc.c 18 Jul 2002 02:02:30 -0000 1.72
> --- src/backend/utils/misc/guc.c 18 Jul 2002 17:54:10 -0000
> ***************
> *** 23,30 ****
> --- 23,32 ----
>
> #include "access/xlog.h"
> #include "catalog/namespace.h"
> + #include "catalog/pg_type.h"
> #include "commands/async.h"
> #include "commands/variable.h"
> + #include "executor/executor.h"
> #include "fmgr.h"
> #include "libpq/auth.h"
> #include "libpq/pqcomm.h"
> ***************
> *** 826,832 ****
>
>
> static int guc_var_compare(const void *a, const void *b);
> ! static void _ShowOption(struct config_generic *record);
>
>
> /*
> --- 828,834 ----
>
>
> static int guc_var_compare(const void *a, const void *b);
> ! static char *_ShowOption(struct config_generic *record);
>
>
> /*
> ***************
> *** 2168,2173 ****
> --- 2170,2226 ----
> }
>
> /*
> + * SET command wrapped as a SQL callable function.
> + */
> + Datum
> + set_config_by_name(PG_FUNCTION_ARGS)
> + {
> + char *name;
> + char *value;
> + char *new_value;
> + bool is_local;
> + text *result_text;
> +
> + if (PG_ARGISNULL(0))
> + elog(ERROR, "SET variable name is required");
> +
> + /* Get the GUC variable name */
> + name = DatumGetCString(DirectFunctionCall1(textout, PointerGetDatum(PG_GETARG_TEXT_P(0))));
> +
> + /* Get the desired value or set to NULL for a reset request */
> + if (PG_ARGISNULL(1))
> + value = NULL;
> + else
> + value = DatumGetCString(DirectFunctionCall1(textout, PointerGetDatum(PG_GETARG_TEXT_P(1))));
> +
> + /*
> + * Get the desired state of is_local. Default to false
> + * if provided value is NULL
> + */
> + if (PG_ARGISNULL(2))
> + is_local = false;
> + else
> + is_local = PG_GETARG_BOOL(2);
> +
> + /* Note SET DEFAULT (argstring == NULL) is equivalent to RESET */
> + set_config_option(name,
> + value,
> + (superuser() ? PGC_SUSET : PGC_USERSET),
> + PGC_S_SESSION,
> + is_local,
> + true);
> +
> + /* get the new current value */
> + new_value = GetConfigOptionByName(name);
> +
> + /* Convert return string to text */
> + result_text = DatumGetTextP(DirectFunctionCall1(textin, CStringGetDatum(new_value)));
> +
> + /* return it */
> + PG_RETURN_TEXT_P(result_text);
> + }
> +
> + /*
> * SHOW command
> */
> void
> ***************
> *** 2203,2215 ****
> void
> ShowGUCConfigOption(const char *name)
> {
> ! struct config_generic *record;
>
> ! record = find_option(name);
> ! if (record == NULL)
> ! elog(ERROR, "Option '%s' is not recognized", name);
>
> ! _ShowOption(record);
> }
>
> /*
> --- 2256,2281 ----
> void
> ShowGUCConfigOption(const char *name)
> {
> ! TupOutputState *tstate;
> ! TupleDesc tupdesc;
> ! CommandDest dest = whereToSendOutput;
> ! char *value;
> !
> ! /* need a tuple descriptor representing a single TEXT column */
> ! tupdesc = CreateTemplateTupleDesc(1);
> ! TupleDescInitEntry(tupdesc, (AttrNumber) 1, (char *) name,
> ! TEXTOID, -1, 0, false);
> !
> ! /* prepare for projection of tuples */
> ! tstate = begin_tup_output_tupdesc(dest, tupdesc);
>
> ! /* Get the value */
> ! value = GetConfigOptionByName(name);
>
> ! /* Send it */
> ! PROJECT_LINE_OF_TEXT(value);
> !
> ! end_tup_output(tstate);
> }
>
> /*
> ***************
> *** 2219,2235 ****
> ShowAllGUCConfig(void)
> {
> int i;
>
> for (i = 0; i < num_guc_variables; i++)
> {
> ! struct config_generic *conf = guc_variables[i];
>
> ! if ((conf->flags & GUC_NO_SHOW_ALL) == 0)
> ! _ShowOption(conf);
> }
> }
>
> ! static void
> _ShowOption(struct config_generic *record)
> {
> char buffer[256];
> --- 2285,2399 ----
> ShowAllGUCConfig(void)
> {
> int i;
> + TupOutputState *tstate;
> + TupleDesc tupdesc;
> + CommandDest dest = whereToSendOutput;
> + char *name;
> + char *value;
> + char *values[2];
> +
> + /* need a tuple descriptor representing two TEXT columns */
> + tupdesc = CreateTemplateTupleDesc(2);
> + TupleDescInitEntry(tupdesc, (AttrNumber) 1, "name",
> + TEXTOID, -1, 0, false);
> + TupleDescInitEntry(tupdesc, (AttrNumber) 2, "setting",
> + TEXTOID, -1, 0, false);
> +
> + /* prepare for projection of tuples */
> + tstate = begin_tup_output_tupdesc(dest, tupdesc);
>
> for (i = 0; i < num_guc_variables; i++)
> {
> ! /* Get the next GUC variable name and value */
> ! value = GetConfigOptionByNum(i, &name);
>
> ! /* assign to the values array */
> ! values[0] = name;
> ! values[1] = value;
> !
> ! /* send it to dest */
> ! do_tup_output(tstate, values);
> !
> ! /*
> ! * clean up
> ! */
> ! /* we always should have a name */
> ! pfree(name);
> !
> ! /* but value can be returned to us as a NULL */
> ! if (value != NULL)
> ! pfree(value);
> }
> +
> + end_tup_output(tstate);
> }
>
> ! /*
> ! * Return GUC variable value by name
> ! */
> ! char *
> ! GetConfigOptionByName(const char *name)
> ! {
> ! struct config_generic *record;
> !
> ! record = find_option(name);
> ! if (record == NULL)
> ! elog(ERROR, "Option '%s' is not recognized", name);
> !
> ! return _ShowOption(record);
> ! }
> !
> ! /*
> ! * Return GUC variable value and set varname for a specific
> ! * variable by number.
> ! */
> ! char *
> ! GetConfigOptionByNum(int varnum, char **varname)
> ! {
> ! struct config_generic *conf = guc_variables[varnum];
> !
> ! *varname = pstrdup(conf->name);
> !
> ! if ((conf->flags & GUC_NO_SHOW_ALL) == 0)
> ! return _ShowOption(conf);
> ! else
> ! return NULL;
> ! }
> !
> ! /*
> ! * Return the total number of GUC variables
> ! */
> ! int
> ! GetNumConfigOptions(void)
> ! {
> ! return num_guc_variables;
> ! }
> !
> ! /*
> ! * show_config_by_name - equiv to SHOW X command but implemented as
> ! * a function.
> ! */
> ! Datum
> ! show_config_by_name(PG_FUNCTION_ARGS)
> ! {
> ! char *varname;
> ! char *varval;
> ! text *result_text;
> !
> ! /* Get the GUC variable name */
> ! varname = DatumGetCString(DirectFunctionCall1(textout, PointerGetDatum(PG_GETARG_TEXT_P(0))));
> !
> ! /* Get the value */
> ! varval = GetConfigOptionByName(varname);
> !
> ! /* Convert to text */
> ! result_text = DatumGetTextP(DirectFunctionCall1(textin, CStringGetDatum(varval)));
> !
> ! /* return it */
> ! PG_RETURN_TEXT_P(result_text);
> ! }
> !
> ! static char *
> _ShowOption(struct config_generic *record)
> {
> char buffer[256];
> ***************
> *** 2297,2303 ****
> break;
> }
>
> ! elog(INFO, "%s is %s", record->name, val);
> }
>
>
> --- 2461,2467 ----
> break;
> }
>
> ! return pstrdup(val);
> }
>
>
> Index: src/include/catalog/pg_proc.h
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/src/include/catalog/pg_proc.h,v
> retrieving revision 1.243
> diff -c -r1.243 pg_proc.h
> *** src/include/catalog/pg_proc.h 20 Jun 2002 20:29:44 -0000 1.243
> --- src/include/catalog/pg_proc.h 18 Jul 2002 17:54:10 -0000
> ***************
> *** 2881,2886 ****
> --- 2881,2891 ----
> DATA(insert OID = 2074 ( substring PGNSP PGUID 14 f f f t f i 3 25 "25 25 25" 100 0 0 100 "select substring($1, like_escape($2, $3))" - _null_ ));
> DESCR("substitutes regular expression with escape argument");
>
> + DATA(insert OID = 2090 ( current_setting PGNSP PGUID 12 f f f t f s 1 25 "25" 100 0 0 100 show_config_by_name - _null_ ));
> + DESCR("SHOW X as a function");
> + DATA(insert OID = 2091 ( set_config PGNSP PGUID 12 f f f f f v 3 25 "25 25 16" 100 0 0 100 set_config_by_name - _null_ ));
> + DESCR("SET X as a function");
> +
> /* Aggregates (moved here from pg_aggregate for 7.3) */
>
> DATA(insert OID = 2100 ( avg PGNSP PGUID 12 t f f f f i 1 1700 "20" 100 0 0 100 aggregate_dummy - _null_ ));
> Index: src/include/executor/executor.h
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/src/include/executor/executor.h,v
> retrieving revision 1.69
> diff -c -r1.69 executor.h
> *** src/include/executor/executor.h 26 Jun 2002 21:58:56 -0000 1.69
> --- src/include/executor/executor.h 18 Jul 2002 17:54:10 -0000
> ***************
> *** 121,126 ****
> --- 121,145 ----
> extern TupleDesc ExecTypeFromTL(List *targetList);
> extern void SetChangedParamList(Plan *node, List *newchg);
>
> + typedef struct TupOutputState
> + {
> + TupleDesc tupdesc;
> + DestReceiver *destfunc;
> + } TupOutputState;
> +
> + extern TupOutputState *begin_tup_output_tupdesc(CommandDest dest, TupleDesc tupdesc);
> + extern void do_tup_output(TupOutputState *tstate, char **values);
> + extern void do_text_output_multiline(TupOutputState *tstate, char *text);
> + extern void end_tup_output(TupOutputState *tstate);
> +
> + #define PROJECT_LINE_OF_TEXT(text_to_project) \
> + do { \
> + char *values[1]; \
> + values[0] = text_to_project; \
> + do_tup_output(tstate, values); \
> + } while (0)
> +
> +
> /*
> * prototypes from functions in execUtils.c
> */
> Index: src/include/utils/builtins.h
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/src/include/utils/builtins.h,v
> retrieving revision 1.186
> diff -c -r1.186 builtins.h
> *** src/include/utils/builtins.h 20 Jun 2002 20:29:52 -0000 1.186
> --- src/include/utils/builtins.h 18 Jul 2002 17:54:10 -0000
> ***************
> *** 633,636 ****
> --- 633,640 ----
> extern Datum quote_ident(PG_FUNCTION_ARGS);
> extern Datum quote_literal(PG_FUNCTION_ARGS);
>
> + /* guc.c */
> + extern Datum show_config_by_name(PG_FUNCTION_ARGS);
> + extern Datum set_config_by_name(PG_FUNCTION_ARGS);
> +
> #endif /* BUILTINS_H */
> Index: src/include/utils/guc.h
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/src/include/utils/guc.h,v
> retrieving revision 1.17
> diff -c -r1.17 guc.h
> *** src/include/utils/guc.h 17 May 2002 01:19:19 -0000 1.17
> --- src/include/utils/guc.h 18 Jul 2002 17:54:10 -0000
> ***************
> *** 86,91 ****
> --- 86,94 ----
> bool isLocal, bool DoIt);
> extern void ShowGUCConfigOption(const char *name);
> extern void ShowAllGUCConfig(void);
> + extern char *GetConfigOptionByName(const char *name);
> + extern char *GetConfigOptionByNum(int varnum, char **varname);
> + extern int GetNumConfigOptions(void);
>
> extern void SetPGVariable(const char *name, List *args, bool is_local);
> extern void GetPGVariable(const char *name);

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026