summaryrefslogtreecommitdiff
path: root/databases/gtksql
diff options
context:
space:
mode:
Diffstat (limited to 'databases/gtksql')
-rw-r--r--databases/gtksql/distinfo3
-rw-r--r--databases/gtksql/patches/patch-ab65
2 files changed, 67 insertions, 1 deletions
diff --git a/databases/gtksql/distinfo b/databases/gtksql/distinfo
index 6e9f25d86ac..be56fd916fd 100644
--- a/databases/gtksql/distinfo
+++ b/databases/gtksql/distinfo
@@ -1,5 +1,6 @@
-$NetBSD: distinfo,v 1.7 2002/09/21 08:10:56 jlam Exp $
+$NetBSD: distinfo,v 1.8 2003/09/08 12:13:49 kleink Exp $
SHA1 (gtksql-0.3.tar.gz) = b2d078cb0eb8816b26f3e0369fc440085071fc0c
Size (gtksql-0.3.tar.gz) = 50557 bytes
SHA1 (patch-aa) = 6ec9ce239bcf5516e47aca39942168b16549f0a1
+SHA1 (patch-ab) = 0d194dd153e3d3ce34b0f0d805ae0d83408de33b
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)) {