Re: Patch to change psql default banner v6
Guillaume Lelarge <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.patches |
|---|---|
| Message-ID | <[email protected]> |
Tom Lane a écrit : > "Joshua D. Drake" <[email protected]> writes: >> Andrew Dunstan wrote: >>> Have at it then. Prove me wrong. > >> IMO the problem isn't the one off support for all supported version of >> Pg... say 7.4 -> 8.4. The problem is of on going maintenance. > >> /me doesn't think it is worth the effort. > > Since no one's done it yet, that would seem to be the consensus > opinion :-) > > Still, it'd be interesting to see an attempt at making it go. > The costs of doing it now for existing versions would probably give us > a good idea of what the future maintenance effort might be like. > Without a real patch to look at, we're all just guessing about that. > Here is a patch that tries to implement this. Meta-commands should work from 7.4 to 8.4-devel releases. It was not hard to do, and I don't think it really is a burden to maintain. One part left to fix is \du and \dg commands. I would be glad to continue to work on this but I would prefer to have comments before. Thanks. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-patches mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches
psql.patch
(text/x-patch, 21 KB)
Index: describe.c
===================================================================
RCS file: /opt/cvsroot_postgresql/pgsql/src/bin/psql/describe.c,v
retrieving revision 1.173
diff -c -c -r1.173 describe.c
*** describe.c 13 May 2008 00:23:17 -0000 1.173
--- describe.c 19 May 2008 17:19:28 -0000
***************
*** 59,68 ****
* There are two kinds of aggregates: ones that work on particular types
* and ones that work on all (denoted by input type = "any")
*/
printfPQExpBuffer(&buf,
"SELECT n.nspname as \"%s\",\n"
" p.proname AS \"%s\",\n"
! " pg_catalog.format_type(p.prorettype, NULL) AS \"%s\",\n"
" CASE WHEN p.pronargs = 0\n"
" THEN CAST('*' AS pg_catalog.text)\n"
" ELSE\n"
--- 59,75 ----
* There are two kinds of aggregates: ones that work on particular types
* and ones that work on all (denoted by input type = "any")
*/
+
printfPQExpBuffer(&buf,
"SELECT n.nspname as \"%s\",\n"
" p.proname AS \"%s\",\n"
! " pg_catalog.format_type(p.prorettype, NULL) AS \"%s\"",
! gettext_noop("Schema"),
! gettext_noop("Name"),
! gettext_noop("Result data type"));
!
! if (pset.sversion >= 80100)
! appendPQExpBuffer(&buf, ",\n"
" CASE WHEN p.pronargs = 0\n"
" THEN CAST('*' AS pg_catalog.text)\n"
" ELSE\n"
***************
*** 72,86 ****
" FROM\n"
" pg_catalog.generate_series(0, pg_catalog.array_upper(p.proargtypes, 1)) AS s(i)\n"
" ), ', ')\n"
! " END AS \"%s\",\n"
! " pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"\n"
"FROM pg_catalog.pg_proc p\n"
" LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n"
"WHERE p.proisagg\n",
- gettext_noop("Schema"),
- gettext_noop("Name"),
- gettext_noop("Result data type"),
- gettext_noop("Argument data types"),
gettext_noop("Description"));
processSQLNamePattern(pset.db, &buf, pattern, true, false,
--- 79,91 ----
" FROM\n"
" pg_catalog.generate_series(0, pg_catalog.array_upper(p.proargtypes, 1)) AS s(i)\n"
" ), ', ')\n"
! " END AS \"%s\"",
! gettext_noop("Argument data types"));
!
! appendPQExpBuffer(&buf, ",\n pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"\n"
"FROM pg_catalog.pg_proc p\n"
" LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace\n"
"WHERE p.proisagg\n",
gettext_noop("Description"));
processSQLNamePattern(pset.db, &buf, pattern, true, false,
***************
*** 132,142 ****
gettext_noop("Location"));
if (verbose)
appendPQExpBuffer(&buf,
! ",\n spcacl AS \"%s\""
! ",\n pg_catalog.shobj_description(oid, 'pg_tablespace') AS \"%s\"",
! gettext_noop("Access privileges"),
gettext_noop("Description"));
appendPQExpBuffer(&buf,
"\nFROM pg_catalog.pg_tablespace\n");
--- 137,151 ----
gettext_noop("Location"));
if (verbose)
+ {
appendPQExpBuffer(&buf,
! ",\n spcacl AS \"%s\"",
! gettext_noop("Access privileges"));
! if (pset.sversion >= 80200)
! appendPQExpBuffer(&buf,
! ",\n pg_catalog.shobj_description(oid, 'pg_tablespace') AS \"%s\"",
gettext_noop("Description"));
+ }
appendPQExpBuffer(&buf,
"\nFROM pg_catalog.pg_tablespace\n");
***************
*** 179,186 ****
"SELECT n.nspname as \"%s\",\n"
" p.proname as \"%s\",\n"
" CASE WHEN p.proretset THEN 'setof ' ELSE '' END ||\n"
! " pg_catalog.format_type(p.prorettype, NULL) as \"%s\",\n"
! " CASE WHEN proallargtypes IS NOT NULL THEN\n"
" pg_catalog.array_to_string(ARRAY(\n"
" SELECT\n"
" CASE\n"
--- 188,201 ----
"SELECT n.nspname as \"%s\",\n"
" p.proname as \"%s\",\n"
" CASE WHEN p.proretset THEN 'setof ' ELSE '' END ||\n"
! " pg_catalog.format_type(p.prorettype, NULL) as \"%s\"",
! gettext_noop("Schema"),
! gettext_noop("Name"),
! gettext_noop("Result data type"));
!
! if (pset.sversion >= 80100)
! appendPQExpBuffer(&buf,
! ",\n CASE WHEN proallargtypes IS NOT NULL THEN\n"
" pg_catalog.array_to_string(ARRAY(\n"
" SELECT\n"
" CASE\n"
***************
*** 208,216 ****
" pg_catalog.generate_series(0, pg_catalog.array_upper(p.proargtypes, 1)) AS s(i)\n"
" ), ', ')\n"
" END AS \"%s\"",
- gettext_noop("Schema"),
- gettext_noop("Name"),
- gettext_noop("Result data type"),
gettext_noop("Argument data types"));
if (verbose)
--- 223,228 ----
***************
*** 220,226 ****
" WHEN p.provolatile = 's' THEN 'stable'\n"
" WHEN p.provolatile = 'v' THEN 'volatile'\n"
"END as \"%s\""
! ",\n r.rolname as \"%s\",\n"
" l.lanname as \"%s\",\n"
" p.prosrc as \"%s\",\n"
" pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"",
--- 232,238 ----
" WHEN p.provolatile = 's' THEN 'stable'\n"
" WHEN p.provolatile = 'v' THEN 'volatile'\n"
"END as \"%s\""
! ",\n pg_catalog.pg_get_userbyid(proowner) as \"%s\",\n"
" l.lanname as \"%s\",\n"
" p.prosrc as \"%s\",\n"
" pg_catalog.obj_description(p.oid, 'pg_proc') as \"%s\"",
***************
*** 238,245 ****
appendPQExpBuffer(&buf,
"\nFROM pg_catalog.pg_proc p"
"\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace"
! "\n LEFT JOIN pg_catalog.pg_language l ON l.oid = p.prolang"
! "\n JOIN pg_catalog.pg_roles r ON r.oid = p.proowner\n");
/*
* we skip in/out funcs by excluding functions that take or return cstring
--- 250,256 ----
appendPQExpBuffer(&buf,
"\nFROM pg_catalog.pg_proc p"
"\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace"
! "\n LEFT JOIN pg_catalog.pg_language l ON l.oid = p.prolang\n");
/*
* we skip in/out funcs by excluding functions that take or return cstring
***************
*** 254,260 ****
"n.nspname", "p.proname", NULL,
"pg_catalog.pg_function_is_visible(p.oid)");
! appendPQExpBuffer(&buf, "ORDER BY 1, 2, 3, 4;");
res = PSQLexec(buf.data, false);
termPQExpBuffer(&buf);
--- 265,273 ----
"n.nspname", "p.proname", NULL,
"pg_catalog.pg_function_is_visible(p.oid)");
! appendPQExpBuffer(&buf, "ORDER BY 1, 2, 3");
! if (pset.sversion >= 80100)
! appendPQExpBuffer(&buf, ", 4;");
res = PSQLexec(buf.data, false);
termPQExpBuffer(&buf);
***************
*** 292,298 ****
gettext_noop("Schema"),
gettext_noop("Name"));
if (verbose)
! appendPQExpBuffer(&buf,
" t.typname AS \"%s\",\n"
" CASE WHEN t.typrelid != 0\n"
" THEN CAST('tuple' AS pg_catalog.text)\n"
--- 305,327 ----
gettext_noop("Schema"),
gettext_noop("Name"));
if (verbose)
! {
! if (pset.sversion < 80300)
! {
! appendPQExpBuffer(&buf,
! " t.typname AS \"%s\",\n"
! " CASE WHEN t.typrelid != 0\n"
! " THEN CAST('tuple' AS pg_catalog.text)\n"
! " WHEN t.typlen < 0\n"
! " THEN CAST('var' AS pg_catalog.text)\n"
! " ELSE CAST(t.typlen AS pg_catalog.text)\n"
! " END AS \"%s\",\n",
! gettext_noop("Internal name"),
! gettext_noop("Size"));
! }
! else
! {
! appendPQExpBuffer(&buf,
" t.typname AS \"%s\",\n"
" CASE WHEN t.typrelid != 0\n"
" THEN CAST('tuple' AS pg_catalog.text)\n"
***************
*** 312,317 ****
--- 341,348 ----
gettext_noop("Internal name"),
gettext_noop("Size"),
gettext_noop("Elements"));
+ }
+ }
appendPQExpBuffer(&buf,
" pg_catalog.obj_description(t.oid, 'pg_type') as \"%s\"\n",
***************
*** 419,425 ****
printfPQExpBuffer(&buf,
"SELECT d.datname as \"%s\",\n"
! " r.rolname as \"%s\",\n"
" pg_catalog.pg_encoding_to_char(d.encoding) as \"%s\",\n"
" d.datacl as \"%s\"",
gettext_noop("Name"),
--- 450,456 ----
printfPQExpBuffer(&buf,
"SELECT d.datname as \"%s\",\n"
! " pg_catalog.pg_get_userbyid(d.datdba) as \"%s\",\n"
" pg_catalog.pg_encoding_to_char(d.encoding) as \"%s\",\n"
" d.datacl as \"%s\"",
gettext_noop("Name"),
***************
*** 428,450 ****
gettext_noop("Access Privileges"));
if (verbose)
{
! appendPQExpBuffer(&buf,
",\n CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')\n"
" THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))\n"
" ELSE 'No Access'\n"
" END as \"%s\"",
gettext_noop("Size"));
! appendPQExpBuffer(&buf,
",\n t.spcname as \"%s\"",
gettext_noop("Tablespace"));
! appendPQExpBuffer(&buf,
",\n pg_catalog.shobj_description(d.oid, 'pg_database') as \"%s\"",
gettext_noop("Description"));
}
appendPQExpBuffer(&buf,
! "\nFROM pg_catalog.pg_database d"
! "\n JOIN pg_catalog.pg_roles r ON d.datdba = r.oid\n");
! if (verbose)
appendPQExpBuffer(&buf,
" JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid\n");
appendPQExpBuffer(&buf, "ORDER BY 1;");
--- 459,483 ----
gettext_noop("Access Privileges"));
if (verbose)
{
! if (pset.sversion >= 80200)
! appendPQExpBuffer(&buf,
",\n CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT')\n"
" THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))\n"
" ELSE 'No Access'\n"
" END as \"%s\"",
gettext_noop("Size"));
! if (pset.sversion >= 80100)
! appendPQExpBuffer(&buf,
",\n t.spcname as \"%s\"",
gettext_noop("Tablespace"));
! if (pset.sversion >= 80200)
! appendPQExpBuffer(&buf,
",\n pg_catalog.shobj_description(d.oid, 'pg_database') as \"%s\"",
gettext_noop("Description"));
}
appendPQExpBuffer(&buf,
! "\nFROM pg_catalog.pg_database d\n");
! if (verbose && pset.sversion >= 80100)
appendPQExpBuffer(&buf,
" JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid\n");
appendPQExpBuffer(&buf, "ORDER BY 1;");
***************
*** 484,499 ****
printfPQExpBuffer(&buf,
"SELECT n.nspname as \"%s\",\n"
" c.relname as \"%s\",\n"
! " CASE c.relkind WHEN 'r' THEN '%s' WHEN 'v' THEN '%s' WHEN 'S' THEN '%s' END as \"%s\",\n"
! " pg_catalog.array_to_string(c.relacl, E'\\n') as \"%s\"\n"
! "FROM pg_catalog.pg_class c\n"
! " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n"
! "WHERE c.relkind IN ('r', 'v', 'S')\n",
gettext_noop("Schema"),
gettext_noop("Name"),
gettext_noop("table"), gettext_noop("view"), gettext_noop("sequence"),
! gettext_noop("Type"),
gettext_noop("Access privileges"));
/*
* Unless a schema pattern is specified, we suppress system and temp
--- 517,538 ----
printfPQExpBuffer(&buf,
"SELECT n.nspname as \"%s\",\n"
" c.relname as \"%s\",\n"
! " CASE c.relkind WHEN 'r' THEN '%s' WHEN 'v' THEN '%s' WHEN 'S' THEN '%s' END as \"%s\",\n",
gettext_noop("Schema"),
gettext_noop("Name"),
gettext_noop("table"), gettext_noop("view"), gettext_noop("sequence"),
! gettext_noop("Type"));
!
! if (pset.sversion >= 80100)
! appendPQExpBuffer(&buf, " pg_catalog.array_to_string(c.relacl, E'\\n') as \"%s\"\n",
! gettext_noop("Access privileges"));
! else
! appendPQExpBuffer(&buf, " pg_catalog.array_to_string(c.relacl, '\n') as \"%s\"\n",
gettext_noop("Access privileges"));
+
+ appendPQExpBuffer(&buf, "FROM pg_catalog.pg_class c\n"
+ " LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n"
+ "WHERE c.relkind IN ('r', 'v', 'S')\n");
/*
* Unless a schema pattern is specified, we suppress system and temp
***************
*** 1572,1578 ****
initPQExpBuffer(&buf);
! appendPQExpBufferStr(&buf,
"SELECT r.rolname, r.rolsuper, r.rolinherit,\n"
" r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,\n"
" r.rolconnlimit,\n"
--- 1611,1630 ----
initPQExpBuffer(&buf);
! if (pset.sversion < 80100)
! {
! appendPQExpBufferStr(&buf,
! "SELECT u.usename AS rolname,\n"
! " u.usesuper AS rolsuper,\n"
! " FALSE AS rolinherit, FALSE AS rolcreaterole,\n"
! " usecreatedb AS rolcreatedb, TRUE AS rolcanlogin,\n"
! " -1 AS rolconnlimit,\n"
! " ARRAY(SELECT g.groname FROM pg_catalog.pg_group g WHERE u.usesysid = ANY(g.grolist)) as memberof\n"
! "FROM pg_catalog.pg_user u\n");
! }
! else
! {
! appendPQExpBufferStr(&buf,
"SELECT r.rolname, r.rolsuper, r.rolinherit,\n"
" r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,\n"
" r.rolconnlimit,\n"
***************
*** 1581,1593 ****
" JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)\n"
" WHERE m.member = r.oid) as memberof");
! if (verbose)
! {
! appendPQExpBufferStr(&buf, "\n, pg_catalog.shobj_description(r.oid, 'pg_authid') AS description");
! ncols++;
! }
! appendPQExpBuffer(&buf, "\nFROM pg_catalog.pg_roles r\n");
processSQLNamePattern(pset.db, &buf, pattern, false, false,
NULL, "r.rolname", NULL, NULL);
--- 1633,1646 ----
" JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)\n"
" WHERE m.member = r.oid) as memberof");
! if (pset.sversion >= 80200 && verbose)
! {
! appendPQExpBufferStr(&buf, "\n, pg_catalog.shobj_description(r.oid, 'pg_authid') AS description");
! ncols++;
! }
! appendPQExpBuffer(&buf, "\nFROM pg_catalog.pg_roles r\n");
! }
processSQLNamePattern(pset.db, &buf, pattern, false, false,
NULL, "r.rolname", NULL, NULL);
***************
*** 1607,1613 ****
printTableAddHeader(&cont, gettext_noop("Attributes"), true, align);
printTableAddHeader(&cont, gettext_noop("Member of"), true, align);
! if (verbose)
printTableAddHeader(&cont, gettext_noop("Description"), true, align);
for (i = 0; i < nrows; i++)
--- 1660,1666 ----
printTableAddHeader(&cont, gettext_noop("Attributes"), true, align);
printTableAddHeader(&cont, gettext_noop("Member of"), true, align);
! if (pset.sversion >= 80200 && verbose)
printTableAddHeader(&cont, gettext_noop("Description"), true, align);
for (i = 0; i < nrows; i++)
***************
*** 1650,1656 ****
printTableAddCell(&cont, PQgetvalue(res, i, 7), false);
! if (verbose)
printTableAddCell(&cont, PQgetvalue(res, i, 8), false);
}
termPQExpBuffer(&buf);
--- 1703,1709 ----
printTableAddCell(&cont, PQgetvalue(res, i, 7), false);
! if (pset.sversion >= 80200 && verbose)
printTableAddCell(&cont, PQgetvalue(res, i, 8), false);
}
termPQExpBuffer(&buf);
***************
*** 1716,1722 ****
"SELECT n.nspname as \"%s\",\n"
" c.relname as \"%s\",\n"
" CASE c.relkind WHEN 'r' THEN '%s' WHEN 'v' THEN '%s' WHEN 'i' THEN '%s' WHEN 'S' THEN '%s' WHEN 's' THEN '%s' END as \"%s\",\n"
! " r.rolname as \"%s\"",
gettext_noop("Schema"),
gettext_noop("Name"),
gettext_noop("table"), gettext_noop("view"), gettext_noop("index"), gettext_noop("sequence"), gettext_noop("special"),
--- 1769,1775 ----
"SELECT n.nspname as \"%s\",\n"
" c.relname as \"%s\",\n"
" CASE c.relkind WHEN 'r' THEN '%s' WHEN 'v' THEN '%s' WHEN 'i' THEN '%s' WHEN 'S' THEN '%s' WHEN 's' THEN '%s' END as \"%s\",\n"
! " pg_catalog.pg_get_userbyid(c.relowner) as \"%s\"",
gettext_noop("Schema"),
gettext_noop("Name"),
gettext_noop("table"), gettext_noop("view"), gettext_noop("index"), gettext_noop("sequence"), gettext_noop("special"),
***************
*** 1730,1738 ****
if (verbose)
{
! appendPQExpBuffer(&buf,
",\n pg_catalog.pg_size_pretty(pg_catalog.pg_relation_size(c.oid)) as \"%s\"",
gettext_noop("Size"));
appendPQExpBuffer(&buf,
",\n pg_catalog.obj_description(c.oid, 'pg_class') as \"%s\"",
gettext_noop("Description"));
--- 1783,1794 ----
if (verbose)
{
! if (pset.sversion >= 80100)
! {
! appendPQExpBuffer(&buf,
",\n pg_catalog.pg_size_pretty(pg_catalog.pg_relation_size(c.oid)) as \"%s\"",
gettext_noop("Size"));
+ }
appendPQExpBuffer(&buf,
",\n pg_catalog.obj_description(c.oid, 'pg_class') as \"%s\"",
gettext_noop("Description"));
***************
*** 1740,1746 ****
appendPQExpBuffer(&buf,
"\nFROM pg_catalog.pg_class c"
- "\n JOIN pg_catalog.pg_roles r ON r.oid = c.relowner"
"\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace");
if (showIndexes)
appendPQExpBuffer(&buf,
--- 1796,1801 ----
***************
*** 1985,1991 ****
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,
"SELECT n.nspname AS \"%s\",\n"
! " r.rolname AS \"%s\"",
gettext_noop("Name"),
gettext_noop("Owner"));
--- 2040,2046 ----
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,
"SELECT n.nspname AS \"%s\",\n"
! " pg_catalog.pg_get_userbyid(nspowner) AS \"%s\"",
gettext_noop("Name"),
gettext_noop("Owner"));
***************
*** 1997,2004 ****
gettext_noop("Description"));
appendPQExpBuffer(&buf,
! "\nFROM pg_catalog.pg_namespace n JOIN pg_catalog.pg_roles r\n"
! " ON n.nspowner=r.oid\n"
"WHERE (n.nspname !~ '^pg_temp_' OR\n"
" n.nspname = (pg_catalog.current_schemas(true))[1])\n"); /* temp schema is first */
--- 2052,2058 ----
gettext_noop("Description"));
appendPQExpBuffer(&buf,
! "\nFROM pg_catalog.pg_namespace n\n"
"WHERE (n.nspname !~ '^pg_temp_' OR\n"
" n.nspname = (pg_catalog.current_schemas(true))[1])\n"); /* temp schema is first */
***************
*** 2035,2040 ****
--- 2089,2101 ----
PGresult *res;
printQueryOpt myopt = pset.popt;
+ if (pset.sversion < 80300)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text parsers.\n"),
+ pset.sversion);
+ return true;
+ }
+
if (verbose)
return listTSParsersVerbose(pattern);
***************
*** 2083,2088 ****
--- 2144,2156 ----
PGresult *res;
int i;
+ if (pset.sversion < 80300)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text parser.\n"),
+ pset.sversion);
+ return true;
+ }
+
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,
***************
*** 2150,2155 ****
--- 2218,2230 ----
printQueryOpt myopt = pset.popt;
static const bool trans_columns[] = {true, false, false};
+ if (pset.sversion < 80000)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text parser.\n"),
+ pset.sversion);
+ return true;
+ }
+
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,
***************
*** 2261,2266 ****
--- 2336,2348 ----
PGresult *res;
printQueryOpt myopt = pset.popt;
+ if (pset.sversion < 80300)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text dictionary.\n"),
+ pset.sversion);
+ return true;
+ }
+
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,
***************
*** 2322,2327 ****
--- 2404,2416 ----
PGresult *res;
printQueryOpt myopt = pset.popt;
+ if (pset.sversion < 80300)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text template.\n"),
+ pset.sversion);
+ return true;
+ }
+
initPQExpBuffer(&buf);
if (verbose)
***************
*** 2383,2388 ****
--- 2472,2484 ----
PGresult *res;
printQueryOpt myopt = pset.popt;
+ if (pset.sversion < 80300)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text config.\n"),
+ pset.sversion);
+ return true;
+ }
+
if (verbose)
return listTSConfigsVerbose(pattern);
***************
*** 2428,2433 ****
--- 2524,2536 ----
PGresult *res;
int i;
+ if (pset.sversion < 80300)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text config.\n"),
+ pset.sversion);
+ return true;
+ }
+
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,
***************
*** 2504,2509 ****
--- 2607,2619 ----
PGresult *res;
printQueryOpt myopt = pset.popt;
+ if (pset.sversion < 80300)
+ {
+ fprintf(stderr, _("The server version (%d) does not support full text config.\n"),
+ pset.sversion);
+ return true;
+ }
+
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,