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

On Wed, Jan 4, 2012 at 12:35 PM, Noah Misch <noah(at)leadboat(dot)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(at)postgresql(dot)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-bit
lc_collate | C
lc_ctype | C
max_connections | 100
max_stack_depth | 2MB
server_encoding | SQL_ASCII
shared_buffers | 32MB
TimeZone | US/Pacific
wal_buffers | 1MB

Cheers,

Jeff