Re: [GENERAL] Short-circuiting FK check for a newly-added field

2008-05-23 Thread Alvaro Herrera
Reece Hart wrote: On Tue, May 20, 2008 at 02:25:15PM -0400, Decibel! wrote: 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?

Re: [GENERAL] Short-circuiting FK check for a newly-added field

2008-05-22 Thread Reece Hart
On Tue, May 20, 2008 at 02:25:15PM -0400, Decibel! wrote: 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

Re: [GENERAL] Short-circuiting FK check for a newly-added field

2008-05-21 Thread David Fetter
On Tue, May 20, 2008 at 02:25:15PM -0400, Decibel! wrote: 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

[GENERAL] Short-circuiting FK check for a newly-added field

2008-05-20 Thread Decibel!
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.