Methods
Public Instance
Public Instance methods
add_exclusion_constraint(elements, opts=OPTS)
Adds an exclusion constraint to an existing table, see CreateTableGenerator#exclude
.
[show source]
# File lib/sequel/adapters/shared/postgres.rb 142 def add_exclusion_constraint(elements, opts=OPTS) 143 @operations << {:op => :add_constraint, :type => :exclude, :elements => elements}.merge!(opts) 144 end
alter_constraint(name, opts=OPTS)
Alter an existing constraint. Options:
:deferrable |
Modify deferrable setting for constraint (PostgreSQL 9.4+):
| ||||||
:enforced |
Set true to use ENFORCED, or false to use NOT ENFORCED (PostgreSQL 18+) | ||||||
:inherit |
Set true to use INHERIT, or false to use NO INHERIT (PostgreSQL 18+) |
[show source]
# File lib/sequel/adapters/shared/postgres.rb 153 def alter_constraint(name, opts=OPTS) 154 @operations << {:op => :alter_constraint, :name => name}.merge!(opts) 155 end
rename_constraint(name, new_name)
:inherit |
Set true to use INHERIT, or false to use NO INHERIT (PostgreSQL 18+) |
[show source]
# File lib/sequel/adapters/shared/postgres.rb 158 def rename_constraint(name, new_name) 159 @operations << {:op => :rename_constraint, :name => name, :new_name => new_name} 160 end
validate_constraint(name)
Validate the constraint with the given name, which should have been added previously with NOT VALID.
[show source]
# File lib/sequel/adapters/shared/postgres.rb 164 def validate_constraint(name) 165 @operations << {:op => :validate_constraint, :name => name} 166 end