diff options
author | kleink <kleink> | 2003-09-08 12:13:49 +0000 |
---|---|---|
committer | kleink <kleink> | 2003-09-08 12:13:49 +0000 |
commit | 941c8b1361bd9ac2cd9eb34e8af4a1f5df649559 (patch) | |
tree | 147ed57319c769e802b4486a3ae04c936af70f76 /databases/gtksql/patches | |
parent | 210006f4553854404d2d7ad62ba60b4c2c039e88 (diff) | |
download | pkgsrc-941c8b1361bd9ac2cd9eb34e8af4a1f5df649559.tar.gz |
Use proper multi-line string concatenation.
Diffstat (limited to 'databases/gtksql/patches')
-rw-r--r-- | databases/gtksql/patches/patch-ab | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/databases/gtksql/patches/patch-ab b/databases/gtksql/patches/patch-ab new file mode 100644 index 00000000000..7882cfcf61b --- /dev/null +++ b/databases/gtksql/patches/patch-ab @@ -0,0 +1,65 @@ +$NetBSD: patch-ab,v 1.1 2003/09/08 12:13:50 kleink Exp $ + +--- postgres.c.orig 1999-06-05 15:05:36.000000000 +0200 ++++ postgres.c 2003-09-08 14:11:15.000000000 +0200 +@@ -129,14 +129,14 @@ + PGresult *table_info; + char query[512]; + +- sprintf(query, "SELECT a.attnum, a.attname, t.typname, a.attlen, +- a.atttypmod, a.attnotnull, a.atthasdef +- FROM pg_class c, pg_attribute a, pg_type t +- WHERE c.relname = '%s' AND +- a.attnum > 0 AND +- a.attrelid = c.oid AND +- a.atttypid = t.oid +- ORDER BY attnum", tbf->name); ++ sprintf(query, "SELECT a.attnum, a.attname, t.typname, a.attlen,"\ ++ "a.atttypmod, a.attnotnull, a.atthasdef"\ ++ "FROM pg_class c, pg_attribute a, pg_type t"\ ++ "WHERE c.relname = '%s' AND"\ ++ "a.attnum > 0 AND"\ ++ "a.attrelid = c.oid AND"\ ++ "a.atttypid = t.oid"\ ++ "ORDER BY attnum", tbf->name); + + table_info = PQexec(conn, query); + if ((table_info == NULL) || +@@ -183,11 +183,11 @@ + if (rnotnull[0] == 't') + strcat(type_str, " not null"); + if (rhasdef[0] == 't') { +- sprintf(buf, "SELECT d.adsrc +- FROM pg_attrdef d, pg_class c +- WHERE c.relname = '%s' AND +- c.oid = d.adrelid AND +- d.adnum = %s", ++ sprintf(buf, "SELECT d.adsrc"\ ++ "FROM pg_attrdef d, pg_class c"\ ++ "WHERE c.relname = '%s' AND"\ ++ "c.oid = d.adrelid AND"\ ++ "d.adnum = %s", + tbf->name, PQgetvalue(table_info, i, 0)); + table_info2 = PQexec(conn, buf); + if ((table_info2 == NULL) || +@@ -240,13 +240,13 @@ + PGresult *tables; + char query[512]; + +- sprintf(query, "SELECT usename, relname, relkind, relhasrules +- FROM pg_class, pg_user +- WHERE relkind = 'r' AND +- relname !~ '^pg_' AND +- relname !~ '^xin[vx][0-9]+' AND +- usesysid = relowner +- ORDER BY relname"); ++ sprintf(query, "SELECT usename, relname, relkind, relhasrules"\ ++ "FROM pg_class, pg_user"\ ++ "WHERE relkind = 'r' AND"\ ++ "relname !~ '^pg_' AND"\ ++ "relname !~ '^xin[vx][0-9]+' AND"\ ++ "usesysid = relowner"\ ++ "ORDER BY relname"); + + tables = PQexec(conn->conn, query); + if ((tables == NULL) || (PQresultStatus(tables) != PGRES_TUPLES_OK)) { |