Short-circuiting FK check for a newly-added field

From: Decibel! <decibel(at)decibel(dot)org>
To: Postgres List <pgsql-general(at)postgresql(dot)org>
Subject: Short-circuiting FK check for a newly-added field
Date: 2008-05-20 18:25:15
Message-ID: AA5FB9A8-42DA-4D9C-8D9C-2DCFD0C55376@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to add a field to a fairly large table. In the same alter
statement I'd like to add a FK constraint on that new field. Is there
any way to avoid the check of the table that the database is doing
right now? The check is pointless because the newly added field is
nothing but NULLs.

This is version 8.1.mumble.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2008-05-20 18:31:36 intermittent problems with ident authentication
Previous Message Scott Marlowe 2008-05-20 17:42:50 Re: Server Configuration