This file is indexed.

/usr/share/pgmodeler/schemas/alter/domain.sch is in pgmodeler-common 0.9.1~beta-1.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

 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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
# SQL definition for domain's attributes change
# PostgreSQL Version: 9.x
# CAUTION: Do not modify this file unless you know what you are doing.
#          Code generation can be broken if incorrect changes are made.

#Changing default value
%if {default-value} %then
  [ALTER ] {sql-object} $sp {signature} 

  %if ({default-value} == "unset") %then
    [ DROP DEFAULT]
  %else
    [ SET DEFAULT ] {default-value}
  %end
  ; $br
  [-- ddl-end --] $br
%end

#Changing NOT NULL constraint
%if {not-null} %then
  [ALTER ] {sql-object} $sp {signature} 

  %if ({not-null} == "unset") %then
    [ DROP ]
  %else
    [ SET ]
  %end
  
  [NOT NULL;] $br
  [-- ddl-end --] $br
%end

#Changing CHECK expression
%if {expression} %then
  [ALTER ] {sql-object} $sp {signature} 

  %if ({expression} == "unset") %then
    [ DROP CONSTRAINT ]
  %else
    [ ADD CONSTRAINT ]
  %end
  
  %if {constraint} %then
    {constraint}
  %end
  
  %if ({expression} != "unset") %then
    $sp CHECK({expression})
  %end
  
  ; $br
  [-- ddl-end --] $br
%end

#Changing constraint name (only in 9.2 or above)
%if ({pgsql-ver} >=f "9.2") %and {old-name} %and {new-name} %then
  [ALTER ] {sql-object} $sp {signature} 
  [ RENAME CONSTRAINT ] {old-name} [ TO ] {new-name} ; $br
  [-- ddl-end --] $br
%end