Re: Avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE

On Wed, Jan 4, 2012 at 12:35 PM, Noah Misch <noah@leadboat.com> wrote:
> I neglected to commit after revising the text of a few comments; use this
> version instead.  Thanks.
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>

This is failing "make check" for me.


*** /tmp/foo/src/test/regress/expected/alter_table.out  Sat Jan 21 19:51:46 2012
--- /tmp/foo/src/test/regress/results/alter_table.out   Sat Jan 21 19:54:18 2012
***************
*** 1662,1667 ****
--- 1662,1668 ---- NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"norewrite1_parent_pkey" for table "norewrite1_parent" DEBUG:  building index "norewrite1_parent_pkey" on table
"norewrite1_parent"CREATE TABLE norewrite1_child(c text REFERENCES norewrite1_parent); 
+ DEBUG:  building index "pg_toast_41491_index" on table "pg_toast_41491" ALTER TABLE norewrite1_child ALTER c TYPE
varchar;-- recheck FK DEBUG:  validating foreign key constraint "norewrite1_child_c_fkey" CREATE DOMAIN other_int AS
int;


Settings:
     name       |                                              current_setting

-----------------+------------------------------------------------------------------------------------------------------------version
       | PostgreSQL 9.2devel on x86_64-unknown-linux-gnu, 
compiled by gcc (GCC) 4.1.2 20070115 (SUSE Linux), 64-bitlc_collate      | Clc_ctype        | Cmax_connections |
100max_stack_depth| 2MBserver_encoding | SQL_ASCIIshared_buffers  | 32MBTimeZone        | US/Pacificwal_buffers     |
1MB



Cheers,

Jeff