Re: NOTICE: CREATE TABLE will create implicit triggers for foreign-key - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: NOTICE: CREATE TABLE will create implicit triggers for foreign-key
Date
Msg-id 3F7AD6F8.50503@bigfoot.com
Whole thread Raw
In response to NOTICE: CREATE TABLE will create implicit triggers for foreign-key checks  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut wrote:> Regarding the NOTICE>> CREATE TABLE will create implicit triggers for foreign-key checks>>
Doesanyone care?
 

I don't care but is a way for a beginner to understand that behind
a foreign key there is a TRIGGER that have not a 0 cost.

> The other "helpful" notices about sequences for serial columns and 
indexes> for unique constraints have some merit, because they inform the user> objects that the user might be
interestedin are going to be created as a> side effect.  But there's nothing that a user can reasonably do with an>
implicittrigger for a foreign-key check.  ISTM that this notice is about> as interesting as the information that CREATE
VIEWwill create an 
 
implicit> rule.

I think that this is a particular implementation of Postgres translate a
View on a Rule, am I wrong ?


BTW shall be nice have this kind of "NOTICE", that may be is better call
"INTERNALS", and switchable off.


Regards
Gaetano Mendola



pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Thoughts on maintaining 7.3
Next
From: "scott.marlowe"
Date:
Subject: Re: Wednesday beta postponed till Thursday