IDS Forum

Re: False non-exclusive access when select a table

Posted By: ROGER VILCA
Date: Tuesday, 26 April 2016, at 6:04 p.m.

In Response To: Re: False non-exclusive access when select a table (Fernando Nunes)

No, there is no any trigger.

This is the dbschema of the table:

{ TABLE "xsic".transfbod row size = 417 number of columns = 41 index size = 86 }

create table "xsic".transfbod
(

empresa char(10)

default '3',

folio char(6) not null constraint "xsic".n11988_41214,

fecha char(8) not null constraint "xsic".n11988_41215,

bodega char(3) not null ,

bodega_dirigida char(3) not null ,

tipo char(1),

estado char(1) not null constraint "xsic".n11988_41218,

nomrol char(45),

fecha_apr char(8),

estado_contab char(1),

ultima_mod char(16),

tran_estado char(1),

tran_fec_con date,

doc_tip_com char(10),

doc_nro_com decimal(10,0),

rol char(20),

despacho char(6),

fecha_des char(8),

tipo_comprobante char(10),

fecont char(8),

correlativo char(10),

cr_responsable char(4) not null constraint "xsic".n11988_41219,

cr_destino char(4) not null constraint "xsic".n11988_41220,

emp_externa char(10),

cr_responsable_pro char(4),

cr_destino_pro char(4),

emp_externa_pro char(10),

aud_ing_rol char(10),

aud_ing_fec datetime year to second,

aud_apr_rol char(10),

aud_apr_fec datetime year to second,

aud_des_rol char(10),

aud_des_fec datetime year to second,

aud_anu_rol char(10),

aud_anu_fec datetime year to second,

ind_exacto char(1),

sol_tipo char(1),

sol_folio char(6),

sol_fecha char(8),

fecha_aprobacion datetime year to second,

observaciones char(100)
);

revoke all on "xsic".transfbod from "public" as "xsic";

grant select on "xsic".transfbod to "avb2009" as "xsic";
grant update on "xsic".transfbod to "avb2009" as "xsic";
grant insert on "xsic".transfbod to "avb2009" as "xsic";
grant delete on "xsic".transfbod to "avb2009" as "xsic";
grant select on "xsic".transfbod to "luz" as "xsic";
grant update on "xsic".transfbod to "luz" as "xsic";
grant insert on "xsic".transfbod to "luz" as "xsic";
grant delete on "xsic".transfbod to "luz" as "xsic";
grant select on "xsic".transfbod to "sistec" as "xsic";
grant select on "xsic".transfbod to "sistec1a" as "xsic";
grant update on "xsic".transfbod to "sistec1a" as "xsic";
grant insert on "xsic".transfbod to "sistec1a" as "xsic";
grant delete on "xsic".transfbod to "sistec1a" as "xsic";
grant select on "xsic".transfbod to "sistec1p" as "xsic";
grant select on "xsic".transfbod to "sisteca" as "xsic";
grant update on "xsic".transfbod to "sisteca" as "xsic";
grant insert on "xsic".transfbod to "sisteca" as "xsic";
grant delete on "xsic".transfbod to "sisteca" as "xsic";
grant select on "xsic".transfbod to "xsica" as "xsic";
grant update on "xsic".transfbod to "xsica" as "xsic";
grant insert on "xsic".transfbod to "xsica" as "xsic";
grant delete on "xsic".transfbod to "xsica" as "xsic";
grant select on "xsic".transfbod to "xsiccon" as "xsic";
grant update on "xsic".transfbod to "xsiccon" as "xsic";
grant insert on "xsic".transfbod to "xsiccon" as "xsic";
grant delete on "xsic".transfbod to "xsiccon" as "xsic";
grant select on "xsic".transfbod to "xsiccona" as "xsic";
grant update on "xsic".transfbod to "xsiccona" as "xsic";
grant insert on "xsic".transfbod to "xsiccona" as "xsic";
grant delete on "xsic".transfbod to "xsiccona" as "xsic";
grant select on "xsic".transfbod to "xsicconp" as "xsic";
grant select on "xsic".transfbod to "xsicp" as "xsic";
grant select on "xsic".transfbod to "xsictec" as "xsic";
grant update on "xsic".transfbod to "xsictec" as "xsic";
grant insert on "xsic".transfbod to "xsictec" as "xsic";
grant delete on "xsic".transfbod to "xsictec" as "xsic";
grant select on "xsic".transfbod to "xsictecp" as "xsic";

create index "xsic".idx_transf on "xsic".transfbod (sol_folio,

sol_fecha,sol_tipo) using btree ;
create unique index "xsic".transfbod_idx on "xsic".transfbod (folio,

fecha,empresa) using btree ;
create index "xsic".transfbod_idx1 on "xsic".transfbod (fecha_apr,

folio,fecha,empresa) using btree ;

It may be some lock "hold" in memory ?

Messages In This Thread

• False non-exclusive access when select a table
  ROGER VILCA -- Tuesday, 26 April 2016, at 5:31 p.m.
  • Re: False non-exclusive access when select a table
    Andreas Legner -- Tuesday, 26 April 2016, at 5:40 p.m.
    • Re: False non-exclusive access when select a table
      ROGER VILCA -- Tuesday, 26 April 2016, at 5:50 p.m.
      • Re: False non-exclusive access when select a table
        Fernando Nunes -- Tuesday, 26 April 2016, at 5:55 p.m.
        • Re: False non-exclusive access when select a table
          ROGER VILCA -- Tuesday, 26 April 2016, at 6:04 p.m.
          • Re: False non-exclusive access when select a table
            Andreas Legner -- Wednesday, 27 April 2016, at 4:50 a.m.
            • Re: False non-exclusive access when select a table
              ROGER VILCA -- Wednesday, 27 April 2016, at 12:06 p.m.
  • Re: False non-exclusive access when select a table
    WOLFGANG EPPLER -- Wednesday, 27 April 2016, at 5:45 a.m.
    • Re: False non-exclusive access when select a table
      Fernando Nunes -- Wednesday, 27 April 2016, at 6:25 a.m.
      • Re: False non-exclusive access when select a table
        ROGER VILCA -- Wednesday, 27 April 2016, at 11:45 a.m.
        • Re: False non-exclusive access when select a table
          Fernando Nunes -- Wednesday, 27 April 2016, at 12:07 p.m.
          • Re: False non-exclusive access when select a table
            ROGER VILCA -- Wednesday, 27 April 2016, at 12:13 p.m.
            • Re: False non-exclusive access when select a table
              Fernando Nunes -- Wednesday, 27 April 2016, at 12:46 p.m.
              • Re: False non-exclusive access when select a table
                ROGER VILCA -- Wednesday, 27 April 2016, at 1:01 p.m.
                • Re: False non-exclusive access when select a table
                  Fernando Nunes -- Wednesday, 27 April 2016, at 1:15 p.m.
                  • Re: False non-exclusive access when select a table
                    ROGER VILCA -- Wednesday, 27 April 2016, at 1:20 p.m.
                    • Re: False non-exclusive access when select a table
                      WOLFGANG EPPLER -- Thursday, 28 April 2016, at 3:33 a.m.
                      • Re: False non-exclusive access when select a table
                        Fernando Nunes -- Thursday, 28 April 2016, at 6:11 a.m.
                      • Re: False non-exclusive access when select a table
                        ROGER VILCA -- Thursday, 28 April 2016, at 12:20 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.