*** /home/postgres/postgresql-9.3.2/contrib/sepgsql/expected/label.out	2013-12-03 00:57:48.000000000 +0400
--- /home/postgres/postgresql-9.3.2/contrib/sepgsql/results/label.out	2013-12-18 16:18:45.279277035 +0400
***************
*** 85,106 ****
      WHERE provider = 'selinux' AND objtype = 'column' AND (objname like 't3.%' OR objname like 't4.%');
   objtype |   objname   |                     label                     
  ---------+-------------+-----------------------------------------------
-  column  | t3.t        | unconfined_u:object_r:user_sepgsql_table_t:s0
-  column  | t3.s        | unconfined_u:object_r:user_sepgsql_table_t:s0
-  column  | t3.ctid     | unconfined_u:object_r:user_sepgsql_table_t:s0
-  column  | t3.xmin     | unconfined_u:object_r:user_sepgsql_table_t:s0
-  column  | t3.cmin     | unconfined_u:object_r:user_sepgsql_table_t:s0
-  column  | t3.xmax     | unconfined_u:object_r:user_sepgsql_table_t:s0
-  column  | t3.cmax     | unconfined_u:object_r:user_sepgsql_table_t:s0
   column  | t3.tableoid | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t4.n        | unconfined_u:object_r:sepgsql_table_t:s0
!  column  | t4.m        | unconfined_u:object_r:sepgsql_table_t:s0
!  column  | t4.ctid     | unconfined_u:object_r:sepgsql_sysobj_t:s0
!  column  | t4.xmin     | unconfined_u:object_r:sepgsql_sysobj_t:s0
!  column  | t4.cmin     | unconfined_u:object_r:sepgsql_sysobj_t:s0
!  column  | t4.xmax     | unconfined_u:object_r:sepgsql_sysobj_t:s0
!  column  | t4.cmax     | unconfined_u:object_r:sepgsql_sysobj_t:s0
   column  | t4.tableoid | unconfined_u:object_r:sepgsql_sysobj_t:s0
  (16 rows)
  
  --
--- 85,106 ----
      WHERE provider = 'selinux' AND objtype = 'column' AND (objname like 't3.%' OR objname like 't4.%');
   objtype |   objname   |                     label                     
  ---------+-------------+-----------------------------------------------
   column  | t3.tableoid | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t3.cmax     | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t3.xmax     | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t3.cmin     | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t3.xmin     | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t3.ctid     | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t3.s        | unconfined_u:object_r:user_sepgsql_table_t:s0
!  column  | t3.t        | unconfined_u:object_r:user_sepgsql_table_t:s0
   column  | t4.tableoid | unconfined_u:object_r:sepgsql_sysobj_t:s0
+  column  | t4.cmax     | unconfined_u:object_r:sepgsql_sysobj_t:s0
+  column  | t4.xmax     | unconfined_u:object_r:sepgsql_sysobj_t:s0
+  column  | t4.cmin     | unconfined_u:object_r:sepgsql_sysobj_t:s0
+  column  | t4.xmin     | unconfined_u:object_r:sepgsql_sysobj_t:s0
+  column  | t4.ctid     | unconfined_u:object_r:sepgsql_sysobj_t:s0
+  column  | t4.m        | unconfined_u:object_r:sepgsql_table_t:s0
+  column  | t4.n        | unconfined_u:object_r:sepgsql_table_t:s0
  (16 rows)
  
  --
***************
*** 193,203 ****
  (1 row)
  
  SELECT sepgsql_setcon(NULL);	-- failed to reset
! ERROR:  SELinux: security policy violation
  SELECT sepgsql_getcon();
                    sepgsql_getcon                  
  --------------------------------------------------
!  unconfined_u:unconfined_r:unconfined_t:s0:c0.c15
  (1 row)
  
  BEGIN;
--- 193,207 ----
  (1 row)
  
  SELECT sepgsql_setcon(NULL);	-- failed to reset
!  sepgsql_setcon 
! ----------------
!  t
! (1 row)
! 
  SELECT sepgsql_getcon();
                    sepgsql_getcon                  
  --------------------------------------------------
!  unconfined_u:unconfined_r:unconfined_t:s0:c0.c25
  (1 row)
  
  BEGIN;
***************
*** 270,276 ****
  SELECT sepgsql_getcon();		-- should be 's0:c0.c15'
                    sepgsql_getcon                  
  --------------------------------------------------
!  unconfined_u:unconfined_r:unconfined_t:s0:c0.c15
  (1 row)
  
  BEGIN;
--- 274,280 ----
  SELECT sepgsql_getcon();		-- should be 's0:c0.c15'
                    sepgsql_getcon                  
  --------------------------------------------------
!  unconfined_u:unconfined_r:unconfined_t:s0:c0.c25
  (1 row)
  
  BEGIN;
***************
*** 350,370 ****
  (1 row)
  
  SELECT f5('unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c31');	-- Failed
! ERROR:  SELinux: security policy violation
! CONTEXT:  SQL function "f5" statement 1
  SELECT sepgsql_getcon();
!                       sepgsql_getcon                       
! -----------------------------------------------------------
!  unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c7
  (1 row)
  
  SELECT f5(NULL);	-- Failed
! ERROR:  SELinux: security policy violation
! CONTEXT:  SQL function "f5" statement 1
  SELECT sepgsql_getcon();
!                       sepgsql_getcon                       
! -----------------------------------------------------------
!  unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c7
  (1 row)
  
  BEGIN;
--- 354,380 ----
  (1 row)
  
  SELECT f5('unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c31');	-- Failed
!  f5 
! ----
!  t
! (1 row)
! 
  SELECT sepgsql_getcon();
!                        sepgsql_getcon                       
! ------------------------------------------------------------
!  unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c31
  (1 row)
  
  SELECT f5(NULL);	-- Failed
!  f5 
! ----
!  t
! (1 row)
! 
  SELECT sepgsql_getcon();
!                        sepgsql_getcon                       
! ------------------------------------------------------------
!  unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c15
  (1 row)
  
  BEGIN;
***************
*** 382,390 ****
  
  ABORT;
  SELECT sepgsql_getcon();
!                       sepgsql_getcon                       
! -----------------------------------------------------------
!  unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c7
  (1 row)
  
  --
--- 392,400 ----
  
  ABORT;
  SELECT sepgsql_getcon();
!                        sepgsql_getcon                       
! ------------------------------------------------------------
!  unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c15
  (1 row)
  
  --

======================================================================

