X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id F0B5730E73C for ; Tue, 10 Jun 2003 19:30:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 31622-03 for ; Tue, 10 Jun 2003 16:30:28 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 7DC1330E967 for ; Tue, 10 Jun 2003 16:30:27 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id B937B10258; Tue, 10 Jun 2003 15:24:25 -0400 (EDT) Received: from [10.0.2.8] (unknown [10.0.2.8]) by mailav.tor1.inquent.com (Postfix) with ESMTP id BE44B10248; Tue, 10 Jun 2003 15:24:23 -0400 (EDT) Subject: Re: how to determine array size From: Rod Taylor To: Forest Wilkinson Cc: pgsql-sql@postgresql.org In-Reply-To: <7c5cev0486tkbu5rdne84cki9fvim3l60n@4ax.com> References: <1055246667.56597.39.camel@jester> <7c5cev0486tkbu5rdne84cki9fvim3l60n@4ax.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-g4Z4DYZ+2QZ5vDbTeGba" Organization: Message-Id: <1055273429.91204.23.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 10 Jun 2003 15:30:29 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Archive-Number: 200306/87 X-Sequence-Number: 13845 --=-g4Z4DYZ+2QZ5vDbTeGba Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > Is pg_get_constraintdef() documented somewhere? I'd like to know it's > arguments, return format, and whether it will be supported in future > postgres releases. Support for it will improve, and it'll be around for a few releases anyway.=20=20 > >From what I see in pg_dump.c, it appears to accept an oid from the > pg_constraint table, and only work with foreign key constraints. > True? That might be useful in some special-case code, but I really > want a method that will work with all types of constraint. (The idea The other types of constraints have been added in 7.4. In fact, it's the only way to fetch an accurate CHECK constraint in 7.4. Miscellaneous functions are documented at: http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D1&file=3Dfunct= ions-misc.html --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-g4Z4DYZ+2QZ5vDbTeGba Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+5jHU6DETLow6vwwRAlGiAJ9vei6BkbcSY8YtubqRFzsOnubtPACeMuSh 8IHbCdQ58mKZ2YyIYiJE0h4= =Nb6n -----END PGP SIGNATURE----- --=-g4Z4DYZ+2QZ5vDbTeGba--