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

pgsql: Minor improvements to code for converting legacy CREATE

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Minor improvements to code for converting legacy CREATE
Date: 2007-11-04 21:25:55
Message-ID: 20071104212555.2678A754229@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Minor improvements to code for converting legacy CREATE CONSTRAINT TRIGGER
commands into proper foreign-key constraints.  Believe the constraint name
given in the trigger arguments in preference to the trigger name --- to judge
from Olivier Prenant's example, pg_dump must at some time have used the
autogenerated trigger name there, though AFAICT no current release branch tip
does.  Improve the emitted NOTICEs to provide more detail (PK table's name and
column names).  Handle the case where pg_dump forgot to provide the FROM table
(a bug that never did get fixed in 7.0.x apparently).  This commit doesn't
do anything about the question of what to do with incomplete trigger groups.

Modified Files:
--------------
    pgsql/src/backend/commands:
        trigger.c (r1.220 -> r1.221)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/trigger.c?r1=1.220&r2=1.221)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2007-11-04 21:40:02
Subject: pgsql: Document possible problems with NFS tablespaces.
Previous:From: Bruce MomjianDate: 2007-11-04 19:43:33
Subject: pgsql: Properly indent tablespace SGML section.

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