Re: Debugging deadlocks - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Debugging deadlocks
Date
Msg-id 20050403024920.GA30054@winnie.fuhr.org
Whole thread Raw
In response to Re: Debugging deadlocks  (Edmund Bacon <ebacon-xlii@onesystem.com>)
List pgsql-general
On Fri, Apr 01, 2005 at 09:27:40AM -0700, Edmund Bacon wrote:
>
> Speaking of domains, how do you find out what the range of a domain
> is?

I'm not sure if there's a better way, but this appears to work:

SELECT pg_get_constraintdef(oid, TRUE)
FROM pg_constraint
WHERE contypid = 'fruit'::regtype;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: PostgreSQL and .NET
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [HACKERS] plPHP in core?