summaryrefslogtreecommitdiff
path: root/contrib/oid2name
diff options
context:
space:
mode:
authorBruce Momjian2002-10-18 18:41:22 +0000
committerBruce Momjian2002-10-18 18:41:22 +0000
commitaa4c702eac936964649f905741b4a99f4b489200 (patch)
tree517d3c28aa3d28eb95b19c8676c940b5cefe2031 /contrib/oid2name
parentfb9bc342fffc157d6ca4b635aeeaccb3c1370b91 (diff)
Update /contrib for "autocommit TO 'on'".
Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
Diffstat (limited to 'contrib/oid2name')
-rw-r--r--contrib/oid2name/oid2name.c4
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/oid2name/oid2name.c b/contrib/oid2name/oid2name.c
index 8613800056b..155d54e7073 100644
--- a/contrib/oid2name/oid2name.c
+++ b/contrib/oid2name/oid2name.c
@@ -245,6 +245,10 @@ sql_conn(const char *dbName, struct options * my_opts)
if (pgpass != NULL)
free(pgpass);
+ sql_exec(conn, "SET search_path = public;", 0);
+
+ sql_exec(conn, "SET autocommit TO 'on';", 0);
+
/* return the conn if good */
return conn;
}