Short-circuiting FK check for a newly-added field - Mailing list pgsql-general

From Decibel!
Subject Short-circuiting FK check for a newly-added field
Date
Msg-id AA5FB9A8-42DA-4D9C-8D9C-2DCFD0C55376@decibel.org
Whole thread Raw
Responses Re: Short-circuiting FK check for a newly-added field  (David Fetter <david@fetter.org>)
List 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@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Attachment

pgsql-general by date:

Previous
From: Reece Hart
Date:
Subject: Re: how to modify a view
Next
From: "Scott Marlowe"
Date:
Subject: Re: best er modeling tool for postgreSQL