Re: pgsql: Remove deprecated abstime, reltime, tinterval datatypes.

On 10/11/2018 03:02 PM, Andres Freund wrote:
> Remove deprecated abstime, reltime, tinterval datatypes.
>
> These types have been deprecated for a *long* time.


This has broken pg_upgrade from previous versions:

    pg_restore: [archiver (db)] Error while PROCESSING TOC:
    pg_restore: [archiver (db)] Error from TOC entry 212; 1259 16891
    TABLE abstime_tbl buildfarm
    pg_restore: [archiver (db)] could not execute query: ERROR:  type
    "abstime" does not exist
    LINE 14:     "f1" "abstime"
                       ^
         Command was:
    -- For binary upgrade, must preserve pg_type oid
    SELECT
    pg_catalog.binary_upgrade_set_next_pg_type_oid('16893'::pg_catalog.oid);


    -- For binary upgrade, must preserve pg_type array oid
    SELECT
    pg_catalog.binary_upgrade_set_next_array_pg_type_oid('16892'::pg_catalog.oid);


    -- For binary upgrade, must preserve pg_class oids
    SELECT
    pg_catalog.binary_upgrade_set_next_heap_pg_class_oid('16891'::pg_catalog.oid);

    CREATE TABLE "public"."abstime_tbl" (
         "f1" "abstime"
    );

    -- For binary upgrade, set heap's relfrozenxid and relminmxid
    UPDATE pg_catalog.pg_class
    SET relfrozenxid = '2643', relminmxid = '1'
    WHERE oid = '"public"."abstime_tbl"'::pg_catalog.regclass;




cheers

andrew

-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services