Re: got some errors after upgrade poestgresql from 9.5 to 9.6

Hi

  I am got a problem after upgrade poestgresql from 9.5 to 9.6 .it's occurred when calling an exits function .

putong-contacts=# select insert_user_mobile_contact_hashes(4009, '', ARRAY['7bd94067bb0597bf995c4eb46364a4ce'], ARRAY['c55288a186d0e6f0e3fb3b66deb65366'], ARRAY[''], false);
ERROR:  table row type and query-specified row type do not match
DETAIL:  Query provides a value for a dropped column at ordinal position 6.
CONTEXT:  SQL statement "UPDATE c
                        SET
                              phone_number = phone_number_arr_[i],
                              name = name_
                        WHERE
                              user_id = user_id_
                        AND
                              md5_hash11 = md5_hash11_arr_[i]
                        AND
                              coalesce(phone_number,'') = ''
                        AND
                              char_length(phone_number_arr_[i]) > 0"
PL/pgSQL function insert_user_mobile_contact_hashes(integer,character varying,character varying[],character varying[],character varying[],boolean) line 36 at SQL statement


and here is the column in this table be dropped

putong-contacts=# select *  from pg_attribute where attrelid = 'user_mobile_contact_hashes'::regclass and attisdropped;
 attrelid |            attname            | atttypid | attstattarget | attlen | attnum | attndims | attcacheoff | atttypmod | attbyval | attstorage | attalign | attnotnull | atthasdef | attisdropped | attislocal | attinhcount | attcollation | attacl | attoptions | attfdwoptions
----------+-------------------------------+----------+---------------+--------+--------+----------+-------------+-----------+----------+------------+----------+------------+-----------+--------------+------------+-------------+--------------+--------+------------+---------------
  6097850 | ........pg.dropped.6........  |        0 |             0 |      8 |      6 |        0 |          -1 |        -1 | f        | p          | d        | f          | f         | t            | t          |           0 |            0 |        |            |
  6097850 | ........pg.dropped.10........ |        0 |             0 |      1 |     10 |        0 |          -1 |        -1 | f        | p          | c        | f          | f         | t            | t          |           0 |            0 |        |            |




when i create this table user_mobile_contact_hashes , the function works well. i try to delete those 2 dropped column info from system catalog table , but it can't work  and got other problems.

putong-contacts=# select insert_user_mobile_contact_hashes(4009, '', ARRAY['7bd94067bb0597bf995c4eb46364a4ce'], ARRAY['c55288a186d0e6f0e3fb3b66deb65366'], ARRAY[''], false);
ERROR:  catalog is missing 2 attribute(s) for relid 6097850

Can you explain this issue and  give me some advise how to handle this . thanks a lot .


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs