pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Koczan <pjkoczan@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: Legacy foreign keys
Date: Fri, 01 Feb 2008 00:55:49 -0500
Message-ID: <18279.1201845349@sss.pgh.pa.us> (raw)
In-Reply-To: <4544e0330801311613t5cc6741cx1464947c2215f198@mail.gmail.com>
References: <4544e0330712101112r6aeccfcckef378a7ea1795e07@mail.gmail.com>
	<20071210195046.GE27126@alvh.no-ip.org>
	<20427.1197324492@sss.pgh.pa.us>
	<4544e0330712111901k1fa50c5dgb26287aff018e98c@mail.gmail.com>
	<10859.1197428770@sss.pgh.pa.us>
	<4544e0330712120940i413e3ad6y867fc2a8744f623b@mail.gmail.com>
	<4544e0330801311613t5cc6741cx1464947c2215f198@mail.gmail.com>

"Peter Koczan" <pjkoczan@gmail.com> writes:
> I finally found more time to test this more extensively. i'm still
> running into an issue with this, although it's different this time.
> There are no errors printed to the terminal, but neither the foreign
> key nor the trigger get made.

It looks like you are trying to restore from a selective dump (-t
switch) that includes only one of the two tables involved in the FK
constraint.  The backend logic for converting triggers to proper FK
constraints can only work if it sees both tables (and their triggers)
created during a single session.

			regards, tom lane



view thread (15+ messages)  latest in thread

Message-ID: <18279.1201845349@sss.pgh.pa.us>
Permalink:  ../18279.1201845349@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/18279.1201845349@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pjkoczan@gmail.com, alvherre@alvh.no-ip.org
  Subject: Re: Legacy foreign keys
  In-Reply-To: <18279.1201845349@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox