Fixed query for PG 8.4

dvarrazzo · dvarrazzo · commit db40e71abc10 · 2013-04-17T22:08:24.000+01:00
Posgtres cannot find a cast rule.
diff --git a/bin/pg_repack.c b/bin/pg_repack.c
@@ -93,7 +93,7 @@ const char *PROGRAM_VERSION = "unknown";
 	"SELECT repack.array_accum(virtualtransaction) FROM pg_locks" \
 	" WHERE locktype = 'virtualxid' AND pid NOT IN (pg_backend_pid(), $1)" \
 	" AND (virtualxid, virtualtransaction) <> ('1/1', '-1/0') " \
-	" AND ($2 IS NOT NULL)"
+	" AND ($2::text IS NOT NULL)"
 
 #define SQL_XID_SNAPSHOT \
 	(PQserverVersion(connection) >= 90200 ? SQL_XID_SNAPSHOT_90200 : \
