Hi Alex, There is an known issue if you init the system between commit 787c096 and commit 1866a93(Nov 22-Nov25 2016). Could you please check the proargtypes of function gp_relfile_insert_for_register in pg_proc by the following steps:
- select oid,* from pg_proc where proname ='gp_relfile_insert_for_register'; - \c template1 - select oid,* from pg_proc where proname ='gp_relfile_insert_for_register'; On Mon, Feb 13, 2017 at 10:57 AM, Lili Ma <[email protected]> wrote: > Hi Alex, > > Could you tell the original version and to-be-upgraded version of HAWQ, so > that we can try to reproduce it? > > Thanks > Lili > > On Sat, Feb 11, 2017 at 10:27 AM, Alex (Oleksandr) Diachenko < > [email protected]> wrote: > > > Hi, > > > > I saw HAWQ-1171 was merged to master recently, and I am trying to figure > > out how it works. > > The scripts drops gp_relfile_insert_for_register procedure if it exists > and > > creates it again using latest signature. > > > > I tried it out and it worked for me in a case when > > gp_relfile_insert_for_register doesn't exist. > > But in case when gp_relfile_insert_for_register exist I am getting: > > > > *ERROR: cannot drop function > > gp_relfile_insert_for_register(oid,oid,oid,oid,oid, > > cstring,character,character,oid) > > because it is required by the database system* > > > > Is it even intended to be run when procedure exists? Do I have to set any > > GUCs to make it work? > > > > Regards, Alex. > > > -- Thanks Hubert Zhang
