Received: from actarg.com ([209.180.91.25]) by hub.org (8.10.1/8.10.1) with ESMTP id e6OGUQh26180 for ; Mon, 24 Jul 2000 12:30:27 -0400 (EDT) Received: from chi.actarg.com (IDENT:root@chi.actarg.com [192.168.2.16]) by actarg.com (8.9.3/8.9.3) with ESMTP id KAA22574 for ; Mon, 24 Jul 2000 10:30:26 -0600 Received: from actarg.com (IDENT:kyle@localhost [127.0.0.1]) by chi.actarg.com (8.9.3/8.9.3) with ESMTP id KAA13821 for ; Mon, 24 Jul 2000 10:30:25 -0600 Message-ID: <397C6F21.C434805A@actarg.com> Date: Mon, 24 Jul 2000 10:30:25 -0600 From: Kyle Organization: Action Target Inc. X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: altering column constraints Content-Type: multipart/mixed; boundary="------------67C43AEFEC5AB8B3C06EC97C" X-Archive-Number: 200007/225 This is a multi-part message in MIME format. --------------67C43AEFEC5AB8B3C06EC97C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is it possible to alter a column check constraint without a dump/reload? Now that I have RI working, it is a little more tricky to dump/reload a single table because you lose reference triggers. So I'm not sure how to change a column constraint without dumping/reloading the entire database. I looked at editing pg_relcheck directly. I don't know if that is legal or not, but the rcbin column worries me as I'm not sure how/when this gets derived from the rcsrc column. Anyone know if this is possible to do (even if it requires some poking around)? --------------67C43AEFEC5AB8B3C06EC97C Content-Type: text/x-vcard; charset=us-ascii; name="kyle.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Kyle Content-Disposition: attachment; filename="kyle.vcf" begin:vcard n:Bateman;Kyle x-mozilla-html:FALSE org:Action Target Inc. adr:;;;;;; version:2.1 email;internet:kyle@actarg.com title:President x-mozilla-cpt:;0 fn:Kyle Bateman end:vcard --------------67C43AEFEC5AB8B3C06EC97C--