Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephan Szabo
Subject Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Date
Msg-id Pine.BSF.4.21.0104261057200.20218-100000@megazone23.bigpanda.com
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
Tree view 
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) ?

The foreign key constraint checks are handled by triggers on the
pk and fk table.  The warning just lets you know that it's creating
those triggers behind your back so to speak.

pgsql-general by date:

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