head 1.2; access; symbols pkgsrc-2022Q1:1.1.0.152 pkgsrc-2022Q1-base:1.1 pkgsrc-2021Q4:1.1.0.150 pkgsrc-2021Q4-base:1.1 pkgsrc-2021Q3:1.1.0.148 pkgsrc-2021Q3-base:1.1 pkgsrc-2021Q2:1.1.0.146 pkgsrc-2021Q2-base:1.1 pkgsrc-2021Q1:1.1.0.144 pkgsrc-2021Q1-base:1.1 pkgsrc-2020Q4:1.1.0.142 pkgsrc-2020Q4-base:1.1 pkgsrc-2020Q3:1.1.0.140 pkgsrc-2020Q3-base:1.1 pkgsrc-2020Q2:1.1.0.136 pkgsrc-2020Q2-base:1.1 pkgsrc-2020Q1:1.1.0.116 pkgsrc-2020Q1-base:1.1 pkgsrc-2019Q4:1.1.0.138 pkgsrc-2019Q4-base:1.1 pkgsrc-2019Q3:1.1.0.134 pkgsrc-2019Q3-base:1.1 pkgsrc-2019Q2:1.1.0.132 pkgsrc-2019Q2-base:1.1 pkgsrc-2019Q1:1.1.0.130 pkgsrc-2019Q1-base:1.1 pkgsrc-2018Q4:1.1.0.128 pkgsrc-2018Q4-base:1.1 pkgsrc-2018Q3:1.1.0.126 pkgsrc-2018Q3-base:1.1 pkgsrc-2018Q2:1.1.0.124 pkgsrc-2018Q2-base:1.1 pkgsrc-2018Q1:1.1.0.122 pkgsrc-2018Q1-base:1.1 pkgsrc-2017Q4:1.1.0.120 pkgsrc-2017Q4-base:1.1 pkgsrc-2017Q3:1.1.0.118 pkgsrc-2017Q3-base:1.1 pkgsrc-2017Q2:1.1.0.114 pkgsrc-2017Q2-base:1.1 pkgsrc-2017Q1:1.1.0.112 pkgsrc-2017Q1-base:1.1 pkgsrc-2016Q4:1.1.0.110 pkgsrc-2016Q4-base:1.1 pkgsrc-2016Q3:1.1.0.108 pkgsrc-2016Q3-base:1.1 pkgsrc-2016Q2:1.1.0.106 pkgsrc-2016Q2-base:1.1 pkgsrc-2016Q1:1.1.0.104 pkgsrc-2016Q1-base:1.1 pkgsrc-2015Q4:1.1.0.102 pkgsrc-2015Q4-base:1.1 pkgsrc-2015Q3:1.1.0.100 pkgsrc-2015Q3-base:1.1 pkgsrc-2015Q2:1.1.0.98 pkgsrc-2015Q2-base:1.1 pkgsrc-2015Q1:1.1.0.96 pkgsrc-2015Q1-base:1.1 pkgsrc-2014Q4:1.1.0.94 pkgsrc-2014Q4-base:1.1 pkgsrc-2014Q3:1.1.0.92 pkgsrc-2014Q3-base:1.1 pkgsrc-2014Q2:1.1.0.90 pkgsrc-2014Q2-base:1.1 pkgsrc-2014Q1:1.1.0.88 pkgsrc-2014Q1-base:1.1 pkgsrc-2013Q4:1.1.0.86 pkgsrc-2013Q4-base:1.1 pkgsrc-2013Q3:1.1.0.84 pkgsrc-2013Q3-base:1.1 pkgsrc-2013Q2:1.1.0.82 pkgsrc-2013Q2-base:1.1 pkgsrc-2013Q1:1.1.0.80 pkgsrc-2013Q1-base:1.1 pkgsrc-2012Q4:1.1.0.78 pkgsrc-2012Q4-base:1.1 pkgsrc-2012Q3:1.1.0.76 pkgsrc-2012Q3-base:1.1 pkgsrc-2012Q2:1.1.0.74 pkgsrc-2012Q2-base:1.1 pkgsrc-2012Q1:1.1.0.72 pkgsrc-2012Q1-base:1.1 pkgsrc-2011Q4:1.1.0.70 pkgsrc-2011Q4-base:1.1 pkgsrc-2011Q3:1.1.0.68 pkgsrc-2011Q3-base:1.1 pkgsrc-2011Q2:1.1.0.66 pkgsrc-2011Q2-base:1.1 pkgsrc-2011Q1:1.1.0.64 pkgsrc-2011Q1-base:1.1 pkgsrc-2010Q4:1.1.0.62 pkgsrc-2010Q4-base:1.1 pkgsrc-2010Q3:1.1.0.60 pkgsrc-2010Q3-base:1.1 pkgsrc-2010Q2:1.1.0.58 pkgsrc-2010Q2-base:1.1 pkgsrc-2010Q1:1.1.0.56 pkgsrc-2010Q1-base:1.1 pkgsrc-2009Q4:1.1.0.54 pkgsrc-2009Q4-base:1.1 pkgsrc-2009Q3:1.1.0.52 pkgsrc-2009Q3-base:1.1 pkgsrc-2009Q2:1.1.0.50 pkgsrc-2009Q2-base:1.1 pkgsrc-2009Q1:1.1.0.48 pkgsrc-2009Q1-base:1.1 pkgsrc-2008Q4:1.1.0.46 pkgsrc-2008Q4-base:1.1 pkgsrc-2008Q3:1.1.0.44 pkgsrc-2008Q3-base:1.1 cube-native-xorg:1.1.0.42 cube-native-xorg-base:1.1 pkgsrc-2008Q2:1.1.0.40 pkgsrc-2008Q2-base:1.1 cwrapper:1.1.0.38 pkgsrc-2008Q1:1.1.0.36 pkgsrc-2008Q1-base:1.1 pkgsrc-2007Q4:1.1.0.34 pkgsrc-2007Q4-base:1.1 pkgsrc-2007Q3:1.1.0.32 pkgsrc-2007Q3-base:1.1 pkgsrc-2007Q2:1.1.0.30 pkgsrc-2007Q2-base:1.1 pkgsrc-2007Q1:1.1.0.28 pkgsrc-2007Q1-base:1.1 pkgsrc-2006Q4:1.1.0.26 pkgsrc-2006Q4-base:1.1 pkgsrc-2006Q3:1.1.0.24 pkgsrc-2006Q3-base:1.1 pkgsrc-2006Q2:1.1.0.22 pkgsrc-2006Q2-base:1.1 pkgsrc-2006Q1:1.1.0.20 pkgsrc-2006Q1-base:1.1 pkgsrc-2005Q4:1.1.0.18 pkgsrc-2005Q4-base:1.1 pkgsrc-2005Q3:1.1.0.16 pkgsrc-2005Q3-base:1.1 pkgsrc-2005Q2:1.1.0.14 pkgsrc-2005Q2-base:1.1 pkgsrc-2005Q1:1.1.0.12 pkgsrc-2005Q1-base:1.1 pkgsrc-2004Q4:1.1.0.10 pkgsrc-2004Q4-base:1.1 pkgsrc-2004Q3:1.1.0.8 pkgsrc-2004Q3-base:1.1 pkgsrc-2004Q2:1.1.0.6 pkgsrc-2004Q2-base:1.1 pkgsrc-2004Q1:1.1.0.4 pkgsrc-2004Q1-base:1.1 pkgsrc-2003Q4:1.1.0.2 pkgsrc-2003Q4-base:1.1; locks; strict; comment @# @; 1.2 date 2022.04.25.07.55.19; author wiz; state dead; branches; next 1.1; commitid 8dy8N1ZtL32IsyBD; 1.1 date 2003.09.08.12.13.50; author kleink; state Exp; branches; next ; desc @@ 1.2 log @gtksql: remove Doesn't build, uses gtk1, pkgsrc version from 2000, last release from 2007 @ text @$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)) { @ 1.1 log @Use proper multi-line string concatenation. @ text @d1 1 a1 1 $NetBSD$ @