1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
-- ==============================================================
-- GNUmed database schema change script
--
-- License: GPL v2 or later
-- Author: karsten.hilbert@gmx.net
--
-- ==============================================================
\set ON_ERROR_STOP 1
--set default_transaction_read_only to off;
-- --------------------------------------------------------------
drop view if exists dem.v_basic_person cascade;
create or replace view dem.v_basic_person as
select d_vap.*
from dem.v_active_persons d_vap;
comment on view dem.v_basic_person is
'DEPRECATED (use dem.v_active_persons): This view denormalizes non-deleted persons with their active name.';
revoke all on dem.v_basic_person from public;
grant select on dem.v_basic_person to group "gm-public";
-- --------------------------------------------------------------
select gm.log_script_insertion('v21-dem-v_basic_person.sql', '21.0');
|
