Re: pldbgapi error

Hi Ian,

Thanks for replying can you please help me to solve this problem which code
will be support for postgresql 11 can you please share me the link or file.

Regards,
Prakash.R

On Mon, May 20, 2019 at 5:25 PM Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>
wrote:

> On 5/20/19 7:07 PM, Prakash Ramakrishnan wrote:> Hi Team,
> >
> > We are trying to install the pldbgapi extension in postgresql 11.3
> server but we getting below error,Please do the needful,
> >
> > ==> make USE_PGXS=1
> > gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
> -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches
> -m64 -mtune=generic -fPIC
> -I/usr/pgsql-11/lib/pgxs/src/makefiles/../../src/pl/plpgsql/src -I. -I./
> -I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal
> -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o
> plpgsql_debugger.o plpgsql_debugger.c
> > plpgsql_debugger.c: In function ‘plpgsql_send_vars’:
> > plpgsql_debugger.c:263:16: error: ‘TRUE’ undeclared (first use in this
> function)
> > isArg = TRUE;
> > ^
> > plpgsql_debugger.c:263:16: note: each undeclared identifier is reported
> only once for each function it appears in
> > plpgsql_debugger.c:244:4: warning: enumeration value
> ‘PLPGSQL_DTYPE_ROW’ not handled in switch [-Wswitch]
> > switch( estate->datums[i]->dtype )
> > ^
> > plpgsql_debugger.c:244:4: warning: enumeration value
> ‘PLPGSQL_DTYPE_REC’ not handled in switch [-Wswitch]
> > plpgsql_debugger.c:244:4: warning: enumeration value
> ‘PLPGSQL_DTYPE_RECFIELD’ not handled in switch [-Wswitch]
> > plpgsql_debugger.c:244:4: warning: enumeration value
> ‘PLPGSQL_DTYPE_ARRAYELEM’ not handled in switch [-Wswitch]
> > plpgsql_debugger.c:244:4: warning: enumeration value
> ‘PLPGSQL_DTYPE_PROMISE’ not handled in switch [-Wswitch]
> > plpgsql_debugger.c: In function ‘find_datum_by_name’:
> > plpgsql_debugger.c:484:9: error: ‘PLPGSQL_DTYPE_EXPR’ undeclared (first
> use in this function)
> > case PLPGSQL_DTYPE_EXPR:(...)
>
> It looks like you are trying to compile some extension code which has not
> been updated
> to be compatible with the PostgreSQL 11 source. Check to see if there's
> updated code available.
>
> Regards
>
> Ian Barwick
>
> --
> Ian Barwick https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>

--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426