Re: Debugging deadlocks

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Edmund Bacon <ebacon-xlii(at)onesystem(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Debugging deadlocks
Date: 2005-04-03 02:49:20
Message-ID: 20050403024920.GA30054@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-04-03 02:55:18 Re: [HACKERS] plPHP in core?
Previous Message Marc G. Fournier 2005-04-03 02:18:24 Re: PostgreSQL and .NET