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

From Peter Eisentraut
Subject NOTICE: CREATE TABLE will create implicit triggers for foreign-key checks
Date
Msg-id Pine.LNX.4.44.0310011230240.2932-100000@peter.localdomain
Whole thread Raw
Responses Re: NOTICE: CREATE TABLE will create implicit triggers for foreign-key  (Gaetano Mendola <mendola@bigfoot.com>)
Re: NOTICE: CREATE TABLE will create implicit triggers for foreign-key checks  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: NOTICE: CREATE TABLE will create implicit triggers  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: NOTICE: CREATE TABLE will create implicit triggers  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Regarding the NOTICE

CREATE TABLE will create implicit triggers for foreign-key checks

Does anyone care?

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 interested in are going to be created as a
side effect.  But there's nothing that a user can reasonably do with an
implicit trigger for a foreign-key check.  ISTM that this notice is about
as interesting as the information that CREATE VIEW will create an implicit
rule.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: James Rogers
Date:
Subject: Index/Function organized table layout
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Thoughts on maintaining 7.3