Postgres Pro
Downloads
Home   >   mailing lists

Thread: pldbgapi error

pldbgapi error

From
Prakash Ramakrishnan
Date:
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:
         ^
plpgsql_debugger.c:462:3: warning: enumeration value ‘PLPGSQL_DTYPE_PROMISE’ not handled in switch [-Wswitch]
   switch( frame->datums[i]->dtype )
   ^
plpgsql_debugger.c: In function ‘print_rec’:
plpgsql_debugger.c:575:9: error: ‘PLpgSQL_rec’ has no member named ‘tupdesc’
  if (tgt->tupdesc == NULL)
         ^
plpgsql_debugger.c:578:29: error: ‘PLpgSQL_rec’ has no member named ‘tupdesc’
  for( attNo = 0; attNo < tgt->tupdesc->natts; ++attNo )
                             ^
plpgsql_debugger.c:580:36: error: ‘PLpgSQL_rec’ has no member named ‘tup’
   char * extval = SPI_getvalue( tgt->tup, tgt->tupdesc, attNo + 1 );
                                    ^
plpgsql_debugger.c:580:46: error: ‘PLpgSQL_rec’ has no member named ‘tupdesc’
   char * extval = SPI_getvalue( tgt->tup, tgt->tupdesc, attNo + 1 );
                                              ^
In file included from /usr/pgsql-11/include/server/postgres.h:46:0,
                 from plpgsql_debugger.c:12:
plpgsql_debugger.c:582:51: error: ‘PLpgSQL_rec’ has no member named ‘tupdesc’
   dbg_send( "v:%s.%s:%s\n", var_name, NameStr( tgt->tupdesc->attrs[attNo]->attname ), extval ? extval : "NULL" );
                                                   ^
/usr/pgsql-11/include/server/c.h:576:25: note: in definition of macro ‘NameStr’
 #define NameStr(name) ((name).data)


--
Thanks,
Prakash.R

Re: pldbgapi error

From
Ian Barwick
Date:
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

Re: pldbgapi error

From
Prakash Ramakrishnan
Date:
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.barwick@2ndquadrant.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

Re: pldbgapi error

From
Ian Barwick
Date:
On 5/20/19 8:57 PM, Prakash Ramakrishnan wrote:

> 
> On Mon, May 20, 2019 at 5:25 PM Ian Barwick <ian.barwick@2ndquadrant.com <mailto:ian.barwick@2ndquadrant.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
dothe 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
appearsin
 
>       > 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.
 >
> Hi Ian,
> 
> Thanks for replying can you please help me to solve this problem which code will be support for postgresql 11 can you
pleaseshare me the link or file.
 

This is a simple two-step process:

1) locate the source code repository for "pldbgapi" - I don't know what this is, and
    a quick web search doesn't reveal any obvious repositories (but presumably you
    obtained the source from somewhere)
2) check if the repository contains code which is compatible with PostgreSQL 11.


HTH

Regard

Ian Barwick



-- 
  Ian Barwick                   https://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

Re: pldbgapi error

From
"Daniel Verite"
Date:
    Prakash Ramakrishnan wrote:

> which code
> will be support for postgresql 11 can you please share me the link or file.

It appears indeed from the error messages that you're trying
to compile an old version.

The lastest version here:
git://git.postgresql.org/git/pldebugger.git
does compile successfully for me with PG11 (Debian 9).


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite