Date: Thu, 26 Oct 2006 15:33:20 +1000
From: "FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au>
Reply-To: "FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au>
To: pgsql-hackers@postgresql.org
Message-ID: <18387.11451161840784.fast.fujitsu.com.au@MHS>
Subject: pg_get_domaindef()
Organization: FAST
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline

Hi All,

I am now trying to implement pg_get_domaindef() function which is in the TODO 
list and ran into a minor issue.

When the following command is given

CREATE DOMAIN testdomain AS text CONSTRAINT testconstraint NOT NULL;

I couldn't find the CONSTRAINT name ('testconstraint' in this case) being 
stored in the system catalog. Any idea where I can find it?

Or is it acceptable, for the above statement, for pg_get_domaindef() to 
return 

CREATE DOMAIN testdomain AS text CONSTRAINT NOT NULL;

Rgds,
Arul Shaji
This is an email from Fujitsu Australia Software Technology Pty Ltd, ABN 27 003 693 481. It is confidential to the ordinary user of the email address to which it was addressed and may contain copyright and/or legally privileged information. No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive this email in error, please return to sender. Thank you.

If you do not wish to receive commercial email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe@fast.fujitsu.com.au