Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL DOMAIN Drop

DROP DOMAIN removes a domain. Only the owner of a domain can remove it

Syntax:
DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
parameter
Explanation
IF EXISTS
Do not throw an error if the domain does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of an existing domain.
CASCADE
Automatically drop objects that depend on the domain (such as table columns).
RESTRICT
Refuse to drop the domain if any objects depend on it. This is the default
 Examples:
To remove the domain postal_code:
Step 1. list out the Dmain using "\dD"
postgres=# \dD
                                                                       List of domains
 Schema |    Name     |         Type          |                 Modifier                  |                 
             Check                               
--------+-------------+-----------------------+-------------------------------------------+------------------------------------------------------------------
 public | addrtype    | character varying(90) | not null default 'N/A'::character varying | 
 public | idxtype     | integer               |                                           | CHECK (VALUE > 10 AND VALUE < 99)
 public | postal_code | text                  |                                           | CHECK (VALUE ~ '^\d{5}$'::text OR VALUE ~ '^\d{5}-\d{4}$'::text)
(3 rows)
Step 2.Now Let us Drop the Domain if you want to drop "addrtype" domain you need to specify "cascade" keyword otherwise it will throw errors here startingly i gave "drop domain addrtype" without "cascade" keyword for your understanding this will be throw error after that i gave "cascade" keyword why it throw error because other objects depend on it so use "CASCADE" to drop the dependent objects too
postgres=# drop domain addrtype;
ERROR:  cannot drop type addrtype because other objects depend on it
DETAIL:  table place column address depends on type addrtype
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
Step 3.Now use drop domain with cascade option
postgres=# drop domain addrtype cascade;
NOTICE:  drop cascades to table place column address
DROP DOMAIN
Step 4.Now check domain
postgres=# \dD                          
                                               List of domains
 Schema |    Name     |  Type   | Modifier |                              Check                             
  
--------+-------------+---------+----------+------------------------------------------------------------------
 public | idxtype     | integer |          | CHECK (VALUE > 10 AND VALUE < 99)
 public | postal_code | text    |          | CHECK (VALUE ~ '^\d{5}$'::text OR VALUE ~ '^\d{5}-\d{4}$'::text)
(2 rows)


Comments

Popular posts from this blog

Oracle DBMS SCHEDULER Examples

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

vacuumlo - removing large objects orphans from a database PostgreSQL