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 Gregory Wood
Subject Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Date
Msg-id 00bb01c0ce7a$848dc770$7889ffcc@comstock.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>)
Responses RE: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
List pgsql-general
Tree view 
> Can anyone tell me what this notice means?
>
> NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
> check(s) ?

It means that PostgreSQL will automatically create triggers to perform your
foreign key checks :)

Seriously though, PostgreSQL has to have some mechanism to check that your
foreign key values exist (or not), and it does that by using a feature
already built into PostgreSQL: triggers. Nothing you really need to worry
about unless you are doing something fancy (for instance, disabling all
triggers on either table to accomplish some action... in such a case your
foreign key relationship might be broken).

Greg

pgsql-general by date:

Previous
From: Joel Burton
Date:
Subject: Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Next
From: Stephan Szabo
Date:
Subject: Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?