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

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
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:58:26
Message-ID: Pine.BSF.4.21.0104261057200.20218-100000@megazone23.bigpanda.com
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) ?

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2001-04-26 17:58:35 Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Previous Message Joel Burton 2001-04-26 17:48:45 Re: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?