#2366 upgrade-sql: fix backward compatibility
Merged 3 years ago by mikem. Opened 3 years ago by julian8628.
julian8628/koji upgrade-sql-fix  into  master

@@ -23,7 +23,8 @@ 

  ALTER TABLE build_reservations ALTER COLUMN created TYPE TIMESTAMPTZ USING

      timezone(current_setting('TIMEZONE'), created::timestamptz);

  

- DROP FUNCTION IF EXISTS get_event_time;

+ -- input type has to be specified on PostgreSQL 9.x

+ DROP FUNCTION IF EXISTS get_event_time(INTEGER);

  CREATE FUNCTION get_event_time(INTEGER) RETURNS TIMESTAMPTZ AS '

  	SELECT time FROM events WHERE id=$1;

  ' LANGUAGE SQL;

input type has to be specified on PostgreSQL 9.x

fixes: #2367

Metadata Update from @julian8628:
- Pull-request tagged with: testing-ready

3 years ago

Metadata Update from @jcupova:
- Pull-request tagged with: testing-done

3 years ago

pretty please pagure-ci rebuild

3 years ago

Commit 6b8f255 fixes this pull-request

Pull-Request has been merged by mikem

3 years ago