Re: Compiling table_log for PG 11 / attisdropped

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Compiling table_log for PG 11 / attisdropped
Date: 2019-07-13 00:38:59
Message-ID: CAD3a31W9MR==_zraj68O+siwvcsLUv-qyK7AjRMZNLTR4+9a+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 12, 2019 at 1:42 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 7/12/19 1:19 PM, Ken Tanzer wrote:
> > Hi. I'm trying to update some databases from 9.6 to 11, and they use
> > table_log for tracking changes to tables.
> >
> > I started with the most recent version I could find, a fork labeled
> > version 0.5. [1]
>
> What OS.version and compiler/version?
>
> Well it was Centos 7. I'm not quite sure what I was using at the time I
asked, though I think it would have been whatever was generically part of
Centos 7. I ended up having to install serveral packages (llvm5.0,
centos-release-scl, llvm-toolset-7 & devtoolset-7) when the compiler was
giving errors trying to move from table_log.so to table_log.bc.

> Some digging found the below, which is similar:
>
> https://trac.osgeo.org/postgis/ticket/3814
>
> https://trac.osgeo.org/postgis/changeset/15653
> >
> > if (!tupleDesc->attrs[i]->attisdropped)
>
> If I am following the issue correctly then the above becomes:
>
> if (!tupleDesc->attrs[i].attisdropped)
>
> > if (trigdata->tg_relation->rd_att->attrs[col_nr - 1]->attisdropped)
>
> and above becomes:
>
> *[col_nr - 1].attisdropped

That stopped the errors. Thanks for your help!

Ken

> --
>
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Inoue, Hiroshi 2019-07-13 00:53:12 Re: Postgresql and VBA - Connection Timeout
Previous Message Alvaro Herrera 2019-07-12 22:23:43 Re: How to extract information from pg_ddl_command type