From d0a79dbf3615142f1ab313c2ea3c331bc155e6c8 Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 11 May 2010 15:28:06 +0300 Subject: [PATCH] sql/pgq: compat with 9.0 bytea format --- sql/pgq/expected/logutriga.out | 8 ++++++++ sql/pgq/sql/logutriga.sql | 5 +++++ 2 files changed, 13 insertions(+) diff --git a/sql/pgq/expected/logutriga.out b/sql/pgq/expected/logutriga.out index bab7c477..18b81aac 100644 --- a/sql/pgq/expected/logutriga.out +++ b/sql/pgq/expected/logutriga.out @@ -1,3 +1,11 @@ +select 1 from (select set_config(name, 'escape', false) as ignore + from pg_settings where name = 'bytea_output') x + where x.ignore = 'foo'; + ?column? +---------- +(0 rows) + +drop function pgq.insert_event(text, text, text, text, text, text, text); create or replace function pgq.insert_event(que text, ev_type text, ev_data text, x1 text, x2 text, x3 text, x4 text) returns bigint as $$ begin diff --git a/sql/pgq/sql/logutriga.sql b/sql/pgq/sql/logutriga.sql index 3dd335df..11b24427 100644 --- a/sql/pgq/sql/logutriga.sql +++ b/sql/pgq/sql/logutriga.sql @@ -1,4 +1,9 @@ +select 1 from (select set_config(name, 'escape', false) as ignore + from pg_settings where name = 'bytea_output') x + where x.ignore = 'foo'; + +drop function pgq.insert_event(text, text, text, text, text, text, text); create or replace function pgq.insert_event(que text, ev_type text, ev_data text, x1 text, x2 text, x3 text, x4 text) returns bigint as $$ begin -- 2.39.5