<div dir="ltr">Hello all,<div><br></div><div>While opening postgis tables and views in QGIS 2.0 (windows 7 64bit), I noticed some different behaviors whether I use DBManager or Add Postgis Layer.</div><div><br></div><div>Opening with DBManager creates lots of locks in postgres (see below), that are only released when QGIS is closed. During the lock, it seems impossible to alter specific tables or views.</div>
<div><br></div><div>For instance, having layer "One" and Layer "two" in QGIS, both tables added from DBManager, I am not being able to run a trigger to update table "two" whenever I commit a change in a table "one". If layer two is added using "Add Postgis Layer" this problem does not occur.</div>
<div><br></div><div>Is this expected? <br></div><div><br></div><div>Best Regards</div><div><br></div><div>Alexandre Neto</div><div><br></div><div><br></div><div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_constraint_conname_nsp_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_constraint<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>17044<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_type<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_attribute<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_description_o_c_o_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_namespace_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_namespace_nspname_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_description<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_namespace<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_class_relname_nsp_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_class_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_class<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_proc_proname_args_nsp_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_proc_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_proc<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>ExclusiveLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_attrdef<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_statistic<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_rewrite_rel_rulename_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_type_typname_nsp_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_rewrite_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_index_indrelid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_type_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_attrdef_adrelid_adnum_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_rewrite<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_attrdef_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_constraint_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>pg_authid_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_rules<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_trigger<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_statistic_relid_att_inh_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_attribute_relid_attnum_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_constraint_contypid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_shadow<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_trigger_tgrelid_tgname_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_index_indexrelid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_attribute_relid_attnam_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>17488<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>pg_authid_rolname_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_trigger_oid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_user<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>pg_db_role_setting<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>16634<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>pg_authid<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>16641<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_trigger_tgconstraint_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>pg_db_role_setting_databaseid_rol_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div><div>2256<span class="" style="white-space:pre"> </span>postgis<span class="" style="white-space:pre"> </span>pg_constraint_conrelid_index<span class="" style="white-space:pre"> </span>postgres<span class="" style="white-space:pre"> </span>6/14139<span class="" style="white-space:pre"> </span>AccessShareLock<span class="" style="white-space:pre"> </span>Sim<span class="" style="white-space:pre"> </span>2013-10-21 16:29:29+01<span class="" style="white-space:pre"> </span>SELECT rulename, definition FROM pg_rules</div>
<div><span class="" style="white-space:pre"> </span>WHERE tablename='sgev' AND schemaname='epvu' <span class="" style="white-space:pre"> </span></div></div><div><br></div></div>