Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ? - Mailing list pgsql-general

From Joel Burton
Subject Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Date
Msg-id Pine.LNX.4.21.0104261348040.29630-100000@olympus.scw.org
Whole thread Raw
In response to NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?  ("Christian Marschalek" <cm@chello.at>)
List pgsql-general
On Thu, 26 Apr 2001, Christian Marschalek wrote:

> Can anyone tell me what this notice means?
>
> NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
> check(s) ?

You probably did something like this:

CREATE TABLE child (
  id REFERENCES parent ... )

and PostgreSQL handles this sort of foreign key referential
integrity by using a special kind of trigger.

This notice just lets you know this is happening.



--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington


pgsql-general by date:

Previous
From: "Geoff Caplan"
Date:
Subject: Re: Struggling to change default data location
Next
From: "Gregory Wood"
Date:
Subject: Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?