From: | Edmund Bacon <ebacon-xlii(at)onesystem(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Debugging deadlocks |
Date: | 2005-04-01 16:27:40 |
Message-ID: | m3d5tesbr7.fsf@elb_lx.onesystem.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
bruno(at)wolff(dot)to (Bruno Wolff III) writes:
> Using domains is a good way to keep column constraints in just one place.
>
Speaking of domains, how do you find out what the range of a domain
is?
eg:
test=# create domain fruit as text
check( value in ('apple', 'orange', 'banana', 'pear'));
CREATE DOMAIN
test=# \dD fruit
List of domains
Schema | Name | Type | Modifier
--------+-------+------+----------
public | fruit | text |
(1 row)
test=# \dD+ fuit
List of domains
Schema | Name | Type | Modifier
--------+-------+------+----------
public | fruit | text |
(1 row)
A quick look through pg_catalog doesn't suggest anything that would
return the check conditions - Is there any way to do this?
--
Remove -42 for email
From | Date | Subject | |
---|---|---|---|
Next Message | David Link | 2005-04-01 17:21:23 | diskspace usage recovered on db rebuild |
Previous Message | Michael Fuhr | 2005-04-01 16:27:35 | Re: : Postgres order by into a RECORD, not ordering |