Re: Error compile

I too found problems with OIDS when I upgraded to PG12 - they have been removed in this version, and will not return.

To fix the problem, I reverted to my previous PG version

I listed the tables where I was actually using OIDS.
For most of them I added a serial field
alter table TAB_NAME add r_id int GENERATED ALWAYS AS IDENTITY;
and reviewed all the INSERT statements, to name the columns specifically,
and all the LIKE statements, and the SELECTs,
replacing all use of rowid/oid to use the new column r_id.
Finally 
alter table TAB_NAME SET WITHOUT OIDS;

And then ran the last command for all the tables where I had no explicit use of rowid/oid

Changing the 4GL took a lot longer than changing the database tables,
but I'm now running OIDS-free, and ready to upgrade again to PG12

-- 
Bernard Moreton


On Fri, 16 Oct 2020 11:57:59 -0400
Gerardo Valenotti <[email protected]> wrote:

> Hi all
> 
> i'm using postgresql 12 and i have some problems with OIDS
> I update to revision 12718 and compilation has this error
> 
> gmake[1]: Entering directory '/home/instalaciones/aubit4gl/trunk/tools/asql'
> 4glpc  -fbounds-checking    -t EC -td POSTGRES -o pg_asql.ao -g
> -versioned -c asql.4gl
> Error : Required setting ('PG_ESQLC') has not been set
> Error : Required setting ('PG_ESQLC') has not been set
> WARNING : -fbounds-checking not recognised - passing to C-compiler/Linker
> Error compiling asql.cpc
> Exit program..        127
> gmake[1]: *** [Makefile:303: pg_asql.ao] Error 127
> gmake[1]: Leaving directory '/home/instalaciones/aubit4gl/trunk/tools/asql'
> make: *** [Makefile:300: corecompile] Error 2
> 
> Thanks in advance


-- 
Bernard Moreton