Hi Lili and Hubert,

I was testing my changes to upgrade HAWQ from HDB 2.0.0.0 to
HDB-2.2.0.0(current master), with my changes in the scope of HAWQ-1314.
It went through, so no worries.

Regards, Alex.

On Sun, Feb 12, 2017 at 7:35 PM, Hubert Zhang <[email protected]> wrote:

> 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
>

Reply via email to