Re: NOTICE: CREATE TABLE will create implicit triggers

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: NOTICE: CREATE TABLE will create implicit triggers
Date: 2003-10-02 01:44:49
Message-ID: 3F7B8311.8040900@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut wrote:

> Regarding the NOTICE
>
> CREATE TABLE will create implicit triggers for foreign-key checks
>
> Does anyone care?

I don't.

> 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.

I agree.

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kris Jurka 2003-10-02 02:10:23 Re: PREPARE/EXECUTE across backends?
Previous Message Neil Conway 2003-10-02 01:01:23 Re: PREPARE/EXECUTE across backends?