Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?

From: Joel Burton <jburton(at)scw(dot)org>
To: Christian Marschalek <cm(at)chello(dot)at>
Cc: "[GENERAL] PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Date: 2001-04-26 17:48:45
Message-ID: Pine.LNX.4.21.0104261348040.29630-100000@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-04-26 17:58:26 Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Previous Message Josh Berkus 2001-04-26 17:42:54 No JOINs in UPDATE ... FROM?