Skip site navigation (1) Skip section navigation (2)

Re: Reconstructing FKs in pg_dump

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Reconstructing FKs in pg_dump
Date: 2002-09-28 03:03:25
Message-ID: 008b01c2669b$9d369800$0a00a8c0@zeut2k (view raw or flat)
Thread:
Lists: pgsql-hackers
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> However, if we are going to put that kind of knowledge into pg_dump,
> it would only be a small further step to have it dump these triggers
> as ALTER TABLE ADD CONSTRAINT commands instead.  Which would be a lot
> better for forward compatibility than dumping the raw triggers.

There was some talk of adding Rod Taylor's identifies upgrade script to
contrib, or mentioning it in the release.  I think that it upgrades Foreign
key, Unique, and Serial constraints, is that relevant here?  Could it be
used (or modified) to handle this situation?  Just a thought.

In response to

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2002-09-28 04:39:27
Subject: version mismatch detection doesn't work
Previous:From: Martijn van OosterhoutDate: 2002-09-28 02:05:58
Subject: Re: query speed depends on lifetime of frozen db?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group