pg_get_domaindef

From: "FAST PostgreSQL" <fastpgs(at)fast(dot)fujitsu(dot)com(dot)au>
To: pgsql-patches(at)postgresql(dot)org
Subject: pg_get_domaindef
Date: 2007-01-19 15:28:13
Message-ID: 12753.10901169180733.fast.fujitsu.com.au@MHS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi,

Attached is a small patch that implements the pg_get_domaindef(oid) function.

Somethings I am not sure about the patch and which I can fix based on your
input are as follows.

- I have used SPI interface. I saw that in ruleutils some methods make use
of SPI interface whereas others use internal APIs. I wasn't sure about the
reasons. If this is wrong, I can attempt a rewrite using internal APIs.

- This function does not output the constraint name. I couldn't find the
constraint name given by the user as part of the create domain command being
stored in any system catalogs. The entry in pg_constraints store a system
assigned name. But this may be because of my limited knowledge of the
internals.

- documentation. If this patch is good then I can do this later.

There may be other issues, which I will be happy to fix.

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(at)fast(dot)fujitsu(dot)com(dot)au

Attachment Content-Type Size
pg_get_domaindef.patch text/x-diff 8.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-01-19 15:46:02 Re: Windows buildfarm failures
Previous Message Stefan Kaltenbrunner 2007-01-19 15:25:17 Re: Windows buildfarm failures

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2007-01-19 16:36:44 Re: [PATCHES] COPY with no WAL, v2
Previous Message Roman Nowak 2007-01-19 14:50:24 BUG #2913: Subscript on multidimensional array yields no value