Skip site navigation (1) Skip section navigation (2)

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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE
Date: 2012-01-22 04:04:20
Message-ID: CAMkU=1zUvFsn4rd5UR6Z5gWA1o0+nO79ne-JYGdhMNbZrJ6kvg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Jeff JanesDate: 2012-01-22 04:40:30
Subject: Re: JSON for PG 9.2
Previous:From: Jeff JanesDate: 2012-01-22 03:32:22
Subject: Re: Review of: explain / allow collecting row counts without timing info

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group